Senior Data Engineer (Teradata) - Remote

***Must have experience with Teradata***About:We’re looking for a remote Senior Data Engineer (Teradata experienced) to join our client's team for a 4+ month contractor position. You will lead the hands-on migration of legacy Teradata workloads onto our modern cloud data platform. This is a delivery role, not an advisory one. You will be reading legacy SQL and stored procedures, understanding what they actually do, and rebuilding that logic in the new stack with tests and documentation behind it.Responsibilities:•Inventory and profile existing Teradata objects: tables, views, macros, BTEQ scripts, stored procedures, and the jobs that run them•Translate Teradata SQL to the target platform dialect, including proprietary constructs (QUALIFY, MERGE behavior, SET vs MULTISET tables, PI/PPI-driven logic, RANK/CSUM and other Teradata-specific functions)•Rebuild transformation logic as modular, testable models in our transformation framework rather than lifting-and-shifting procedural code•Design the target physical layout: clustering, partitioning, and load patterns appropriate to the new platform instead of carrying over Teradata indexing assumptions•Build and run reconciliation between legacy and migrated outputs: row counts, aggregate checks, column-level comparison, and edge-case validation on a defined sample•Document lineage, business logic uncovered during migration, and any deliberate behavior changes so downstream consumers can review them•Coordinate cutover with downstream BI, Finance, Sales, and partner engineering consumers, including parallel-run windows and rollback plans•Retire legacy objects once validated, and confirm no orphaned dependencies remainRequirements:•5+ years in data engineering with substantial hands-on Teradata experience, including reading and reverse-engineering undocumented legacy SQL•At least one completed Teradata-to-cloud migration where you owned significant scope, not just a supporting role•Strong SQL, including window functions, complex joins, and performance tuning on large tables•Working knowledge of a cloud data warehouse (Snowflake preferred; BigQuery, Redshift, or Databricks acceptable) and how its cost and performance model differs from Teradata•Experience with a SQL transformation framework such as dbt, including testing and version control practices•Python for orchestration, tooling, and one-off data validation work•Git-based workflow: branching, pull requests, code review•Demonstrated rigor around data validation - you should be able to describe how you proved a migration was correct, not just that it ran•Experience with Airflow or a comparable orchestrator is a plus