Senior Data Engineer – Transformations & dbt(Snowflake)
Location: Chennai, India (Office-based)
Experience: 5–7 Years
Employment Type: Full-Time / Contract
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 (5–7 Years Experience) 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 data 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, etc.)
- Conduct peer code reviews
- Maintain documentation, data lineage, and transformation logic
- Mentor mid-level and junior engineers where required
Requirements
Experience
- 5–7 years of experience in Data Engineering, Data Transformation, or Analytics Engineering
- Proven experience working with enterprise-scale data platforms
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 environments
- Strong communication skills (verbal and 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 with documentation and best practices
