Inferenz - Lead Data Engineer - Apache Airflow

About the Company

We are seeking a Lead Data Engineer with deep expertise in Snowflake, dbt, and Apache Airflow to design, implement, and optimize scalable data solutions.

This role involves working on complex datasets, building robust data pipelines, ensuring data quality, and collaborating closely with analytics and business teams to deliver actionable insights.

If you are passionate about data architecture, ELT best practices, and modern cloud data stack, wed like to meet you.

About the Role :

We are seeking a Lead Data Engineer with deep expertise in Snowflake, dbt, and Apache Airflow to design, implement, and optimize scalable data solutions.

Responsibilities :

• Pipeline Design & Orchestration : Build and maintain robust, scalable data pipelines using Apache Airflow, including incremental & full-load strategies, retries, and logging.
• Data Modelling & Transformation : Develop modular, tested, and documented transformations in dbt, ensuring scalability and maintainability.

Snowflake Development : Design and maintain warehouse in Snowflake, optimize Snowflake schemas, implement performance tuning (clustering keys, warehouse scaling, materialized views), manage access control, and utilize streams & tasks for automation.

Data Quality & Monitoring : Implement validation frameworks (null checks, type checks, threshold alerts) and automated testing for data integrity and reliability.

Collaboration : Partner with analysts, data scientists, and business stakeholders to translate requirements into scalable technical solutions.

Performance Optimization : Develop incremental and full-load strategies with continuous monitoring, retries, and logging and tune query performance and job execution efficiency.

Infrastructure Automation : Use Terraform or similar IaC tools to provision and manage Snowflake, Airflow, and related environments.

Partner with data analysts, scientists, and business stakeholders to translate reporting and analytics requirements into technical :

710 years of experience in data engineering, with strong hands-on expertise in :

Good to have :

(ref : hirist.tech)