Data Migration Engineer

Responsibilities Inventory the legacy estate: schemas, objects, ETL jobs, Alteryx workflows, stored logic, reports and consumers. parse Alteryx workflows to extract embedded business logic. Build the dependency map Rebuild logic as tested Dataform models on silver/gold. Migrate historical data with row-count, sum and sample-record reconciliation; Document legacy defects discovered during migration and escalate for a business decision rather than silently correcting them. Produce the decommissioning plan for the legacy DWH and workflows, and the legacy migration record for handover. Required skills and experience 6+ years in data warehouse migration and ETL modernisation. Expert SQL across at least two of SQL Server / Oracle / Teradata / PostgreSQL, including stored-procedure logic archaeology. Hands-on Alteryx Designer: reading, documenting and re-expressing workflow logic in SQL. This is the scarcest skill in the team — confirm availability early. Reconciliation technique: designing tolerance-based comparison of legacy and target outputs and defending results at acceptance. BigQuery target-side development (Dataform or dbt). The judgement to argue for retirement rather than migration where usage analysis supports it. Certifications Preferred: Alteryx Designer Core/Advanced; Google Cloud Professional Data Engineer.