> Markdown version of [/jobs/ext/2154406-principal-data-engineer](https://www.wearedevelopers.com/jobs/ext/2154406-principal-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). --- # Principal Data Engineer - **Company:** The Summit - **Location:** Warrenville, IL, United States - **Experience:** Experienced - **Salary:** $140,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Computing Platforms, Audit Trail, Microsoft Azure, Encodings, Information Engineering, Data Governance, Data Infrastructure, Data Security, DevOps, Data Flow Control, Github, Global Positioning Systems (GPS), Identity and Access Management, Intrusion Detection Systems, Python (Programming Language), Routing, Power BI, Azure Active Directory, Kusto Query Language, SQL Databases, Data Streaming, Technical Data Management Systems, User Provisioning Software, Enterprise Data Management, Data Ingestion, Azure Data Factory, Apache Spark, Indexer, Git, Pandas, Microsoft Fabric, Data Lakes, Pyspark, Optimization Algorithms, Performance Monitor, Data Management, Terraform, Azure Synapse Analytics, Databricks - **Published:** August 20, 2026 - **Apply:** https://dejobs.org/x/x/B90DC740BE1242B9B0D6E23CAEF06997/job/ ## About the Role * Platform Expertise: Deep, hands-on experience with Microsoft Fabric , OneLake , Power BI, and the Azure Data stack. * Data Modeling Mastery: Proven track record building enterprise Star Schemas, handling Slowly Changing Dimensions (SCDs), and establishing Master Data Management (MDM) protocols. * Security & Compliance: Direct experience securing highly sensitive data environments; familiarity with FERPA, HIPAA, or similar strict privacy frameworks is highly preferred. * Communication & Documentation: Exceptional ability to articulate complex technical decisions to executive leadership, document blueprints, and mentor engineering teams., * Experience: 10+ years of experience in data engineering, with at least 2+ years of hands-on experience designing enterprise solutions within Microsoft Fabric or advanced Azure Synapse/Databricks environments. * Fabric Ecosystem Mastery: Deep technical understanding of Fabric capacities, OneLake shortcuts, Managed Private Endpoints, and the interplay between Lakehouses and Warehouses. * Advanced Spark & Delta Lake: Expert-level knowledge of Apache Spark (PySpark) and the Delta Lake storage format, including optimization techniques like V-Order, Z-Order indexing, and liquid clustering. * Languages: Expert in SQL and Python (including libraries like Pandas, Polars, or PySpark). * Orchestration & DevOps: Experience with Fabric Git integration, Azure DevOps/GitHub Actions, and Infrastructure as Code (Terraform) for Fabric resource provisioning. ## Description We are seeking a highly technical Principal Data Engineer to design, scale, and evolve our enterprise data ecosystem. In this role, you will serve as the technical authority for our data infrastructure, driving the strategy for data warehouse design, real-time streaming, and robust governance. As a Principal Engineer, you will balance hands-on technical leadership with strategic cross-functional collaboration, mentoring engineers, and aligning our data capabilities with long-term business goals. You are the strategic anchor and technical authority for our enterprise data ecosystem. In this role, you will design, govern, and optimize our Microsoft Fabric and Power BI design to transform complex, multi-modal data streams-including near-real-time telematics, operational routing, and financial ERP systems-into secure, scalable, and actionable intelligence. You will bridge the gap between technical execution and business strategy, ensuring our data platform is robust, compliant with federal regulations (FERPA), and built for high-performance self-service analytics., Enterprise Data Design * Define Medallion Standards: Author, document, and defend the design boundaries and ingestion logic across the Bronze, Silver, and Gold layers within Fabric. * Tool & Pattern Selection: Establish clear organizational frameworks for when to deploy specific Fabric components (e.g., Mirroring vs. Dataflow Gen2 vs. Data Factory Pipelines). * Power BI Storage Strategy: Standardize dataset configurations, defining precise criteria for utilizing DirectLake , Import , or DirectQuery modes to balance cost, freshness, and performance. Integration & Advanced Pipeline Engineering * Multi-Speed Ingestion Patterns: Design repeatable, hardened ingestion patterns for diverse data velocities: * Near Real-Time: GPS and IoT telematics streams. * Operational Batch: Dispatch, scheduling, and routing systems. * Transactional/Financial: Enterprise ERP data. * Resiliency & Frameworks: Own the end-to-end framework for data ingestion into OneLake , embedding enterprise-grade error handling, automated retry logic, and proactive monitoring/alerting systems. Data Modeling & Master Data Management (MDM) * Gold Layer Definition: Design enterprise-wide dimensional models and star schemas within the Gold layer to serve as the single source of truth. * Semantic Layer Standardization: Establish strict governance for Power BI semantic models, including DAX measure naming conventions, hierarchy design, and Row-Level Security (RLS) structures. * Master Data Management: Spearhead the definition and enforcement of canonical master data entities across disparate systems, specifically governing unified definitions for Vehicle IDs, Driver IDs, and Student Records . Data Governance, Security, and Compliance * Access Control & Lifecycle: Enforce Fabric workspace security utilizing Microsoft Entra ID / Security Groups for identity management, eliminating ad-hoc individual user provisioning. * Data Protection & Auditability: Implement Microsoft Purview sensitivity labels, robust Row-Level Security (RLS), and comprehensive audit trails, serving as the primary technical point of contact for data security audits. Business Enablement & Analytics Delivery * Requirements Translation: Act as the primary conduit between operations, safety, finance, and district stakeholders, translating complex operational requests (e.g., "On-time arrival rate by district" ) into technical data products. * Productized Delivery: Lead the deployment of certified, user-friendly Power BI apps and dashboards, reducing friction for business users and eliminating the need for stakeholders to write direct SQL/KQL queries against the Gold layer. ## Related Videos - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript) - [Getting to Know Your Legacy (System) with AI-Driven Software Archeology](https://www.wearedevelopers.com/videos/1437-getting-to-know-your-legacy-system-with-ai-driven-software-archeology) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)