Data Engineer: Build AI-Ready Data Pipelines & Lakehouse

Baker Group; Ankeny (IA); On-site; USD 90,000 - 150,000; Full time

Job summary

Baker Group is seeking a Data Engineer in Ankeny, IA to design, build, and maintain data pipelines powering its Microsoft Fabric data warehouse. You will own ingestion, transformation, and orchestration from ERP, HRIS, MRP and other sources into governed, reliable data products for analysts and developers.

You'll implement data models, governance, and scalable architectures, collaborating with Data Scientists, Analysts, and business system owners to enable reporting, BI, and AI/ML initiatives

Qualifications

• Bachelor's degree in a quantitative field required.
• 3–5 years of data engineering, ETL/ELT experience.
• Proficiency with SQL and data transformation.
• Experience with Microsoft Fabric and Azure Data Factory.
• Experience with medallion architecture and modern data warehousing.
• Knowledge of data governance and metadata management; AI/ML data prep a plus.

Responsibilities

• Designs, builds, and maintains ETL/ELT pipelines ingesting data from enterprise systems into Microsoft Fabric.
• Architects the Fabric medallion Lakehouse structure as the single source of truth.
• Owns pipeline orchestration, scheduling, and monitoring for data availability.
• Maintains core datasets across employee, finance, project, service, and manufacturing domains.
• Establishes data quality, validation, and reconciliation across pipelines.
• Defines data ontologies and canonical definitions for consistency.
• Prepares data for AI/ML use cases, including vector embeddings and RAG pipelines.
• Collaborates with Data Analysts, Data Scientists, and business system owners.

Skills

SQL

Python

PySpark

T-SQL

Data Modeling

Data Governance

Microsoft Fabric

Azure Data Factory

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or other relevant quantitative field

Tools

Microsoft Fabric

Azure Data Factory

Job description

Baker Group is seeking a Data Engineer in Ankeny, IA to design, build, and maintain data pipelines powering its Microsoft Fabric data warehouse. You will own ingestion, transformation, and orchestration from ERP, HRIS, MRP and other sources into governed, reliable data products for analysts and developers.

You'll implement data models, governance, and scalable architectures, collaborating with Data Scientists, Analysts, and business system owners to enable reporting, BI, and AI/ML initiatives