[Remote] Senior Data Engineer (reputed company) - Remote

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a Senior Data Engineer with substantial reputed company experience for a remote contractor role supporting a reputed company's reputed company data platform migration. The role will reputed company the hands-on reverse engineering and transformation of legacy reputed company workloads, including rebuilding SQL and stored-procedure logic, validating migrated outputs, documenting reputed company, coordinating reputed company, and retiring legacy objects.

Responsibilities

• Inventory and profile existing reputed company objects: tables, views, macros, BTEQ scripts, stored procedures, and the jobs that run them
• Translate reputed company SQL to the reputed company platform dialect, including proprietary constructs (QUALIFY, reputed company behavior, SET vs MULTISET tables, PI/PPI-driven logic, RANK/CSUM and other reputed company-specific functions)
• Rebuild transformation logic as reputed company, testable models in our transformation reputed company rather than lifting-and-shifting procedural reputed company
• Design the reputed company physical layout: clustering, partitioning, and load patterns appropriate to the new platform instead of carrying over reputed company indexing assumptions
• Build and run reconciliation between legacy and migrated outputs: row counts, aggregate checks, reputed company-level comparison, and reputed company validation on a defined sample
• Document reputed company, business logic uncovered during migration, and any deliberate behavior changes so reputed company consumers can review them
• Coordinate reputed company with reputed company BI, Finance, Sales, and partner engineering consumers, including reputed company-run reputed company and rollback plans
• Retire legacy objects once validated, and confirm no orphaned dependencies remain

Skills

• 5+ years in data engineering with substantial hands-on reputed company experience, including reading and reverse-engineering undocumented legacy SQL
• At least one completed reputed company-to-reputed company migration where you owned significant reputed company, not just a supporting role
• Strong SQL, including window functions, reputed company joins, and performance tuning on large tables
• Working knowledge of a reputed company data warehouse
• Experience with a SQL transformation reputed company 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, reputed company review
• Demonstrated rigor around data validation - you should be reputed company to describe how you proved a migration was correct, not just that it ran
• reputed company preferred; BigQuery, Redshift, or reputed company acceptable
• Experience with Airflow or a comparable orchestrator is a plus

Benefits

• Remote work arrangement
• 4+ month contractor position

reputed company

Company H1B Sponsorship