Snowflake Data Engineer Lead

Randomtrees; Hyderabad; On-site; INR 3,500,000 - 7,500,000; Full time

Job summary

Randomtrees seeks a Lead Snowflake Data Engineer to spearhead modernization, development, and scaling of a cloud data platform. You will lead a high-performing pod, architect scalable data pipelines, and migrate legacy Informatica ETL workflows into modern ELT using dbt on Snowflake, delivering production-ready data marts.

You must thrive in fast-paced delivery environments, mentor engineers, manage stakeholder expectations, and optimize performance while controlling compute costs in a dynamic

Qualifications

• 4+ years of hands-on Snowflake architecture
• 2+ years production dbt experience
• Strong Informatica legacy mappings knowledge
• Mastery of ANSI Snowflake SQL and Python
• Experience leading small-to-medium squads
• CI/CD deployment with Git-based workflows for dbt
• Cloud infra exposure (AWS/Azure/GCP) preferred

Responsibilities

• Lead a data engineering pod and manage sprint planning
• Architect end-to-end ELT/ETL pipelines on Snowflake
• Migrate legacy Informatica mappings to dbt models
• Design Star/Snowflake dimensional models and data marts
• Build ingestion utilities and orchestration hooks in Python
• Optimize SQL performance and manage compute credits
• Mentor engineers and handle production escalations

Skills

Snowflake Architecture

dbt (Core/Cloud)

Informatica (PowerCenter/IDMC)

SQL & Python

Leadership & Collaboration

CI/CD & Version Control

Tools

Snowflake

dbt

Informatica

Job description

Role: Lead Snowflake Data Engineer (dbt & Informatica)

Experience Level: 812+ Years

Employment Type: Full-Time

Role Overview

We are seeking an experienced Lead Snowflake Data Engineer to spearhead the modernization, development, and scaling of our enterprise cloud data platform. In this role, you will lead a high-performing engineering pod, architecting scalable data pipelines, modernizing legacy Informatica ETL workflows into modern ELT using dbt and Snowflake, and delivering production-ready data marts.

You must thrive in fast-paced, high-pressure delivery environments, demonstrate exceptional stakeholder management, and provide technical guidance and mentorship to senior and mid-level engineers.

Key Responsibilities

• Pod Leadership & Delivery: Lead a dedicated data engineering pod, drive sprint planning, conduct robust code reviews, and guarantee on-time delivery under tight, production-critical deadlines.
• Architecture & Modernization: Architect and implement end-to-end ELT/ETL pipelines, migrating legacy Informatica mappings and workflows into high-performance SQL and dbt models on Snowflake.
• Data Modeling & Engineering: Design dimensional models (Star/Snowflake schemas), staging layers, and consumption marts using dbt (macros, tests, snapshots, incremental models).
• Automation & Scripting: Build custom ingestion utilities, orchestration hooks, and operational automations using Python and advanced SQL.
• Performance Tuning & FinOps: Optimize complex SQL queries, warehouse sizing, clustering keys, micro-partitioning, and dbt run times while actively managing Snowflake compute and credit consumption.
• Stakeholder Management: Translate complex business requirements into clear technical specifications, communicate proactively across cross-functional teams, and handle critical production escalations smoothly.

Required Skills & Experience

• Snowflake: 4+ years of deep hands-on expertise with Snowflake architecture (virtual warehouses, Snowpipe, Streams, Tasks, Time Travel, zero-copy cloning, clustering, and security controls).
• dbt (Core or Cloud): 2+ years of production experience defining project structures, building reusable macros, implementing incremental models, documentation, and schema/custom data tests.
• Informatica (PowerCenter / IDMC): Strong foundation understanding legacy Informatica mappings, sessions, transformations, and workflows to accurately translate business logic into modern cloud ELT.
• SQL & Python: Mastery of advanced ANSI/Snowflake SQL (window functions, CTEs, semi-structured JSON querying) paired with solid Python programming for data extraction and scripting.
• Leadership & Collaboration: Proven track record leading small-to-medium squads, resolving delivery bottlenecks, and mentoring engineers.
• CI/CD & Version Control: Hands-on experience with Git and CI/CD deployment workflows (e.g., GitHub Actions, Azure DevOps, GitLab CI) for automated dbt and database deployments.

Preferred Qualifications

• SnowPro Core or SnowPro Advanced Data Engineer certification.
• dbt Certified Developer credential.
• Experience with workflow orchestrators (Apache Airflow, Dagster, or Prefect).
• Background in cloud infrastructure (AWS, Azure, or GCP).