Data Engineer-ETL

Date posted: 
May 31, 2017
Job Type: 
Dedham, MA
Job ID: 

Data Engineer needed 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 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
? Cooperate with DevOps to help identify operational areas of interest and determine performance impact
? 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

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