Data Engineer

Baker Group•Ankeny, IA

19d•Onsite

About The Position

The Data Engineer is responsible for designing, building, and maintaining the data pipelines and infrastructure that power Baker Group's Microsoft Fabric data warehouse, serving as the organization's single source of truth. This role owns the ingestion, transformation, and orchestration of data from disparate internal systems (ERP, HRIS, MRP and other structured data sources) into governed, reliable data products used by Data Analysts and developers to deliver insights to executive and operational teams and ensures that data is structured to support both traditional reporting and emerging AI and machine learning use cases. The Data Engineer curates and maintains core datasets spanning employees, finance, construction and manufacturing projects, and service, and partners with the Data Scientist, Data Analyst, and Software Development roles to ensure data is trustworthy, well-structured, and fit for downstream use.

Requirements

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or other relevant quantitative field
Three to five years of experience in data engineering, ETL/ELT development, or a related field
Proficiency with SQL and database technologies for data extraction, transformation, and loading
Experience with Microsoft Fabric, Azure Data Factory, or similar cloud ETL/orchestration tools
Experience with medallion architecture and modern data warehousing patterns
Experience with a programming language such as Python, PySpark, or T-SQL for data transformation
Familiarity with data modeling techniques (dimensional modeling, star schema)
Understanding of data governance, data quality, and metadata management practices
Strong analytical and troubleshooting skills with the ability to diagnose and resolve complex pipeline and data quality issues
Excellent time and project management skills with the ability to prioritize across multiple pipeline and infrastructure projects
Current with industry trends in data engineering, cloud platforms, and integration best practices
Strong communication skills with the ability to translate technical data structures for non-technical stakeholders
Team player with strong collaboration skills, particularly with the Data Scientist, Data Analysts, and business system owners
Must be able to focus on complex technical problems and work independently with minimal supervision
Ability to work in a fast-paced environment and adapt to changing business priorities
Meticulous attention to detail and commitment to producing reliable, well-documented data infrastructure

Nice To Haves

Experience preparing data for AI/ML consumption (e.g., vector embeddings, RAG architectures) is a plus
Business acumen and understanding of construction or related industries is a plus
Relevant certifications such as Microsoft Certified: Fabric Data Engineer Associate, Azure Data Engineer Associate, or similar cloud platform certifications are a plus

Responsibilities

Designs, builds, and maintains ETL/ELT pipelines that ingest data from enterprise systems into Microsoft Fabric.
Architects and maintains the Fabric medallion Lakehouse structure (bronze, silver, gold layers) as Baker Group's single source of truth.
Develop and implement best practices for the data infrastructure and environment (e.g. Development/Test/Production environments, Git for version control).
Owns pipeline orchestration, scheduling, and monitoring to ensure reliable, timely, and accurate data availability.
Curates and maintains core datasets across employee, finance, project, service, and manufacturing domains.
Establishes and enforces data quality, validation, and reconciliation processes across all pipelines.
Designs and manages data models, schemas, and semantic layers that support Data Analyst reporting and Data Scientist modeling work.
Defines and maintains data ontologies and canonical business definitions (for example, what constitutes a "project," "employee," or "cost code") to ensure consistent meaning across systems and consumers.
Prepares and structures data to support AI and machine learning use cases, including feature-ready datasets, retrieval-augmented generation (RAG) pipelines, and vector embedding storage.
Manages Fabric capacity planning, workspace organization, and performance optimization.
Implements data governance practices, including access controls, lineage tracking, and metadata management, consistent with Baker Group's data classification standards.
Partners with business system owners (ERP, HRIS, MRP, etc.) to understand upstream data structures and manage change impacts.
Collaborates with the Data Scientist to ensure pipeline outputs support analytical and machine learning use cases.
Collaborates with Data Analysts to ensure data products support paginated reporting, dashboards, and self-service BI needs.
Collaborates with Software Development and DevOps Teams to ensure data products support application development needs.
Coordinates with 3rd party consultants when necessary to deliver data engineering projects and augment capacity for demanding business needs.
Develops and maintains documentation for pipelines, schemas, and integration logic.
Troubleshoots and resolves pipeline failures, latency issues, and data quality incidents.
Monitors and maintains data-specific infrastructure, including Fabric capacity, pipeline orchestration tools, and monitoring/alerting systems.
Evaluates and recommends new data engineering tools, patterns, and best practices.
Stays current on emerging trends in data engineering, cloud data platforms, and integration techniques.