Data Engineer - Microsoft Fabric at Integra… · Dallas

Location: DFW Department: DEPADM The Opportunity The Data Engineer - Microsoft Fabric builds the data pipelines that connect Integra’s core business systems to our enterprise data platform and make trusted data available across the organization. You will work hands-on in Microsoft Fabric to ingest, transform, organize, and integrate data from ERP, CRM, HR, manufacturing, construction, and other operational systems. You will help build and maintain our Bronze and Silver data layers, creating reliable pipelines and models that prepare data for downstream analytics and business-specific solutions across Finance, HR, Marketing, Engineering, Technology, and Operations. You will partner with Data Architecture, Analytics, Power BI, and business teams to understand how data is created and used, identify gaps between systems, and turn complex source data into consistent, scalable, and trusted data products. This role is a strong fit for someone who enjoys building the data foundation behind analytics and has experience connecting complex enterprise systems through modern data engineering and integration practices. This role is 100% onsite in the far North Dallas/ Plano area. What you will do? Microsoft Fabric Data Engineering • Build and maintain data pipelines using Fabric Data Factory, Fabric Pipelines, Dataflows Gen2, and notebooks. • Develop and support Fabric Lakehouse and Warehouse solutions using OneLake and Delta tables. • Implement scalable Bronze, Silver, and Gold processing patterns aligned with the Medallion Architecture. • Develop Spark, PySpark, SQL, and notebook-based transformations for structured and semi-structured data. • Use Fabric shortcuts, mirroring, and appropriate ingestion patterns based on source-system and workload requirements. • Optimize Fabric workloads for performance, reliability, concurrency, and capacity consumption, and support Direct Lake semantic models and downstream Power BI requirements. Data Integration and Ingestion • Develop metadata-driven ingestion frameworks for databases, files, APIs, SaaS applications, and enterprise systems. • Implement full-load, incremental-load, watermark, and Change Data Capture patterns. • Build resilient pipelines with parameterization, dependency management, retry logic, logging, and alerting. • Integrate data from Oracle Fusion ERP, Deltek Costpoint ERP, Primavera P6, Procore, Salesforce, manufacturing systems, and other operational platforms. • Implement reconciliation, source-to-target validation, audit controls, restartable processing, and technical metadata management. Lakehouse Transformation and Data Quality • Transform raw source-aligned Bronze data into standardized and validated Silver data structures. • Implement source-to-canonical mappings for finance, projects, procurement, suppliers, customers, employees, organizations, scheduling, and manufacturing domains. • Build Gold data products and dimensional models that support enterprise reporting and analytics. • Implement schema enforcement, schema evolution, deduplication, data-quality rules, quarantine processes, and exception reporting. • Use Delta Lake capabilities including MERGE, ACID transactions, time travel, optimization, and controlled retention. • Create reusable engineering components, frameworks, templates, and coding standards. Security, Governance, and DevOps • Implement workspace, item, OneLake, SQL endpoint, and data access controls with platform and security teams. • Use Microsoft Entra ID, managed identities, service principals, Azure Key Vault, and least-privilege access patterns. • Support Microsoft Purview cataloging, classification, lineage, business glossary, and data-discovery processes. • Manage source code through Git and Azure DevOps, including branching, pull requests, code reviews, release pipelines, and deployment practices. • Support separate development, test, and production environments using deployment pipelines and controlled configuration. • Develop monitoring and operational dashboards for pipeline health, failures, runtimes, data freshness, quality, and capacity consumption. Collaboration and Support • Partner with the Data Architect to implement enterprise architecture, canonical modeling, governance, and integration standards. • Work with functional subject-matter experts and data stewards to understand source data, business rules, and validation requirements. • Collaborate with Power BI developers and Analytics Engineers to deliver trusted semantic models and data products. • Create technical documentation, runbooks, data dictionaries, source-to-target mappings, and operational support procedures. • Troubleshoot production issues, perform root-cause analysis, and implement permanent corrective actions. • Participate in peer reviews, sprint planning, estimation, testing, release management, and continuous improvement. Required Qualifications • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline, or equivalent professional experience. • 4+ years of professional experience in data engineering, data integration, business intelligence engineering, or a related discipline. • Hands-on experience building production data pipelines and cloud-based analytics solutions. • Experience working with relational databases, APIs, files, and enterprise application data. • Strong analytical, troubleshooting, documentation, and communication skills. • Ability to work independently while collaborating effectively with architects, engineers, analysts, and business stakeholders. Required Technical Skills • Microsoft Fabric Data Factory, Pipelines, Lakehouse, Warehouse, OneLake, notebooks, Spark runtime, Dataflows Gen2, Delta tables, Direct Lake, workspace security, deployment pipelines, monitoring, and capacity awareness. • Advanced SQL, relational data modeling, Python, PySpark, Apache Spark, Delta Lake, Parquet, ETL and ELT patterns, metadata-driven frameworks, CDC, watermarking, incremental loading, reconciliation, observability, and performance tuning. • Azure Data Lake Storage Gen2, Azure Data Factory, Azure SQL Database or comparable platforms, Microsoft Entra ID, service principals, managed identities, Azure Key Vault, Azure DevOps, Git, CI/CD, Azure Monitor, and Log Analytics. • Bronze, Silver, and Gold layers; dimensional modeling; canonical data models; source-to-target mapping; lineage; metadata; business glossaries; data dictionaries; and Microsoft Purview or comparable governance tooling. Preferred Qualifications • Experience with Oracle Fusion ERP, Deltek Costpoint, SAP S/4HANA, Primavera P6, Procore, Autodesk Construction Cloud, Salesforce, or manufacturing and product lifecycle systems. • Knowledge of financial and ERP domains including general ledger, AP, AR, procure-to-pay, order-to-cash, project accounting, project costing, revenue recognition, budgeting, forecasting, and financial reporting. • Knowledge of project controls, construction, manufacturing, and supply-chain data domains. How we support you We believe your best work happens when you feel supported - professionally, personally, and financially. That’s why we offer a range of benefits designed to help you thrive, stay healthy, and plan for the future. Performance-driven rewards – Competitive pay with incentive opportunities that recognize your results and contributions. Comprehensive healthcare – Medical, dental, and vision coverage that supports you and your family’s total well-being. Security and peace of mind – Life and disability insurance programs that provide protection when it matters most. Flexible benefits options – A variety of voluntary benefits so you can personalize coverage to fit your needs. Time to recharge – Generous paid time off to relax, travel, and maintain a healthy work-life balance. Investing in your growth – Education assistance and tuition support to help you build skills and advance your career. Planning for the future – Retirement and savings programs that help you achieve long-term financial confidence. Come build with us At Integra, we’re driven by a vision to transform the data center industry. We specialize in delivering optimized turnkey solutions that bring together speed, quality, and reliability - helping our clients build and operate the mission-critical infrastructure that powers today’s digital world. Integra is a vertically integrated company - owning and managing every phase of the process from site selection and design to manufacturing, procurement, commissioning, and warranty. This approach allows us to move faster, solve challenges more efficiently, and deliver exceptional outcomes for our partners. What truly sets Integra apart is our people. We are a team of problem-solvers, engineers, builders, and operators who thrive on tackling complex challenges and delivering results. Our culture values collaboration, accountability, and continuous improvement - because in a rapidly evolving digital landscape, excellence and adaptability matter. Joining Integra means being part of a company that is shaping the future of data center infrastructure. If you’re passionate about innovation, impact, and building systems the world depends on, you’ll find the opportunity to grow and make a difference here. Equal Opportunity Statement Integra provides equal employment opportunities for all people. No employee or applicant for employment will be discriminated against because of race, creed, origin, marital status, sexual orientation, age, otherwise qualified disabled or veteran status or any other characteristic protected by law. If you are a qualified applicant who requires reasonable accommodation to complete a job application, pre-employment testing, a job interview or to otherwise participate in the hiring process, please contact talent_acquisition@integra.com