Data Migration/ETL Engineer

M9 Solutions is seeking aData Migration/ETL Engineerto work remotely in support of a government contract for a client located inWashington,DC.An activePublic Trust clearanceis 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 activePublic Trust levelclearance 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 andgrowth, 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 valuediverse perspectivesin 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., M9 Solutions is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. This policy applies to all employment decisions, including, but not limited to, recruitment, hiring, compensation, training and apprenticeship, promotion, upgrading, demotion, downgrading, transfer, lay-off and termination, and all other terms and conditions of employment. All decisions regarding conditions of employment will be based on applicable law, including the individual’s overall qualifications and his/her ability to meet the requirements of the position. M9 Solutions is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. To request reasonable accommodation or to view the Affirmative Action Plan, contact M9 Solutions HR Department: hr.inquiries@m9solutions.com.