Fabric Data Engineer

RemyCorporation is seeking a Fabric Data Engineer for a six-month remote contract. The role will build automated integrations that extract SAP and Workday data into Microsoft Fabric, match records using a common key, and validate and reconcile the integrated datasets.

Responsibilities:

• The primary objective of this engagement is to establish an automated and reliable process for extracting data from two enterprise systems, SAP and Workday, importing that data into Microsoft Fabric, and joining corresponding records using a designated common key data element
• Responsible for developing the data integration architecture, creating automated data pipelines, establishing data transformation and matching logic, and implementing validation and reconciliation procedures to ensure the accuracy and integrity of the resulting integrated datasets
• Design and implement a scalable data integration solution using Microsoft Fabric
• Configure and utilize Microsoft Fabric Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse, and Warehouse components, as appropriate
• Develop automated ETL/ELT processes to import, transform, and consolidate enterprise data
• Analyze SAP and Workday data structures and available integration interfaces
• Design and develop secure, automated processes to extract required data elements from both systems
• Utilize appropriate supported connectors, APIs, web services, or approved extraction methods
• Identify, analyze, and validate the designated common key data element used to match corresponding records between SAP and Workday
• Develop SQL-based joins, lookup operations, and transformation logic to associate records accurately across both systems
• Establish appropriate data standardization rules to address differences in data types, field formats, and naming conventions
• Must demonstrate experience joining and reconciling data from disparate enterprise systems using a common identifier, including the ability to address data quality and matching exceptions

Requirements:

• MUST have Workday and SAP experience
• experience joining and reconciling data from disparate enterprise systems using a common identifier, including the ability to address data quality and matching exceptions