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