Snowflake Senior Data Engineer (IN)
HCLTech
HCLTech
Seeking a Senior Data Engineer with extensive experience in Snowflake cloud data warehousing and modern ELT development using dbt. This role demands deep proficiency in advanced SQL, dimensional modeling techniques (Kimball/Data Vault), and strategies for incremental data loading and snapshotting. You will focus on performance tuning and cost optimization within the Snowflake environment.
Key responsibilities include designing scalable ELT pipelines, implementing CI/CD for dbt, integrating orchestration tools, and establishing robust data quality through automated testing and observability. A strong understanding of Snowflake's cloud security, Git for version control, and DevOps deployment practices is essential. This position also involves leading technical design reviews and mentoring data engineering teams, including offshore members, to ensure successful project delivery.
- Design, develop, and maintain robust dbt models within the Snowflake platform. - Construct reliable, thoroughly tested, and well-documented data transformation pipelines. - Implement comprehensive data quality checks, lineage tracking, and governance standards. - Optimize SQL queries and dbt models to enhance performance and manage costs effectively. - Collaborate closely with data engineering, BI, analytics, and business stakeholders. - Support Git-based development workflows, CI/CD processes, and deployment strategies.
- Proficient in advanced SQL and data modeling techniques. - Hands-on experience with dbt Core or dbt Cloud. - Proven experience working with Snowflake. - Solid understanding of ELT pipelines, data testing, documentation best practices, and version control systems. - Familiarity with analytics engineering principles and dimensional modeling. - Experience with cloud platforms and Snowflake security is highly valued. - Demonstrated ability to lead technical discussions and mentor junior engineers.
HCLTech
IT Consulting