Microsoft Fabric Data Integration Engineer

Job Description

A public sector organization in Annapolis is bringing on a Microsoft Fabric Data Integration Engineer to build an automated integration between SAP and Workday. The work covers extracting data from both systems, loading it into Microsoft Fabric, and joining the records on a common key, along with the validation, reconciliation, reporting and documentation needed to hand the solution off to the internal IT team.

What You'll Do

• Design and build the integration in Microsoft Fabric using Data Factory, Data Pipelines, Dataflows Gen2, OneLake, Lakehouse and Warehouse
• Extract data from SAP and Workday through supported connectors, APIs or web services, with initial and incremental loads
• Build SQL joins, standardization rules and cross-reference tables to match records across both systems
• Automate reconciliation, data quality checks and exception reporting
• Set up refresh schedules, logging, error handling, alerts and role-based security for sensitive finance and HR data
• Build reports from the integrated data based on user requirements
• Work with the SAP and Workday admins and business users to validate source data and matching rules
• Document the architecture, source-to-target mappings and runbooks, and train internal IT to support the solution

Required Qualifications

• 5+ years in data engineering, data integration or database development
• Hands-on experience building and deploying solutions in Microsoft Fabric
• Advanced SQL, including complex joins, transformations, validation and reconciliation
• Experience building automated ETL/ELT pipelines
• Experience integrating data from ERP and/or HRIS systems, including SAP and/or Workday
• Experience matching and reconciling records across separate systems using a common identifier
• REST APIs, JSON and web services
• Data modeling and source-to-target mapping
• Bachelor's degree in Computer Science, Information Systems or a related field, or equivalent experience

Preferred Qualifications

• Direct experience integrating data from both SAP and Workday
• SAP financial data (SAP ECC 6.0) and Workday HR or payroll data
• SAP data extraction interfaces, Workday Reports-as-a-Service (RaaS) or Workday Web Services
• Python, PySpark or Power Query
• Azure Data Factory and Power BI dataset development
• Microsoft Fabric or Azure data certification
• Government experience or other work with sensitive financial and personnel data
• Track record of delivering documented, production-ready integrations on fixed contract timelines

Benefits: No benefits are offered for this contract position

Work Authorization: Must be authorized to work in the US without sponsorship