Lead Data Engineer — Build Modern Data Platform (Onsite)

MCS Group - USA | Your Specialist Recruitment Firm; Boston (MA); On-site; USD 120,000 - 180,000; Full time

Job summary

MCS Group - USA | Your Specialist Recruitment Firm is assisting a long-established global business in the Greater Boston area to hire a Senior Data Engineer. This hands-on role focuses on building and modernizing the data platform that underpins analytics, reporting and strategic decision making.

You will own end-to-end data pipelines, design ETL/ELT processes, implement dbt models, and collaborate with ERP/CRM data sources.

Qualifications

• 5+ years of Data Engineering experience
• Strong SQL
• Strong Python
• Hands-on experience with dbt
• Experience building production-grade ETL / ELT pipelines
• Strong cloud data warehouse experience
• Experience with Azure Data Factory
• Experience with Azure Synapse, Databricks, ADLS or similar technologies
• CI/CD and software engineering practices applied to data
• Experience with data quality, testing and monitoring
• Confidence owning complex projects from architecture through production
• Experience working with ERP or operational data is a strong plus

Responsibilities

• Designing and building ETL/ELT pipelines
• Moving data from ERP, CRM, finance and manufacturing systems into the data warehouse
• Building and maintaining dbt models
• Modernizing legacy data processes and integrations
• Data quality, observability and monitoring
• Pipeline orchestration and CI/CD
• Supporting analytics teams with reliable, well-structured data
• Ownership of data platform growth from architecture to production

Skills

Data Engineering

SQL

Python

dbt

ETL/ELT pipelines

Cloud data warehouse

CI/CD

Data quality

Monitoring

Architecture ownership

Tools

Azure Data Factory

Azure Synapse

Databricks

ADLS

Job description

MCS Group - USA | Your Specialist Recruitment Firm is assisting a long-established global business in the Greater Boston area to hire a Senior Data Engineer. This hands-on role focuses on building and modernizing the data platform that underpins analytics, reporting and strategic decision making.

You will own end-to-end data pipelines, design ETL/ELT processes, implement dbt models, and collaborate with ERP/CRM data sources.