SQL Server Data Warehouse/ETL Engineer

Dedham, MA | Perm

Post Date: 06/29/2018 Job ID: 226461 Industry: IT
SQL Server Data Warehouse/ETL Engineer
Location: Dedham, MA
Duration: permanent

Software Development is looking for a driven, pragmatic Data Engineer with real-world experience creating and maintaining enterprise-grade data solutions in the cloud.  Utilizing industry-leading technologies and modern architectural concepts, the Data Engineer will provide expertise in multiple areas including data systems design, web-based workflows (ETL), advanced analytics, BI, Big Data, cloud storage and cloud processing.

Key Responsibilities

• Design, build and implement enterprise-grade data solutions for large-scale, multi-tenant web applications
• Produce high-quality, well architected solutions with an upfront focus on testing and long-term support
• Ensure best practices and industry standard patterns are utilized whenever possible
• Actively review existing code and other developers' work and provide feedback
• Collaborate with developers and analysts on technical and functional designs
• Work with the Product Owner and key stakeholders to fully understand functional requirements for enhancements and new products
• Assist with project scoping, sprint and release planning
• Work with QA and DevOps to perform unit/integrated testing and assist with development of automation strategies and tools
• Collaborate with DevOps to help identify areas for performance improvement
• Advocate Agile Software Development principles and practices
• Participate and assist in conducting daily scrum meetings
• Contribute to team body of knowledge by educating colleagues on industry developments and new client-side technologies


• BA/BS/MS in Computer Science or related 4+-year technical degree

• 3+ years of experience in data engineering, or equivalent DBA + software development

• Solid background in computer science and mathematics
• Proficient with relational database management systems, preferably Microsoft SQL Server
• Proficient with SQL and preferably with T-SQL
• Demonstrated experience developing and supporting high performance batch extract, transform, cleanse and load processes using industry standard tools such as SQL Server Integration Services
• Experience with SQL Server Analysis Services and Data Analysis Expressions (DAX) 
• Experience with BI tools such as SQL Server Reporting Services, Power BI, Tableau
• Experience with real-time data processing and integration in the cloud (IoT) with technology like Microsoft Azure Stream Analytics
• Knowledge and some experience with Big Data technologies such as Hadoop, HDInsight, Azure Data Lake
• Proficient in object-oriented programming concepts and development techniques
• Proficient with at least one OO language, preferably C#
• Experience with server-side frameworks and environments such as ASP.NET MVC, Python, PHP, Node
• Knowledge of ORM tools like Entity Framework, NHibernate, Dapper
• Knowledge of service-oriented architecture (SOA) and related architectural styles using REST, SOAP, RPC, XML, 
• Experience with modern distributed version control systems like Git
• Experience with test, build, deploy (CI) software such as Microsoft Team Services, Bamboo, Jenkins, TeamCity, etc.
• Experience with an integrated development environment (IDE), preferably Visual Studio
• Experience working in an Agile-based development environment and knowledge of different methods such as Scrum, Feature-driven development (FDD) and Kanban

• Strong analytical and decision-making skills
• Excellent oral and written communication skills
• Strong desire to seek out and learn new technologies and development practices
• Ability and willingness to adapt quickly to changing priorities and requests
• Ability to thrive under pressure and take control of urgent and demanding issues
Apply Online
Apply with LinkedIn

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: