Microsoft Fabric Data Integration Engineer (Need Local Profiles for In-person Interview)

Annapolis, MD, US • Posted 7 days ago • Updated 20 hours ago
Contract W2
Contract Corp To Corp
18 Months
No Travel Required
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Extract
  • Transform
  • Load
  • Data Extraction
  • Data Integration
  • Data Quality
  • Data Flow
  • Microsoft Fabric

Summary

Job Description

We’re seeking a hands-on Microsoft Fabric Data Integration Engineer to build automated pipelines that bring SAP and Workday data into Microsoft Fabric. The engineer will match records across both systems using a common identifier and validate the resulting datasets for financial, HR, and operational reporting.

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.
  • 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, and provide knowledge transfer.

Qualifications

  • Bachelor’s degree in a relevant technical field or an equivalent combination of education and professional experience.
  • Demonstrated hands-on experience developing and deploying Microsoft Fabric solutions and building automated ETL/ELT pipelines.
  • Direct experience integrating data from both SAP and Workday, including SAP financial data and Workday HR or payroll data.
  • Advanced SQL skills, including complex joins, data transformation, record matching, and reconciliation.
  • Experience with secure enterprise integrations using REST APIs, JSON, or web services.

Additional relevant experience includes SAP ECC 6.0 EHP 6, Workday Reports-as-a-Service or Workday Web Services, Python, PySpark or Power Query, Azure Data Factory, and Power BI.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91172362
  • Position Id: 9141031
  • Posted 7 days 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.

Contact the job poster
AD

Ankur Dashottar

Recruiter @ Metalight Solutions Inc

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.