Back to Jobs
Recently postedTechnology

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

Metalight Solutions IncAnnapolis, MD🇺🇸United States

Quick overview

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

Job description

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.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs