Data Engineer – Microsoft Fabric

Integra Mission Critical, LLC.; United States; Vor Ort; USD 110.000 - 165.000; Vollzeit

Benefits dieser Stelle

Competitive pay

Healthcare coverage

Education assistance

PTO / time off

401(k) / retirement plan

Career growth opportunities

Zusammenfassung

Integra Mission Critical, LLC in the Plano/DFW area seeks an experienced Data Engineer to design and deliver scalable data pipelines using Microsoft Fabric. You will build Bronze, Silver and Gold layers, create reliable data models, and partner with Data Architecture, Analytics and Power BI teams to deliver trusted data products.

The role emphasizes integration of ERP/CRM data, governance, and performance tuning for enterprise reporting.

Qualifikationen

• Bachelor's degree in Computer Science, Information Systems, Data Engineering or related field, or equivalent professional experience.
• 4 years of professional experience in data engineering, data integration or BI engineering.
• Hands-on experience building production data pipelines and cloud analytics solutions.
• Strong analytical, troubleshooting, documentation and communication skills.

Aufgaben

• Build and maintain data pipelines using Fabric Data Factory, Pipelines, Dataflows Gen2 and notebooks.
• Develop Lakehouse and Warehouse solutions with OneLake and Delta tables.
• Implement Bronze/Silver/Gold processing patterns aligned with Medallion Architecture.
• Transform data using Spark, PySpark, SQL and notebook-based work.
• Collaborate with Data Architecture, Analytics and Power BI teams to deliver trusted data products.
• Develop metadata-driven ingestion for databases, files, APIs and enterprise systems.
• Configure monitoring, alerting and governance using Purview and related tools.
• Support development, test and production environments with CI/CD pipelines.

Kenntnisse

Dimensional modeling

Canonical data models

Source to target mapping

Metadata management

Data governance

Troubleshooting

Analytical thinking

Independent worker

Ausbildung

Bachelor's degree in Computer Science / Information Systems / Data Engineering or related

Tools

Azure Data Lake Storage Gen2

Azure Data Factory

Azure SQL Database

Microsoft Entra ID / Azure AD

Azure Key Vault

Azure DevOps / Git

Delta Lake / Lakehouse

OneLake

Spark / PySpark

Purview / data governance tooling

Jobbeschreibung

Location DFW Department DEPADM

The Opportunity

Microsoft Fabric builds the data pipelines that connect Integras 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

Bachelors 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

• 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 CICD 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 S4HANA 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

• 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 familys 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 were 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 todays 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 youre passionate about innovation impact and building systems the world depends on youll 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 talentacquisitionintegracom