Enterprise Lead Data Engineer

Job Details

• Req No.:
• Category: Information Technology
• Location: US-IA-Cedar Rapids
• Type: Regular Full-Time
• Union or Non-Union: Non-Union
• Division: Corporate
• Company: Altorfer Inc

• This position is preferred to be onsite in Cedar Rapids, Iowa. Altorfer is willing to evaluate a highly skilled individual located within Altorfer s territory of Iowa, Illinois, Missouri, or Indiana.
• Standard working hours are 7:00 a.m. to 4:00 p.m., Monday through Friday.
• Additional hours may be required to support project implementations, production issues, system upgrades, data migrations, or critical business initiatives.
• Occasional evening and weekend work may be necessary during major deployments, maintenance windows, or outage response activities.
• Some travel throughout Altorfer s territory in Iowa, Illinois, Indiana, and Missouri is required.
• Overnight travel may be necessary based on project and business needs.

The Enterprise Lead Data Engineer is responsible for the design, development, governance, and ongoing operation of Altorfer s enterprise data platform. This hands-on technical role serves as the owner of enterprise data acquisition, integration, transformation, and storage across Microsoft Fabric, Dataverse, Dynamics 365 Finance & Operations, Dynamics 365 Customer Engagement, Power Platform, and other business systems.

This individual will lead the implementation and evolution of Altorfer s Medallion Architecture strategy and ensure that enterprise data is available, accurate, governed, secure, and optimized for analytics, artificial intelligence, automation, Copilot, and reporting.

The Enterprise Lead Data Engineer owns the foundational data layer of the organization. While partnering closely with reporting and analytics teams, this position is not primarily responsible for building dashboards or reports. Instead, the role ensures trusted, governed, and performant data is available for downstream business intelligence, AI, and operational workloads.

• 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 Lake houses, Warehouses, Data Pipelines, Dataflows Gen2, and One Lake 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, Power Shell, 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.
• Lead data integration efforts related to Dynamics 365 Customer Engagement.
• Design and maintain Dataverse ingestion, synchronization, transformation, and governance processes.
• Develop data models supporting ERP, CRM, Power Platform, automation, and operational workloads.
• Ensure…