Senior Data Engineer

Dear Connections..

Greetings !!!

We are hiring for Senior Data Engineer – Snowflake Transformations & dbt .

Location:

Chennai (Work From Office) with

Experience:

7–12 Years .

About the Role:

-  We are building a next-generation enterprise data platform on Snowflake and are seeking a Senior Data Engineer to take full ownership of the transformation layer powered by dbt. This is a core hands-on engineering role focused on designing and operating scalable transformation pipelines, defining canonical data models, and delivering high-trust analytics datasets that power business-critical reporting for US stakeholders. You will shape the semantic and transformation backbone of a multi-domain enterprise data platform.

Key Responsibilities :

- Transformation Engineering (dbt-Centric):  Design and product ionize scalable dbt pipelines, reusable macros, incremental models, and SCD Type 1 & 2 implementations with auditability.
Define modeling standards and own lifecycle from dev to deployment .

Enterprise Data Modeling & Semantic Layer :
Build star schemas, fact and dimension models aligned with business KPIs. Create analytics-ready datasets and establish canonical metric definitions.

Data Quality & Observability:  Implement dbt testing frameworks, perform reconciliations with source systems, define data SLAs, and resolve production data issues impacting reporting.

Snowflake Performance & Cost Optimization:  Optimize SQL transformations, design warehouse sizing strategies, leverage clustering and pruning, and ensure compute cost efficiency.

Engineering Excellence &

Collaboration:

Follow Git-based CI/CD workflows, maintain lineage and documentation, collaborate with BI and US stakeholders, and mentor mid-level engineers.

Must-Have Skills  Expert-level SQL with deep Snowflake optimization experience.
Strong hands-on experience with dbt (Core or Cloud) in production.
Proven expertise in dimensional modeling (Star Schema,
Fact & Dimension design). Experience building large-scale transformation pipelines in enterprise data platforms.
Strong understanding of data quality, lineage, and governance principles. Excellent communication skills for global stakeholder collaboration.

Preferred / High-Impact Experience :

- Experience with Snowflake Streams & Tasks, Airflow or other orchestration frameworks, Python for transformation utilities or validations, handling financial or KPI-critical datasets, and working on multi-domain enterprise data platforms.
Certifications (Good to Have)
Dbt Analytics Engineering Certification;
Snowflake Snow Pro Core Certification.

Why This Role Stands Out
Own the transformation backbone of a US enterprise data platform. Work on large-scale Snowflake workloads with real business impact. Influence modeling standards and platform architecture. Engage in a long-term roadmap with clear engineering ownership and strong focus on scalability, quality, and trust in data.

Who Should Apply
Senior Data Engineers or Analytics Engineers who prefer hands-on ownership, enjoy designing governed analytics-ready data models, and want to build serious production-grade Snowflake + dbt platforms with measurable business impact