2,342,941open jobs
147,010companies
284,491added this week
Browse all
Location
In office (Annapolis)
Seniority
Senior · 5+ years exp

Confirmed on the employer's own hiring board on Nov 17, 2026. First seen by Alion on Nov 17, 2026.

Overview
Company
Impact
Profile match

DMI

DMI is an American digital services and technology solutions company headquartered in Tysons, Virginia, providing managed IT services including managed mobility, cloud and infrastructure, cybersecurity, network operations, end-user support and application development. It serves federal agencies such as the Federal Trade Commission and the US Senate Sergeant at Arms as well as commercial enterprises, and also offers AI and data, ServiceNow and low-code modernization work. It hires network engineers and NOC staff, service desk analysts, ServiceNow developers and architects, security analysts, data engineers, program managers and customer support staff.

About DMI

DMI is a leading provider of digital services and technology solutions, headquartered in Tysons Corner, VA. With a focus on end-to-end managed IT services, including managed mobility, cloud, cybersecurity, network operations, and application development, DMI supports public sector agencies and commercial enterprises around the globe. Recognized as a Top Workplace, DMI is committed to delivering secure, efficient, and cost-effective solutions that drive measurable results. Learn more at www.dminc.com

About the Opportunity

DMI, LLC is looking for a Microsoft Fabric Data Integration Engineer to join our team. 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. The selected candidate will be 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. The solution will support financial, human resources, operational reporting, and analytical requirements of the client. The contractor must possess demonstrated, hands-on Microsoft Fabric development experience and the ability to independently design and implement complex data integration solutions involving multiple enterprise applications.

Duties and Responsibilities:

  • Microsoft Fabric Solution Design and Development
    • 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.
    • Establish appropriate staging, transformation, and integrated data storage structures.
    • Configure data refresh schedules, processing logs, error handling, and automated notifications.
    • Optimize data pipeline performance and ensure efficient resource utilization.
  • SAP and Workday Data Extraction and Integration
    • 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.
    • Implement initial data loads and recurring incremental or full data refresh processes, as appropriate.
    • Coordinate with SAP and Workday system administrators and functional subject matter experts to establish data access and validate source information.
    • Ensure source-system data integrity and compliance with applicable security requirements.
  • Data Matching, Joining, and Reconciliation
    • A critical responsibility of this position is the ability to accurately associate and consolidate records from SAP and Workday.
    • The contractor will:
    • 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.
    • Identify and resolve duplicate records, missing identifiers, inconsistent values, and unmatched records.
    • Develop and maintain cross-reference or mapping tables when source-system identifiers are not directly compatible.
    • Implement automated reconciliation procedures to validate the completeness and accuracy of the integrated data.
    • Develop exception reports to identify records that cannot be successfully matched or reconciled.
    • Work with designated DLS business and technical personnel to validate matching rules and resolve data discrepancies.

The successful candidate 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.

  • Data Quality, Security, and Governance
    • Develop and implement automated data quality and validation procedures.
    • Verify record counts, key field values, and other appropriate reconciliation measures against source-system information.
    • Establish controls to identify incomplete, inaccurate, or inconsistent data.
    • Implement role-based access controls and appropriate security measures to protect sensitive financial and personnel information.
    • Maintain appropriate audit trails, processing logs, and data lineage.
    • Ensure the solution complies with applicable MGA information security, confidentiality, and data governance requirements.
  • Testing, Documentation, and Knowledge Transfer
    • Develop and execute unit, integration, and data reconciliation tests.
    • Support user acceptance testing with designated DLS personnel.
    • Document the solution architecture, source-to-target mappings, transformation rules, data matching logic, and pipeline configurations.
    • Prepare operational procedures covering scheduled processing, monitoring, troubleshooting, and recovery.
    • Provide technical knowledge transfer to designated DLS information technology personnel.
    • Recommend improvements to support long-term maintenance, reliability, and future expansion of the solution.

Qualifications

Education and Years of Experience:

  • 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.
  • Minimum of 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 information from enterprise applications, including ERP and/or HRIS systems.
  • Strong proficiency in SQL, including complex joins, transformations, data validation, and reconciliation.
  • Demonstrated experience matching and consolidating records from multiple systems using common identifiers.

Required Skills & Certifications:

  • Microsoft Fabric
    • Data Factory and Data Pipelines
    • Dataflows Gen2
    • OneLake and Lakehouse
    • Fabric Warehouse
    • Data transformation and orchestration
    • Pipeline monitoring and troubleshooting
  • Data Integration and Development
    • Advanced SQL development
    • ETL/ELT architecture and implementation
    • Data modeling and source-to-target mapping
    • Data matching, reconciliation, and exception handling
    • REST APIs, JSON, and web services
    • Secure enterprise data integration
  • Enterprise Systems
    • Experience extracting data from SAP and/or Workday and writing/creating reports per user requirements once Fabric is accurately populated.
    • Understanding of enterprise financial and human resources data structures
    • Experience developing interfaces between disparate enterprise applications
    • Understanding of data security and access management requirements

Additional Requirements:

  • 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.
  • 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.
  • Performance Expectations - The contractor will be expected to:
    • Independently manage assigned technical activities and meet agreed-upon project milestones.
    • Provide regular status updates to designated DLS project management and technical personnel.
    • Identify and communicate project risks, technical dependencies, and data quality issues promptly.
    • Deliver a reliable, secure, and maintainable integration solution.
    • Demonstrate that SAP and Workday records are accurately joined using the approved matching criteria.
    • Ensure that identified discrepancies are appropriately documented and resolved or reported.

Citizenship Status Required: Must be eligible to work in the United States

Physical Requirements: Not required for this position

Location: Annapolis, MD

Minimum Salary Rate

$105,711

Median Salary Rate

$132,139

Working at DMI

DMI is a diverse, prosperous, and rewarding place to work. Our culture is shaped by five core values that guide how we work, grow, and succeed together:

  • Do What’s Right - We lead with honesty and integrity.
  • Own the Outcome - We take responsibility and deliver.
  • Deliver for Our Customers - We are relentless about delivering value.
  • Think Bold, Act Smart - We innovate with purpose.
  • Win Together - We collaborate and celebrate our success.

These values aren’t just ideals-they show up in how we support every part of your well-being:

  • Convenience/Concierge - Virtual health visits, commuter perks, pet insurance, and entertainment discounts that make life easier.
  • Development - Annual performance reviews, tuition assistance, and internal career growth opportunities to help you thrive.
  • Financial - Generous 401(k) matches, life and disability insurance, and financial wellness tools to support your future.
  • Recognition - Annual awards, service anniversaries, referral bonuses, and peer-to-peer shoutouts that spotlight your achievements.
  • Wellness - Healthcare coverage, wellness programs, flu shots, and biometric screenings to support your health.

DMI values employees for their talents and contributions, and we take pride in helping our customers achieve their goals. Because when we live our values, we all win together.

***************** No Agencies Please *****************

Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,342,941 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Remote, many countries
Similar stack
Same company
Annapolis
Remote (United States) · Full-Time · 5+ years exp · Bachelor's Degree · Salt Lake City
Python
SQL
Databases
PostgreSQL
Oracle
CockroachDB
MS SQL
YugabyteDB
DevOps
Azure
CI/CD
AWS
Apply
Data Engineer 1 hour ago
Hybrid · Full-Time · 4+ years exp · Bachelor's Degree · Saint Louis
Python
SQL
Databases
Snowflake
AI/ML
dbt
DevOps
CI/CD
Git
Incident Management
Analytics
ETL/ELT
Management
ServiceNow
Apply
In office · 5+ years exp · Bachelor's Degree · Houston
Python
SQL
AI/ML
Spark
Frontend
GraphQL
DevOps
Rest API
GCP
Azure
CI/CD
Kubernetes
Grafana
Analytics
Power BI
Apply
Data Architect 1 hour ago
In office · 10+ years exp · Bachelor's Degree · Blue Bell
Python
SQL
Databases
PostgreSQL
Snowflake
DynamoDB
AI/ML
dbt
RAG
Tokenization
DevOps
Terraform
Prometheus
CI/CD
Git
AWS
AWS Lambda
Cortex
Amazon S3
IAM
Amazon Kinesis
AWS Step Functions
Cybersecurity
SOC 2
GDPR
HIPAA
Analytics
Data Vault
Life Sciences
CDISC
MedTech
21 CFR Part 11
HL7
FHIR
Apply
Data Scientist 2 hours ago
$175k – $250k per year · Hybrid · Full-Time · 4+ years exp · San Francisco · Toronto
Python
SQL
Databases
Google BigQuery
AI/ML
dbt
AI Agents
DevOps
GCP
Apply
Remote (likely EAEU) · Moscow
SQL
Databases
PostgreSQL
DevOps
Git
Gitflow
Analytics
ETL/ELT
Apply
Remote (likely EAEU) · Moscow
Python
Go
Databases
ClickHouse
DevOps
Kubernetes
Analytics
ETL/ELT
Apply
$132k – $176k per year · Remote (EMEA) · Full-Time
Python
SQL
Databases
Snowflake
Databricks
Google BigQuery
Microsoft Fabric
AI/ML
Copilot
Cursor
Claude
Model Context Protocol
dbt
AI Agents
OpenAI Codex
Agentic Workflows
DevOps
CI/CD
Git
Kubernetes
Game Dev
Unity
Analytics
Collibra
Alation
Apply
Remote (likely LATAM) · 5+ years exp
Python
SQL
Databases
SAP HANA
SAP BW
DevOps
Azure
Git
AWS
Analytics
ETL/ELT
Alteryx
Microsoft Excel
Apply
Remote (Europe) · Freelance · Amsterdam
AI/ML
Synthetic Data
Management
Agile
Apply
In office · Annapolis
Cybersecurity
HIPAA
Apply
In office · 3+ years exp · Bachelor's Degree · Annapolis
Apply
$30k – $40k per year · In office · 1+ year exp · High School Diploma · Annapolis
Apply
$70k – $95k per year · In office · Bachelor's Degree · Annapolis
Apply
In office · 1+ year exp · Annapolis
Apply
See all jobs
This is one of many
2,342,941 more open roles from verified company boards, updated every day.