Location: 100% Remote - Mexico or South America (Brazil, Argentina, Chile, Colombia, Peru, Uruguay, Ecuador)
Engagement: Contract, long term, full time
Hours: US Central Time working hours
Experience: 10+ years in data engineering / enterprise data warehousing; 2+ years as Scrum Master or Agile Delivery Lead
Language: Fluent spoken and written English (client-facing daily); resume in English
Based in: Mexico or South America
Screening: Technical screen on advanced SQL, Teradata utilities and JCL

Our client, a large US consumer products and retail company, is looking for a Data Engineering Lead who also acts as Scrum Master for the data engineering team. You will own end-to-end delivery of batch and real-time pipelines across Teradata and mainframe systems, and help move data to Snowflake and Microsoft Fabric.

• Lead design and delivery of scalable batch and real-time data pipelines across legacy and cloud platforms.
• Drive Teradata query tuning, physical design, partitioning (PPI) and utility automation (BTEQ, TPT, FastLoad).
• Write, maintain and debug JCL procedures, mainframe utilities (IDCAMS, SORT / DFSORT) and batch schedules feeding the data pipelines.
• Build ingestion and transformation jobs into Snowflake and Microsoft Fabric Lakehouse.
• Set coding standards,
  
  
  
  CI/CD and automated testing; run code reviews and mentor engineers.
• Work with data architects, analytics engineers, BI developers and business users to turn requirements into technical specs.
• Act as Scrum Master: run sprint planning, stand-ups, backlog refinement, reviews and retrospectives.
• Track velocity, burndown and cycle time; remove blockers and protect the team from scope creep.
• Work with Product Owners to turn business initiatives into estimable user stories with acceptance criteria.

• 10+ years in data engineering or enterprise data warehousing.
• Expert SQL: window functions, CTEs, query plans, performance tuning, indexing.
• Deep hands-on Teradata: architecture, workload management, physical design, BTEQ, TPT, FastLoad, MultiLoad.
• Mainframe JCL: write, read and debug JCL, run batch processing, integrate mainframe feeds with databases.
• Data warehousing: dimensional modeling, Data Vault, star / snowflake schemas, SCD Types 1 / 2 / 4.
• 2+ years as Scrum Master or Agile Delivery Lead (Scrum / Kanban, capacity planning, Jira or Azure DevOps).
• Git and CI/CD (Azure DevOps, GitHub Actions or GitLab).

• Snowflake hands-on: micro-partitioning, caching, zero-copy cloning, time travel, SnowSQL / Snowpark.
• Microsoft Fabric: OneLake, Lakehouse / Warehouse, Fabric Data Factory, Delta Lake.
• Retail domain experience.

Recruiter screen technical round (SQL, Teradata, JCL) client manager round.