Microsoft Fabric Data Integration Engineer

Location: Annapolis, MD (Local Candidates Only)

Job Description

We are looking for an experienced Microsoft Fabric Data Integration Engineer with strong hands-on experience in building automated data pipelines and integrating enterprise data from SAP and Workday into Microsoft Fabric.

The ideal candidate will have expertise in Microsoft Fabric, Data Factory, Lakehouse, OneLake, Dataflows Gen2, and SQL, along with practical experience working with SAP financial data and Workday HR/payroll data.

Key Responsibilities

· Design, develop, and maintain automated ETL/ELT pipelines using Microsoft Fabric Data Factory, Data Pipelines, and Dataflows Gen2.

· Integrate data from SAP and Workday using connectors, REST APIs, web services, and other supported integration methods.

· Work with OneLake, Fabric Lakehouse, and Fabric Warehouse to ingest, store, and transform enterprise data.

· Develop complex SQL queries, joins, mapping tables, and transformation logic to match records across SAP and Workday.

· Perform data validation, reconciliation, duplicate identification, and exception handling to ensure data accuracy.

· Implement automated data quality checks, monitoring, audit logs, security, and data lineage.

· Support testing, user acceptance testing (UAT), technical documentation, and knowledge transfer.

Required Qualifications

· 5+ years of experience in Data Engineering, Data Integration, ETL/ELT development, or database development.

· Strong hands-on experience with Microsoft Fabric and its data integration capabilities.

· Proven experience integrating data from both SAP and Workday.

· Experience working with SAP financial data and Workday HR or payroll data.

· Advanced SQL skills, including complex joins, transformations, record matching, and reconciliation.

· Experience with REST APIs, JSON, web services, and enterprise data integrations.

· Strong understanding of data quality, validation, and automated pipeline monitoring.

Preferred Skills

· SAP ECC 6.0 EHP 6

· Workday Reports-as-a-Service (RaaS) and Workday Web Services

· Python, PySpark, and Power Query

· Azure Data Factory

· Power BI