Data Migration/ETL Engineer

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 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.

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 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.

Required Skills and Qualifications

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.

Full-Time Employee Compensation

M9 Solutions’ pay range for this position is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include, but are not limited to, responsibilities of the position, education, experience, knowledge, skills, abilities, as well as internal equity, location, alignment with market data, applicable bargaining agreement (if any), or other law.

M9 Benefits -  https://m9solutions.com/why-join-m9/#our-benefits

Salary Range $60,000 — $180,000 USD

M9 Solutions, LLC (M9) is a Federal sub-contractor and we comply with all applicable federal laws prohibiting discrimination in employment, including Title VII of the Civil Rights Act of 1964. We also adhere to the affirmative action requirements of the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and Section 503 of the Rehabilitation Act, ensuring equal opportunity for veterans and individuals with disabilities. Please click  here  to complete M9's Voluntary Self-Identification Form and then email it to  hr@m9solutions.com . If you need accommodation during the application process or encounter difficulties using our website, please contact our Human Resources Department at  hr@m9solutions.com  or  703-936-0880  

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.  

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.