Data Migration/ETL Engineer

Job not on LinkedIn

🔥 0 minutes ago

🏛️ District of Columbia, Washington – Remote

🏛️ District of Columbia – Remote ☕ Washington – Remote

💵 $60k - $180k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

M9 Solutions

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2007

💼 Consulting

🎖️ Defense

📦 Logistics

Consulting • Defense • Logistics

M9 Solutions is a company dedicated to providing IT services and solutions, primarily to federal government clients. The company focuses on mobilizing the appropriate personnel, skills, clearance levels, and technologies to aid organizations in achieving enhanced performance and sustainable change. M9 Solutions offers services in digital transformation, software development, cloud migration, applications and infrastructure management, cybersecurity, data science, and IT talent solutions. The company is committed to diversity, equity, and inclusion, aiming to create a positive work environment where every team member's voice matters. M9 Solutions has been involved in notable industry events and continues to play a significant role in shaping the future of digital technology in the defense and government sectors.

📋 Description

• 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

• 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

• 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