Microsoft Fabric Data Integration Engineer

Location: Annapolis, MD (Local Candidates Only)
Job Type: Contract
Experience Required: 5+ Years
Open Positions: 1
Work Authorization: U.S. Citizens, Green Card Holders, and H-1B Visa Holders
Start Date: ASAP

Job Summary

We are seeking an experienced Microsoft Fabric Data Integration Engineer to design, develop, and implement enterprise-scale data integration solutions using Microsoft Fabric. The ideal candidate will have strong hands-on expertise in building automated ETL/ELT pipelines, integrating SAP and Workday enterprise applications, and delivering reliable, secure, and high-quality datasets for financial, human resources, and operational analytics.

This role requires advanced SQL development, data transformation, cross-system record matching, data reconciliation, and modern cloud-based data engineering practices.

Key Responsibilities

Microsoft Fabric Development & Data Engineering

• Design, develop, deploy, and maintain scalable ETL/ELT pipelines using Microsoft Fabric.
• Leverage Fabric Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse, and Fabric Data Warehouse.
• Implement automated data ingestion, transformation, scheduling, monitoring, and error-handling processes.
• Optimize data pipelines for performance, scalability, reliability, and maintainability.

SAP & Workday Integration

• Develop and maintain secure data integrations between SAP, Workday, and Microsoft Fabric.
• Extract and transform SAP financial and operational data and Workday HR and payroll data.
• Implement API-based integrations using REST APIs, web services, and supported enterprise connectors.
• Configure initial data loads, incremental processing, and scheduled refresh mechanisms.
• Ensure data consistency and integrity across enterprise source systems.

Data Transformation, Mapping & Reconciliation

• Develop advanced SQL queries, complex joins, transformation logic, and data mapping procedures.
• Implement cross-system record matching using common identifiers and business-defined matching rules.
• Identify and resolve duplicate records, missing identifiers, inconsistent formats, and unmatched datasets.
• Build automated reconciliation frameworks to validate data completeness and accuracy.

Data Quality, Governance & Security

• Establish automated data validation, quality monitoring, and exception-reporting processes.
• Implement secure data access, role-based permissions, and appropriate audit controls.
• Support data lineage, metadata management, and enterprise data governance practices.
• Troubleshoot data integration failures and resolve pipeline performance issues.

Testing, Documentation & Collaboration

• Perform unit testing, integration testing, data validation, and user acceptance testing support.
• Develop source-to-target mappings, technical design documentation, and operational procedures.
• Collaborate with data architects, business analysts, functional teams, and reporting stakeholders.
• Provide production support, troubleshooting, and knowledge transfer.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent professional experience.
• Minimum 5 years of experience in data engineering, data integration, ETL/ELT development, database development, or related disciplines.
• Demonstrated hands-on experience designing and implementing Microsoft Fabric data engineering solutions.
• Strong experience with Fabric Data Factory, Data Pipelines, Dataflows Gen2, Lakehouse, OneLake, and Fabric Warehouse.
• Proven experience integrating data from both SAP and Workday enterprise platforms.
• Advanced SQL skills, including complex joins, transformations, record matching, and data reconciliation.
• Experience developing and consuming REST APIs, JSON-based integrations, and enterprise web services.
• Strong understanding of data warehousing, dimensional modeling, data integration patterns, and data quality principles.
• Experience implementing automated data pipelines, monitoring, error handling, and scheduled data refreshes.
• Strong analytical, troubleshooting, communication, and technical documentation skills.

Preferred Qualifications

• Experience working with SAP ECC 6.0 EHP 6 or comparable SAP ERP environments.
• Knowledge of Workday Reports-as-a-Service (RaaS) and Workday Web Services.
• Hands-on experience with Python, PySpark, or Power Query.
• Experience with Azure Data Factory and related Azure data services.
• Familiarity with Microsoft Power BI and enterprise reporting solutions.
• Knowledge of Microsoft Fabric security, governance, and performance optimization.
• Experience supporting financial, payroll, HR, and operational reporting environments.

Candidate Requirements

• Candidates must be local to Annapolis, MD, or the surrounding area.
• Must possess valid U.S. work authorization under one of the specified categories.
• Must demonstrate hands-on technical expertise in Microsoft Fabric, SQL, SAP, and Workday integrations.
• Must be available to start as soon as possible.