Microsoft Fabric Data Integration E...

Role Overview

Metalight Solutions, in partnership with Dice, is recruiting for a Microsoft Fabric Data Integration Engineer. This role focuses on building automated pipelines that integrate SAP and Workday data into the Microsoft Fabric ecosystem.

Key Responsibilities:

• Pipeline Development: Design, build, and monitor ETL/ELT pipelines using Fabric Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse, and Fabric Warehouse.
• Data Automation: Automate secure data extraction from SAP (financial) and Workday (HR/Payroll). Configure initial loads and recurring refreshes using supported connectors, APIs, or web services.
• Data Quality & Reconciliation: 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.
• Governance & Security: Maintain access controls, audit logs, and robust data lineage.
• Collaboration: Support testing and user acceptance (UAT), document source-to-target mappings, standard operating procedures, and facilitate knowledge transfer.