Data Migration Engineer
* US Citizens Only. No C2C or 3rd Parties *Summary The Ash Group is hiring a Data Migration Engineer (24647) for our client, a global leader providing advanced systems and support in defense, aerospace, and security. This is a 4-month contract position working remotely (must be located in the US and be a US Citizen). We are offering a pay rate up to $47/hr W2 based on skill set.
Role Details
Compensation:
Up to $47/hr W2Benefits: Medical, dental, vision, and direct primary care benefits. After six months of employment, enjoy a 4% matched 401(k) plan with immediate 100% vesting.
Duration: 4-month contract
Location: Remote (must be located in the US and be a US Citizen)
What You’ll Be Doing:
Pipeline Translation: Convert R (dplyr/data.table) and Alteryx workflows into modular, optimized SQL (CTEs, window functions, set-based logic) and/or Dataiku visual/SQL recipes—prioritizing correctness over elegance.
Cloud Warehouse Execution: Deploy/test translated logic on one primary cloud platform (Redshift or Snowflake or Athena)—no need for multi-cloud expertise.
Validation & Handoff: Run unit-style validation against source pipelines; document assumptions, lineage, and deployment steps for internal teams.
Knowledge Transfer: Conduct 2–3 focused sessions (max 1 hr each) walking data science/analytics team members through migrated pipelines and validation reports.
Documentation: Maintain a living wiki/OneNote page with transformation logic, test results, and known limitations—not formal data governance artifacts.
What We’re Looking For:
Bachelor’s degree in CS, IS, Data Engineering, or equivalent practical experience (e.g., 3+ years hands-on SQL/data pipeline work).2–4 years in data engineering with direct pipeline migration/re-platforming experience (e.g., moved Alteryx to Dataiku; converted R to SQL/Python; packaged SQL to DBT, other equivalent experience).Fluency in writing/optimizing queries (JOINs, CTEs, window functions) for cloud warehouses and traditional databases (Redshift/SQL Server).Proven track record converting R/Alteryx logic to SQL or equivalent experiences (KNIME, Informatica, etc).Comfort building simple row-count/checksum tests to verify migration fidelity.