Senior Data Engineer – Transformations & dbt (Snowflake)

We are looking for a Senior Data Engineer – Transformations & dbt to join a Snowflake-centric enterprise data platform team.

This role is deeply hands-on and focuses on transforming raw Snowflake data into trusted, analytics-ready datasets using advanced SQL and dbt best practices. You will own data modeling standards, transformation reliability, and data quality while collaborating closely with analytics engineers, SQL developers, and US-based stakeholders.

This is not a support role. We are looking for someone who has built and owned production- grade transformation pipelines in real-world enterprise environments.

Key Responsibilities

Data Transformation & dbt Ownership

· Design, develop, and maintain dbt-based transformation pipelines

· Own fact and dimension modeling, including:

o Incremental models

o Slowly Changing Dimensions (SCD)

o Aggregations and rollups

· Establish and enforce dbt project structure, naming conventions, and modeling standards

· Manage transformation dependencies and execution ordering

Data Quality & Trust

· Implement dbt tests, validations, and reconciliation checks

· Ensure metric definitions are consistent, accurate, and trusted

· Proactively identify and resolve data quality issues

· Align transformed data with upstream source systems and business rules

Snowflake Optimization

· Optimize SQL transformations for performance and cost

· Tune Snowflake warehouse usage for transformation workloads

· Reduce unnecessary compute usage through efficient SQL and dbt design

Analytics Enablement

· Deliver clean, well-documented datasets for BI tools and analytics engineers

· Ensure datasets are semantic-ready for reporting and dashboards

· Support downstream analytics and visualisation teams

Engineering Excellence

· Follow Git-based development workflows

· Participate in CI/CD pipelines (Git, Jenkins, etc.)

· Conduct peer code reviews

· Maintain documentation, data lineage, and transformation logic

· Mentor mid-level and junior engineers where required

Requirements

Required Skills

· Advanced SQL (Snowflake)

· Strong hands-on experience with dbt

· Solid understanding of Snowflake architecture and data modeling

· Experience building analytics-ready datasets in production

· Strong communication skills (verbal & written English)

Benefits

Perks & Benefits

· Work on a US enterprise-grade data platform

· Long-term engagement with stable scope

· Exposure to advanced Snowflake and dbt workloads

· Clear role ownership and accountability

· Strong engineering culture and documentation practices