Data Migration/ETL Engineer

M9 Solutions

Data Migration/ETL Engineer supporting M9 Solutions’ federal-government IT services and modernization contracts. Designing pipelines, transforming and validating enterprise data, and executing secure production migrations.

Posted 8/13/2026full-timeRemote • District of Columbia, Washington • 🇺🇸 United StatesMid-LevelSenior💰 $60,000 - $180,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in ETL process design and development, data migration, and validation testing, with a strong focus on data protection standards and compliance. Proficient in SQL and experienced in handling large-volume data migrations within cloud HCM or ERP platforms.

Highest-signal resume keywords

ETL DevelopmentSQL ProficiencyData Migration ExperienceOracle HCM Data LoaderFederal HR Data Familiarity

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL ProcessesData PipelinesData CleansingData TransformationData ValidationData ReconciliationSFTP IngestionError HandlingData MappingData Migration Testing

Tools & Technologies

Oracle HCMPeopleSoft HCMWorkdayCOBOLCloud ERP Platforms

Certifications & Qualifications

Public Trust Clearance

Industry Keywords

Data Protection StandardsPrivacy Act ComplianceFederal Records RetentionGolden Data Test SetClient-Specific Datasets

Tech Stack

Tools & technologies

CloudERPETLOracleSQL

About the role

Key responsibilities & impact

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 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; support reconciliation and post-migration audit.
Contribute to data tables, data dictionary, and validation testing against the Golden Data Test Set.
Support daily data migration status reporting during active migration.

Requirements

What you’ll need

US Citizenship is required.
An active Public Trust level clearance is required.
Undergraduate degree; degree may be substituted with equivalent years of experience.
5–7 years of relevant experience; 2 years consulting preferred.
Hands-on ETL development experience on enterprise-scale data migrations.
Strong SQL and data transformation skills.
Experience loading data into a cloud HCM or ERP platform.
Experience with validation, reconciliation, and error handling at volume.
Preferred: Oracle HCM Data Loader (HDL) and HCM Spreadsheet Data Loader experience.
Preferred: experience extracting from PeopleSoft HCM, Workday, or mainframe/COBOL HR systems.
Preferred: federal HR data experience and familiarity with EHRI and federal records retention schedules.
Preferred: experience handling large-volume PII under Privacy Act constraints.

Benefits

Comp & perks

Full-Time Employee Compensation
Competitive compensation package
M9 Benefits (benefits are linked but not itemized in the posting)
Equal opportunity and support for veterans, transitioning service members, military spouses, and dependents