Data Integration Engineer

DMI•Annapolis, MD
•$105,711 - $132,139

About The Position

DMI, LLC is seeking a Microsoft Fabric Data Integration Engineer to design and implement an automated, reliable solution for extracting data from SAP and Workday, importing it into Microsoft Fabric, and matching corresponding records using a designated common key. The solution will support financial, human resources, operational reporting, and analytics. The engineer will independently develop the integration architecture, pipelines, transformation and matching logic, and validation and reconciliation procedures. The role involves configuring Microsoft Fabric components, building automated ETL/ELT processes, establishing data storage and refresh workflows, and optimizing pipeline performance. The engineer will also analyze SAP and Workday structures and integration interfaces; create secure data extraction processes; and coordinate with system administrators, subject matter experts, and designated DLS personnel to validate source data and resolve discrepancies. The engineer will implement data quality controls, role-based access and security measures, audit trails, logging, and lineage in accordance with applicable information security, confidentiality, and governance requirements. The role also includes testing, user acceptance testing support, solution and operational documentation, knowledge transfer, and recommendations for long-term maintenance and future expansion. The contractor is expected to manage technical work independently, meet milestones, provide status updates, communicate risks and data quality issues, and deliver a reliable, secure, maintainable solution.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Information Technology, Data Engineering, or a related technical field, or an equivalent combination of education and relevant professional experience.
  • At least five years of professional experience in data engineering, data integration, database development, or a related discipline.
  • Demonstrated hands-on experience developing and deploying solutions using Microsoft Fabric.
  • Experience designing, developing, and maintaining automated ETL/ELT data pipelines.
  • Experience integrating enterprise application information, including ERP and/or HRIS systems.
  • Strong SQL proficiency, including complex joins, transformations, data validation, and reconciliation.
  • Experience matching and consolidating records from multiple systems using common identifiers, including addressing data quality and matching exceptions.
  • Direct, hands-on experience integrating data from both SAP and Workday.
  • Experience with SAP financial data and Workday human resources or payroll data.
  • Experience with SAP ECC 6.0 EHP 6, SAP data extraction interfaces, or SAP integration technologies.
  • Experience with Workday Reports-as-a-Service (RaaS), Workday Web Services, or Workday integration tools.
  • Eligibility to work in the United States.
  • Ability to independently manage technical activities, meet milestones, communicate project risks and data quality issues, and deliver a reliable, secure, maintainable solution.

Nice To Haves

  • Proficiency in Python, PySpark, or Power Query.
  • Experience with Microsoft Azure Data Factory and related Azure data services.
  • Experience developing datasets for Microsoft Power BI.
  • Experience implementing automated financial and personnel data reconciliation solutions.
  • Microsoft Fabric or relevant Microsoft Azure certifications.
  • Previous experience supporting government agencies or organizations handling sensitive financial and personnel information.
  • Experience delivering documented, production-ready data integration solutions within defined contractual timeframes.

Responsibilities

  • Design and implement a scalable data integration solution using Microsoft Fabric.
  • Configure and use 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, and establish staging, transformation, and integrated storage structures.
  • Configure refresh schedules, processing logs, error handling, and automated notifications; optimize pipeline performance and resource use.
  • Analyze SAP and Workday data structures and integration interfaces, and develop secure automated extraction processes using supported connectors, APIs, web services, or approved methods.
  • Implement initial loads and recurring incremental or full data refreshes, coordinating with system administrators and functional subject matter experts to establish access and validate source information.
  • Identify and validate the common key for matching SAP and Workday records; develop SQL joins, lookups, transformations, and standardization rules to associate records accurately.
  • Identify and address duplicate records, missing identifiers, inconsistent values, and unmatched records; maintain cross-reference or mapping tables where needed.
  • Implement automated reconciliation, exception reporting, and validation procedures, and work with DLS business and technical personnel to resolve discrepancies.
  • Develop data quality controls and verify record counts, key values, and other reconciliation measures against source systems.
  • Implement role-based access controls and security measures; maintain audit trails, processing logs, and data lineage in accordance with applicable requirements.
  • Develop and execute unit, integration, and data reconciliation tests, and support user acceptance testing with designated DLS personnel.
  • Document architecture, source-to-target mappings, transformation and matching logic, pipeline configurations, and operational procedures for monitoring, troubleshooting, and recovery.
  • Provide technical knowledge transfer and recommend improvements for maintainability, reliability, and future expansion.
  • Manage assigned technical activities and milestones, provide regular status updates, and promptly communicate risks, dependencies, and data quality issues.
  • Demonstrate that SAP and Workday records are joined using approved matching criteria and that discrepancies are documented and resolved or reported.

Benefits

  • Virtual health visits, commuter perks, pet insurance, and entertainment discounts.
  • Annual performance reviews, tuition assistance, and internal career growth opportunities.
  • 401(k) matching, life and disability insurance, and financial wellness tools.
  • Annual awards, service anniversaries, referral bonuses, and peer-to-peer recognition.
  • Healthcare coverage, wellness programs, flu shots, and biometric screenings.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service