Data Engineer - Microsoft Fabric

Integra is hiring a Data Engineer to build and maintain Microsoft Fabric data pipelines and enterprise data layers. The role integrates data from business systems, supports trusted analytics and reporting, and partners with architecture, analytics, and business teams on data products and governance.

Tags

Energy

Consulting

Management Consulting

Insider Connection @Critical Project Services

2 email credits available today

Beyond your network

Katie Rykal

Fractional CHRO | HR Transformation & Organizational Growth

From your previous company

Find More Connections

from your School

Find Any Email

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.

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/

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Engineering and Development

Trends of Total Sponsorships

*2022

(1)

Growth Stage

Leadership Team

Lori Willox

Chief Financial Officer

Tom Kline, CPA, CCIFP

Interim Chief Financial Officer

Company data provided by

AI Tools

Customize Your Resume

Maximize your interview chances

Build Cover Letter

Make your application stand out

Analyze How Well You Fit

Understand your strength & weakness

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, Relational Data Modeling, ETL/ELT, Change Data Capture, Azure Data Factory, Azure Data Lake Storage Gen2, Azure DevOps and Git, Microsoft Purview

Experience

4+ years