Data Migration ETL Engineer
About The Position
The Data Migration ETL Engineer implements repeatable, auditable migration pipelines from BOSS-E, MBMS, and related VA legacy sources into VA-EISS. The role critically reviews AI-generated ETL scripts and data transformations to verify that conversions preserve required business meaning and record integrity in support of VA-EISS modernization. The engineer builds and supports migration pipelines, staging schemas, cleansing and transformation processes, and reconciliation reports. The position also involves migration rehearsals and cutover support, coordinating with analysts, architects, QA, and VA stakeholders to resolve schema mismatches and mapping defects. This position is in the proposal stage. The stated salary range is $130,000–$140,000; the range is a general guideline, and base salary offers may depend on the position’s scope and responsibilities and the candidate’s experience, education, skills, and market conditions.
Requirements
- Bachelor’s degree in computer science or an IT-related field and 3–6 years of experience; additional years of experience may substitute for a degree for the right candidate.
- Hands-on SQL and data engineering experience with ETL/ELT, relational data modeling, and large-volume database migration.
- Ability to code and debug Python/SQL scripts and critically review AI-generated transformation logic.
- Practical understanding of source-to-target reconciliation, exception management, and migration testing.
- Experience building repeatable, version-controlled pipelines and supporting cutovers.
- Public Trust.
Nice To Haves
- Experience with SQL Server, Oracle, Salesforce extracts, AWS GovCloud/VAEC services, and DevSecOps automation.
- Experience with federal benefits or cemetery systems, auditability and PII protections, historical conversion, and GIS data migration.
- Experience with synthetic data, reconciliation automation, and VA-authorized AI coding tools.
Responsibilities
- Build SQL, Python, and ETL pipelines, staging schemas, data cleansing rules, transformation jobs, and automated reconciliation reports.
- Review AI-generated extraction, migration, and rollback scripts for accuracy, performance, idempotency, security, and repeatability.
- Execute migration rehearsals, measure throughput and data quality, diagnose exceptions, and support final cutover plans.
- Implement automated row-level and business-rule reconciliation across source and target systems, with appropriate evidence and audit logs.
- Coordinate with the Data Analyst, Data Architect, QA Lead, and VA stakeholders to resolve schema mismatches and mapping defects.
Benefits
- Paid parental leave
- Immediate vesting in 401(k)
- Medical, dental, and vision insurance
- Flexible spending accounts
- Short-term and long-term disability insurance
- Life insurance
- Paid time off and holidays
- Earned bonuses and awards
- Professional training reimbursement
- Employee assistance program
- Depending on the position, employees may be eligible for overtime, shift differential, and/or discretionary bonuses in addition to base pay.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
