Back to Jobs
Recently postedTechnology

Microsoft Fabric Data Integration Engineer

Mansai CorporationAnnapolis, MD🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationAnnapolis, MD, United States
SQLApache SparkETLPythonRESTAzurePower BIAzure Data Factory

Job description

About the Company
Company is a client seeking to strengthen its enterprise data capabilities. The organization relies on SAP for financial data and Workday for HR and payroll data, and is focused on consolidating information from these systems into Microsoft Fabric to enable financial, HR, and operational reporting. The client values secure, automated, and well-governed data integration practices, with attention to data quality, reconciliation, access controls, audit logs, and data lineage across its enterprise reporting environment.

Key Responsibilities
Design, build, and monitor ETL/ELT pipelines using Fabric Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse, and Fabric Warehouse
Automate secure data extraction from SAP and Workday using supported connectors, APIs, or web services
Configure initial loads and recurring refreshes
Develop SQL joins, transformation rules, and mapping tables to resolve duplicates, missing identifiers, and unmatched records
Match records across SAP and Workday systems using a common identifier
Implement automated data quality checks, reconciliation, and exception reporting
Maintain access controls, audit logs, and data lineage
Support testing and user acceptance
Document source-to-target mappings and operating procedures
Provide knowledge transfer
Required Qualifications
5+ years of experience
Bachelor's degree in a relevant technical field
Skills
Microsoft Fabric
ETL/ELT Pipeline Development
SAP Data Integration
Workday Data Integration
SQL
REST API Integration
Azure Data Factory
Python
PySpark
Power Query
Power BI
Database Development
Data Integration
Data Quality Management
Record Matching and Reconciliation
Source-to-Target Mapping Documentation
Knowledge Transfer
User Acceptance Testing Support
Data Governance
Next Steps
Shortlisted candidates will receive an email from with instructions to complete a required screening step.

Completion of this screening is mandatory to be considered for the role. If you do not receive this email after applying, please contact our Talent Expert at

Similar jobs