> Markdown version of [/jobs/ext/2243445-enterprise-lead-data-engineer](https://www.wearedevelopers.com/jobs/ext/2243445-enterprise-lead-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Enterprise Lead Data Engineer - **Company:** Altorfer Inc - **Location:** Cedar Rapids, IA, United States - **Experience:** Expert - **Salary:** $100,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Business Software, Business Systems, Databases, Computer Literacy, Customer Data Management, Data Architecture, Information Engineering, Data Governance, Data Hub, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Security, Data Warehousing, Desktop Computing, Identity and Access Management, JSON, Python (Programming Language), Machine Learning, Microsoft Data Access Components, Metadata, Meta-Data Management, Microsoft Dynamics, Operational Databases, Windows PowerShell, DataOps, SQL Stored Procedures, SQL Databases, Systems Integration, Enterprise Data Management, Scripting, Enterprise Software Applications, Data Storage Technologies, Azure Data Factory, Apache Spark, Data Layers, Microsoft Fabric, Information Technology, Data Lineage, Microsoft Dynamics 365 Finance & Operations, Operational Systems, Data Management, Restful APIs, Data Pipelines - **Published:** August 26, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/88148277/1 ## About the Role * Bachelor's degree in Information Technology, Computer Science, Data Management, Engineering, or a 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. Required Technical Skills Microsoft Data Platform Microsoft Fabric, OneLake, Data Factory, Dataflows Gen2, Lakehouse, Warehouse, Dataverse, Power Platform, Azure Data Services Data Engineering ETL/ELT design, Medallion Architecture, data modeling, data warehousing, data governance, data quality, metadata, lineage, master data concepts Development SQL, Python, PowerShell, Spark, REST APIs, JSON, data transformation development, scripting, automation Enterprise Applications Dynamics 365 Finance & Operations, Dynamics 365 Customer Engagement, ERP data integration, CRM data integration, operational system data integration Preferred Qualifications * Experience implementing Microsoft Fabric in an enterprise environment. * Experience with Dynamics 365 Finance & Operations and Dynamics 365 Customer Engagement data integration. * Experience designing and supporting Dataverse for enterprise applications. * Microsoft Fabric, Azure Data Engineer, Power Platform, or related Microsoft certifications. * Experience supporting AI, Copilot, machine learning, or advanced analytics data initiatives. * Experience leading enterprise data modernization or cloud-first transformation initiatives. ## Description 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. Basic Duties Enterprise Data Platform Ownership 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. Microsoft Fabric and Medallion Architecture * 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. Data Engineering and Integration * 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. Dynamics 365, Dataverse, and Power Platform * 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 business-critical Dynamics 365 and Dataverse data is available, trusted, and usable across the enterprise data platform. * Collaborate with Power Platform developers to ensure data consistency, scalability, security, and platform standards. Data Governance, Quality, and Security * Establish and enforce enterprise data quality standards, validation rules, and remediation processes. * Implement data lineage, cataloging, metadata management, and documentation practices. * Develop monitoring and alerting for data quality, pipeline health, platform performance, and operational availability. * Partner with business teams to define data ownership, stewardship, retention, and lifecycle practices. * Support regulatory, compliance, privacy, and security requirements for enterprise data assets. * Work with cybersecurity and infrastructure teams to ensure proper access controls, identity governance, and secure data handling. Hands-On Technical Expectations This is a hands-on engineering position. The Enterprise Lead Data Engineer is expected to personally design, build, test, deploy, operate, and support enterprise data solutions. * Build data pipelines and integration processes directly within Microsoft Fabric and related services. * Create and maintain transformation logic, data models, SQL queries, stored procedures, notebooks, scripts, and automation. * Configure and support Fabric workloads, Dataverse integrations, connectors, APIs, and data movement processes. * Troubleshoot production issues, failed refreshes, integration errors, mapping problems, and data quality exceptions. Continuously improve performance, reliability, automation, documentation, and platform standards., This position is primarily performed in an office environment and requires extended periods of sitting, standing, computer usage, and communication through written, verbal, and electronic means. The employee must be able to effectively use computers, monitors, keyboards, and other standard office technology to design, develop, and support enterprise data solutions. Occasional visits to Altorfer facilities, branches, and customer sites may be required to support business initiatives, system implementations, data integrations, and collaboration with operational teams. While on-site, the employee may be required to walk through office, shop, warehouse, and industrial environments and must comply with all applicable safety requirements, including the use of approved personal protective equipment such as safety glasses, safety footwear, and other required safety equipment. The employee may occasionally lift and transport equipment or materials up to 25 pounds. Noise levels are typically low in office environments and may range from low to moderate in warehouse or shop environments. These physical demands are representative of those necessary to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions. Equal Employment Opportunity All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic in accordance with applicable federal, state, and local laws. Why Work for Altorfer? ## Related Videos - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Bringing Clarity to Event Streams: Enabling Analytics and AI Through Rich Metadata](https://www.wearedevelopers.com/videos/1616-bringing-clarity-to-event-streams-enabling-analytics-and-ai-through-rich-metadata) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)