Microsoft Fabric Data Integration Engineer
Metalight Solutions Inc
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Workday
- SAP ECC
- SAP ERP
- SQL
- Technical Writing
- Microsoft Power BI
- PySpark
- Python
- Microsoft
- Microsoft Azure
- Payroll
- SAP
- Finance
- JSON
- Knowledge Transfer
- Mapping
- Database
- EHP
- ELT
- Extract, Transform, Load
- Data Integration
- Data Quality
- Auditing
- Data Engineering
- Data Flow
- Data Validation
- Testing
- Warehouse
- Web Services
- Acceptance Testing
Summary
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
- Dice Id: 91172362
- Position Id: 9141040
- Posted 6 hours ago
Company Info
About Metalight Solutions Inc
Metalight Solutions is a modern talent solutions partner helping organizations across the US and Canada build high-performing teams through intelligent, scalable hiring solutions. We specialize in delivering top-tier talent across IT, Non-IT and Engineering domains, supporting businesses in fast-moving and competitive markets.
By combining high-level sourcing strategies, deep market intelligence, and human expertise, we identify candidates who are not only qualified, but aligned with business goals, culture, and long-term success. From Contract, C2C, Contract-to-Hire, to Permanent Hiring, we provide agile workforce solutions designed for today’s evolving business needs.
Our approach is built on speed, precision, and quality execution. With strong talent networks, data-driven recruitment strategies, and a delivery-focused mindset, we help clients close critical roles faster while maintaining hiring excellence.
We partner with startups, staffing firms, SMBs, and enterprise organizations, adapting seamlessly to diverse hiring models while ensuring transparency, responsiveness, and accountability at every stage.
At Metalight Solutions, we go beyond staffing, we enable growth by connecting businesses with the right talent, powered by technology and driven by results.