Full-Time

Data Migration/ETL Engineer

Updated on 8/20/2026

M9 Solutions

M9 Solutions

51-200 employees

Federal IT services: software, cloud, security

Compensation Overview

$190k - $204k/yr

No H1B Sponsorship

Washington, DC, USA

Remote

US Citizenship Required

Bachelor's

Category
Data & Analytics (1)
Required Skills
ERP
Workday HRIS
SQL
ETL
Mainframe Computing
Data Engineering

Get referred to M9 Solutions

See people who can refer or advise you

Requirements
  • U.S. citizenship is required.
  • An active Public Trust clearance is required.
  • An undergraduate degree is required, although equivalent years of experience may be substituted.
  • Five to seven years of relevant experience is required; two years of consulting experience is preferred.
  • Hands-on ETL development experience on enterprise-scale data migrations is required.
  • Strong SQL and data transformation skills are required.
  • Experience loading data into a cloud human resources management or enterprise resource planning platform is required.
  • Experience with validation, reconciliation, and error handling at volume is required.
Responsibilities
  • Design and develop ETL processes and data pipelines using approved schemas and non-proprietary data and software standards.
  • Develop client-specific obfuscated datasets meeting data protection standards and migrate them into non-production environments.
  • Develop and execute data migration test cases and scripts validating completeness, accuracy, and go-live readiness.
  • Execute migration dry runs in non-production, assess results against minimum quality standards, and refine transformation logic.
  • Perform data cleansing and mapping against client data standards.
  • Support secure file-based ingestion using SFTP and encrypted transfer from legacy systems.
  • Execute production migration following approval and support reconciliation and post-migration audit.
  • Contribute to data tables, the data dictionary, and validation testing against the Golden Data Test Set.
  • Support daily data migration status reporting during active migration.
Desired Qualifications
  • Two years of consulting experience.
  • Oracle HCM Data Loader and HCM Spreadsheet Data Loader experience.
  • Experience extracting from PeopleSoft HCM, Workday, or mainframe/COBOL HR systems.
  • Federal human resources data experience and familiarity with EHRI and federal records retention schedules.
  • Experience handling large-volume personally identifiable information under Privacy Act constraints.

M9 Solutions provides IT services and solutions to the Federal Government. It focuses on software development, cloud migration and infrastructure, cybersecurity, data delivery, and data analytics. Its products and services work by mobilizing skilled people and technologies to design, build, secure, and operate digital systems that improve performance and enable modern, sustainable change for government agencies. The company differentiates itself through its combination of domain expertise in federal IT, a focus on secure and stable technology delivery, and its commitment to delivering the digital future by aligning talent with mission needs. The goal is to help public sector organizations achieve better outcomes, resilient operations, and ongoing modernization.

Company Size

51-200

Company Stage

N/A

Total Funding

N/A

Headquarters

Arlington, Virginia

Founded

2007

Get referred to M9 Solutions

See people who can refer or advise you

Simplify Jobs

Simplify's Take

What believers are saying

  • M9 completed CMMC Level 1 self-assessment in 2025, improving defense bid eligibility.
  • NTIS joint venture positioning supports access to federal data modernization work.
  • Leadership bench remains intact in 2026 with COO Ethel Formichelli and founder James McKee.

What critics are saying

  • Sean DuGuay left M9 in December 2024 for Aretum, weakening growth leadership.
  • HigherGov shows no recent awards, signaling thin visible demand through August 2025.
  • Without meaningful new contracts, M9 risks becoming a small, replaceable subcontractor by 2026.

What makes M9 Solutions unique

  • M9 Solutions pairs NTIS data innovation support with federal IT services since 2022.
  • M9 Solutions preserved SPRS affirmation after CMMC Level 1 self-assessment in 2025.
  • Founder James McKee still leads; stable ownership supports specialized federal contracting relationships.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

401(k) Retirement Plan

Remote Work Options

Flexible Work Hours

Paid Vacation

Paid Sick Leave

PTO/vacation

Unlimited Paid Time Off

Hybrid Work Options

Wellness Program

Mental Health Support

Conference Attendance Budget

Professional Development Budget

Stock Options

Company Equity

Phone/Internet Stipend

Home Office Stipend

Relocation Assistance

Adoption Assistance

Family Planning Benefits

Fertility Treatment Support

Childcare Support

Elder Care Support

Parental Leave

Performance Bonus

Profit Sharing

Employee Stock Purchase Plan

Tuition Reimbursement

Professional Certification Support

Mentorship Program

Training Programs

Tuition Reimbursement

Meal Benefits

Commuter Benefits

Legal Services

Employee Discounts

Company Social Events

Company News

PR Newswire
Apr 25th, 2023
Former Capgemini Executive Sean DuGuay Joins IT Services Provider M9 Solutions as President & CRO

Sean DuGuay, former Principal of National Security and Defense at Gapgemini Government Solutions, has joined M9 Solutions as President and Chief Revenue Officer, the information technology services and solutions provider announced on Friday.

PR Newswire
May 20th, 2022
M9 Solutions hires David Callner as Executive Team

M9 Solutions is pleased to welcome Chief Growth Officer David Callner to the Executive Team.