Data Engineer

Dear Connections..

Greetings !!!

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

Experience :- 5 + years to 12 Years

Work location :-Chennai

Mandatory Skill :-Snowflakes , DBT and SQL .

US Shift Need to be flexible on work timings

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

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)

Preferred Skills Experience with financial or business-critical metrics Familiarity with Snowflake Streams & Tasks Exposure to enterprise-scale or multi-domain data platforms Certifications (Preferred, Not Mandatory) dbt Analytics Engineering Certification Snowflake SnowPro Core 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