Data Migration/ETL Engineer

M9 Solutions is seeking a Data Migration/ETL Engineer to work remotely in support of a government contract for a client located in Washington, DC. An active Public Trust clearance is required., * 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 (SFTP, 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.

• Work Authorization: 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 Skills and Qualifications

• Oracle HCM Data Loader (HDL) and HCM Spreadsheet Data Loader experience.
• Experience extracting from PeopleSoft HCM, Workday, or mainframe/COBOL HR systems.
• Federal HR data experience; familiarity with EHRI and federal records retention schedules.
• Experience handling large-volume PII under Privacy Act constraints.

With 15+ years of proven delivery and growth, M9 Solutions is a unique small business with credible past performance and key capabilities offering project management services, solution architects, business analysts, program managers, technical architects, and technical consultants. M9 was recognized as an Inc. 5000 Fastest-Growing Private Companies in 2021, 2020, 2019, 2018, 2017, 2016, and 2012. M9 Solutions believes that work should be fun, rewarding, and something everyone can be excited about. We offer a competitive compensation package and value diverse perspectives in driving the vision of the company.

M9 Solutions is dedicated to providing IT services and solutions to the Federal Government by mobilizing the right people, skills, clearance levels, and technologies to help organizations that desire improved performance and modern, sustainable change. M9 has provided quality IT services and support to more than 30 Federal Agencies and multiple commercial customers nationwide. Our capabilities include IT Talent Solutions, Data Delivery & Analytics, Cyber Security, Cloud Migration, Applications and Infrastructure, Software Development, and Finance & Accounting., M9 Solutions is a proud participant in the Virginia Values Veterans (V3) program and supports the Military Medics and Corpsmen (MMAC) initiative, demonstrating our commitment to hiring and supporting veterans, transitioning service members, military spouses, and dependents.