Leads the team this role joins
Heads the group this role sits in
In-house, owns the opening
From your own Gmail and LinkedIn.
About the role
This is a senior data migration role in the Case Management Modernization program, which supports the Administrative Office of the US Courts, and it is listed as remote. The engineer plans and runs migrations, builds ETL and ELT pipelines, validates migrated data and manages cutovers, which suits someone with 5+ years of specialized experience and a relevant degree. The employer is General Dynamics Information Technology.
What you’ll do
- Plan and oversee migration, conversion and archival work, including schedules and dependencies
- Build migration scripts, SQL and ETL or ELT pipelines for legacy-to-cloud transfers
- Profile, cleanse and map data, and define source-to-target mappings
- Validate migrated data through reconciliation and QA testing
- Manage cutovers, including pre-checks, execution, sign-off and rollback
- Tune migration jobs for throughput and minimal downtime
- Design archival processes aligned to retention rules
- Manage cloud data platforms, including access control, cost and performance
- Automate provisioning and monitoring with Terraform, dbt, SQL or Python
What they’re looking for
- A master's degree with 5+ years, or a bachelor's degree with 7+ years, of general experience, plus 5+ years of specialized experience
- Strong data engineering and ETL or ELT experience with tools such as Informatica, Talend, AWS DMS or ADF
- Python, Bash and SQL for migration and reconciliation work
- Expertise in AWS data migration services and cloud data platforms
- Strong SQL performance tuning skills
- Familiarity with Terraform, dbt and CI/CD
- Ability to troubleshoot under tight cutover windows
- Familiarity with federal security and governance frameworks such as FedRAMP and NIST
Nice to have
- Hands-on work with Snowflake, Databricks, Redshift, SQL Server, Oracle or PostgreSQL
- Experience supporting federal programs or regulated environments
- Certifications such as CDMP, SnowPro Advanced, Databricks Certified Data Professional or AWS Certified Data Engineer
- Experience with FinOps and cloud cost modeling
What’s on offer
- Remote work with no travel required and 40 scheduled hours per week
- Likely salary range of $122,275-$165,431, with actual pay depending on experience, location and contract
- Medical, dental and vision plans, plus a 401(k) with company match
- Typically 15 days of paid leave and 10 paid holidays per year, plus paid family leave of up to 160 hours in a rolling 12-month period
- Hiring includes identity verification using biometrics and on-camera virtual interviews
Skills
Questions about this role
Is this role remote?
Yes, the work location is listed as any location or remote, with no travel required.
Is a security clearance needed?
No clearance is required for this role.
How many years of experience and what degree are needed?
A master's degree with 5+ years, or a bachelor's degree with 7+ years of general experience, plus 5+ years of specialized experience.