Lead Enterprise Data Engineer - Fabric & Medallion

Altorfer CAT; Cedar Rapids (IA); On-site; USD 100,000 - 170,000; Full time

Job summary

Altorfer CAT is seeking an experienced Enterprise Lead Data Engineer in Cedar Rapids to own and evolve the company’s enterprise data platform built on Microsoft Fabric. You will lead data acquisition, integration, and governance across Dynamics 365, Dataverse, and Power Platform, ensuring trusted data for analytics and AI.

The role focuses on data architecture, ingestion, and optimization rather than dashboards, with on‑site collaboration across IT and business teams to support major deployments

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Management, Engineering, or related field, or equivalent work experience.
• Five or more years of experience in data engineering, data architecture, enterprise data platforms, or related technical roles.
• Hands‑on experience designing, building, and supporting ETL/ELT pipelines and enterprise data integrations.
• Strong understanding of data modeling, data warehousing, data governance, and data quality management.
• Demonstrated ability to work with technical teams, business stakeholders, vendors, and project teams across the organization.
• Ability to manage priorities, troubleshoot complex issues, document solutions, and support business‑critical systems.

Responsibilities

• Own the enterprise data platform built on Microsoft Fabric and related Microsoft data services.
• Develop and maintain enterprise data architecture standards, patterns, and operating procedures.
• Define and implement data engineering best practices for ingestion, transformation, storage, governance, and security.
• Ensure enterprise data is reliable, scalable, secure, well governed, and optimized for downstream consumption.
• Serve as the technical lead for data platform design decisions and enterprise data modernization initiatives.
• Design, build, and maintain Microsoft Fabric Lakehouses, Warehouses, Data Pipelines, Dataflows Gen2, and OneLake structures.
• Implement and manage Medallion Architecture, including Bronze, Silver, and Gold data layers.
• Develop repeatable ingestion, transformation, and orchestration frameworks for enterprise data domains.
• Optimize data storage, compute, performance, reliability, and cost efficiency across Fabric workloads.
• Establish standards for data domains, naming conventions, data lineage, metadata, and reusable data products.
• Design, develop, test, deploy, monitor, and support ETL and ELT pipelines.
• Build integrations between enterprise business applications and Microsoft Fabric.
• Develop ingestion frameworks using APIs, connectors, files, database extracts, and other integration patterns.
• Write and maintain SQL, Python, Spark, PowerShell, and transformation logic as needed.
• Troubleshoot and resolve production data pipeline failures, mapping issues, performance issues, and integration errors.
• Automate manual data acquisition, cleansing, validation, and transformation processes wherever possible.
• Lead data integration efforts related to Dynamics 365 Finance & Operations and Dynamics 365 Customer Engagement.
• Design and maintain Dataverse ingestion, synchronization, transformation, and governance processes.

Skills

Data engineering

Data architecture

ETL/ELT design

Data governance

Data quality

Education

Bachelor’s degree in IT/CS/Engineering or related field

Tools

Microsoft Fabric

OneLake

Data Factory

Dataflows Gen2

Lakehouse

Dataverse

Power Platform

Azure Data Services

SQL

Python

Spark

PowerShell

REST APIs

Job description

Altorfer CAT is seeking an experienced Enterprise Lead Data Engineer in Cedar Rapids to own and evolve the company’s enterprise data platform built on Microsoft Fabric. You will lead data acquisition, integration, and governance across Dynamics 365, Dataverse, and Power Platform, ensuring trusted data for analytics and AI.

The role focuses on data architecture, ingestion, and optimization rather than dashboards, with on‑site collaboration across IT and business teams to support major deployments