Senior Data Engineer

Dear Connections ., Greeting!!! We are hiring for Senior Data Engineer - Transformations dbt (Snowflake) Location: Chennai, India (Office-based) Employment Type: Full-Time Contract Experience: 5-7 Years Time Zone: US Time Zone Overlap (3-4 hours daily) Client Environment: US-based enterprise data platform

Role Overview

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:
  • Incremental models
  • Slowly Changing Dimensions (SCD)
  • 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, )
• 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

Disclaimer: This job description has been sourced from a public domain and may have been modified by Naukri.com to improve clarity for our users. We encourage job seekers to verify all details directly with the employer via their official channels before applying.