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 Snow Pro 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