What are the responsibilities and job description for the Lead Data Engineer / Azure Expert / Remote after 6 months / 6% 401k match position at Motion Recruitment?
A stable and established supply chain firm is hiring for a Lead Data Engineer in the Greater Chicago area. This role will be hybrid for the first 6 months, until it becomes fully remote (if interested). This is a rare opportunity to own and build a company’s data platform from the ground up at a stable, long-established organization that is making a serious, well-funded investment in modernizing its technology.
The company is launching a greenfield Microsoft Azure data platform to replace legacy, on-prem systems and is looking for a senior, hands-on Data Engineer to lead that effort end-to-end. You will be the technical authority responsible for architecture, implementation, governance, and long-term reliability, shaping how data is trusted and used across the business for years to come. This role is intentionally deep and hands-on, with a small, high-accountability team and real ownership rather than layers of management or vendor dependency.
The ideal candidate is a Senior Data Engineer with 7 years of experience who still enjoys building, coding, and owning outcomes, with hands-on experience designing and operating modern data platforms and deep expertise in the Microsoft Azure ecosystem (ADF, Azure SQL/Synapse, ADLS), along with strong T-SQL and Python skills. They’ve worked with legacy, on-prem systems—ideally ERPs—and know how to design clean, governed pipelines that produce trusted data.
This role is best suited for someone who prefers depth over scale and wants long-term technical ownership rather than a fast path to title growth. The role offers remote flexibility, competitive comp with 10% bonus, 6% 401k match and 4 weeks of PTO. If this sounds like you, apply for more info!
Required Skills & Experience
Tech Breakdown
Posted By: Destiny Kuczak
The company is launching a greenfield Microsoft Azure data platform to replace legacy, on-prem systems and is looking for a senior, hands-on Data Engineer to lead that effort end-to-end. You will be the technical authority responsible for architecture, implementation, governance, and long-term reliability, shaping how data is trusted and used across the business for years to come. This role is intentionally deep and hands-on, with a small, high-accountability team and real ownership rather than layers of management or vendor dependency.
The ideal candidate is a Senior Data Engineer with 7 years of experience who still enjoys building, coding, and owning outcomes, with hands-on experience designing and operating modern data platforms and deep expertise in the Microsoft Azure ecosystem (ADF, Azure SQL/Synapse, ADLS), along with strong T-SQL and Python skills. They’ve worked with legacy, on-prem systems—ideally ERPs—and know how to design clean, governed pipelines that produce trusted data.
This role is best suited for someone who prefers depth over scale and wants long-term technical ownership rather than a fast path to title growth. The role offers remote flexibility, competitive comp with 10% bonus, 6% 401k match and 4 weeks of PTO. If this sounds like you, apply for more info!
Required Skills & Experience
- BS in CS or related field
- 7 years of hands-on Data Engineering experience
- Deep production experience in Microsoft Azure (Azure Data Factory, Azure SQL / Synapse, Azure Data Lake Storage)
- Experience extracting data from legacy, on-prem ERP systems
- Strong Python and T-SQL
- Built or rebuilt a data platform from end-to-end (Data Warehouse or Lakehouse)
- Strong instincts around data quality, governance, and documentation
- Comfort owning outcomes and being accountable when data is incorrect
- Azure Fabric experience is a strong plus
- Dynamics GP experience preferred
- CI/CD experience (Azure DevOps, Infrastructure as Code)
- Prior team lead experience
- Experience working with vendors
- Logistics or operational data background
Tech Breakdown
- Python
- T-SQL
- Microsoft Azure
- 60% Hands On
- 20% Architecture
- 20% Stakeholder communication
- 10% Bonus eligible
- Medical, Dental, and Vision Insurance
- 4 weeks Vacation Time
- 6% 401k match
- Option to work remotely after 6 months
Posted By: Destiny Kuczak