Data Engineering Lead (SQL, Teradata, JCL, Snowflake, Microsoft Fabric)

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

About The Role

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.

Responsibilities

- 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.

Required

- 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).

Preferred

- 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.

Interview process

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

📌 Data Engineering Lead (SQL, Teradata, JCL, Snowflake, Microsoft Fabric) - Colombia
🏢 Snowrelic
📍 Colombia