← Back to jobsJob ID col-cmv8amtjf00heoz01syhnxc1z

Critical Project ServicesPosted 30+ days ago

Data Engineer - Microsoft Fabric

Full-time
On-site
4+ years
Competitive
Posted 30+ days ago

Integra is hiring a Data Engineer to build and maintain Microsoft Fabric data pipelines and enterprise data layers that connect operational systems to trusted analytics data. The role integrates, transforms, governs, and supports data products in partnership with architecture, analytics, Power BI, and business teams.

Energy

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

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

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

  • 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

Required skills

Microsoft FabricSQLPythonPySparkDelta LakeETL/ELTChange Data Capture (CDC)Dimensional Data ModelingAzure Data FactoryAzure DevOpsGitMicrosoft Purview

Full job description

Integra is hiring a Data Engineer to build and maintain Microsoft Fabric data pipelines and enterprise data layers that connect operational systems to trusted analytics data. The role integrates, transforms, governs, and supports data products in partnership with architecture, analytics, Power BI, and business teams.

Energy

  • Consulting
  • Management Consulting

Responsibilities

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

Preferred

  • 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

Benefits

  • Competitive pay with incentive opportunities that recognize your results and contributions.
  • Medical, dental, and vision coverage that supports you and your family’s total well-being.
  • Life and disability insurance programs.
  • A variety of voluntary benefits so you can personalize coverage to fit your needs.
  • Generous paid time off.
  • Education assistance and tuition support to help you build skills and advance your career.
  • Retirement and savings programs.

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
  • 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
  • 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
  • 4+ years of professional experience in data engineering, data integration, business intelligence engineering, or a related discipline.

Required skills

  • Microsoft Fabric, SQL, Python, PySpark, Delta Lake, ETL/ELT, Change Data Capture (CDC), Dimensional Data Modeling, Azure Data Factory, Azure Data Lake Storage Gen2, Azure DevOps, Git, Microsoft Purview

Experience

  • 4+ years

Company

  • Critical Project Services is an unique full service, project management consulting firm focusing on the energy industry.
  • Dallas, Texas, USA
  • http://www.cps-llc.com/

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Oct 13, 2026

Work mode

On-site

Job source

Ethic Leaf recruiter

Company

Critical Project Services

Information Technology & AI

Critical Project Services is an unique full service, project management consulting firm focusing on the energy industry.

See all 2 jobs from Critical Project Services →
  • Dallas, Texas, USA
  • Information Technology & AI
  • cps-llc.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Plano

GTECH LLC

1d ago

New

Microsoft Fabric Data Engineer (Mid-Level):::Hybrid in Golden Valley, MN

Full-timeHybridGolden Valley, MNCompetitive

GTECH LLC is adding mid-level Microsoft Fabric data engineers to its Process, Data, and Technology team.

Why similarSame roleMicrosoft FabricPySpark

Senior Data Engineer (Fraud) Job Details

1d ago

New

Senior Data Engineer (Fraud)

Full-timeOn-siteRichardson, TXCompetitive

BOK Financial is hiring a Senior Data Engineer (Fraud) to design, develop, and deliver scalable data pipelines and solutions for enterprise analytics and data platform initiatives.

Why similarSame roleETL/ELTRichardson

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryRemote

Get new Data Engineer jobs in Plano by email

Create job alert

Data Engineer - Microsoft Fabric

Critical Project Services · Competitive

Apply via Ethic Leaf