Chennai, Tamil Nadu
Job Summary

Highly skilled Data Engineer with strong expertise in Snowflake and dbt should possess extensive hands-on experience in designing, building, optimizing, and maintaining modern cloud-based data platforms. The candidate must have a strong foundation in Data Warehousing, ETL/ELT processes, Data Modeling, SQL, and RDBMS technologies along with the ability to develop scalable and high-performing data solutions.

Key Responsibilities
Design, develop, and maintain scalable data pipelines using Snowflake and dbt.
Build and optimize data warehouse solutions to support analytics and reporting requirements.
Develop ELT/ETL frameworks and data transformation processes using industry best practices.
Design and implement dimensional and normalized data models.
Write Complex SQL queries when required.
Create reusable dbt models, macros, tests, snapshots, and documentation.
Optimize Snowflake performance, storage, and compute costs.
Develop and maintain data ingestion frameworks from various source systems.
Implement data quality checks, monitoring, and governance controls.
Collaborate with business analysts, architects, and stakeholders to translate business requirements into technical solutions.
Troubleshoot and resolve production issues related to data pipelines and warehouse performance.
Ensure adherence to security, compliance, and data management standards.
Skill Requirements

Snowflake

Strong hands-on experience in Snowflake architecture and administration.

Expertise in:
Virtual Warehouses




Snowflake Storage & Compute Optimization
Complex Query writing and Performance Tuning
Clustering & Partitioning Strategies
Snowpipe
Streams & Tasks
Time Travel & Fail-secure
Data Sharing
Role-Based Access Control (RBAC)
Experience with Snowflake migration projects and performance optimization.

dbt

Extensive hands-on experience in:
dbt Core and/or dbt Cloud
dbt Models
Macros
Seeds
Snapshots
Incremental Models
CI/CD Integration
Data Lineage and Governance

Data Warehousing

Strong understanding of:
Dimensional Modeling
Star and Snowflake Schemas
Data Lake and Data Warehouse Architectures
SCD Type 1 & Type 2 Implementations

ETL / ELT

Extensive experience in designing and implementing ETL/ELT solutions.
Expertise in handling complex data transformations and large-volume data processing.

Databases

Strong knowledge of multiple RDBMS platforms including:
Oracle/SQL Server/PostgreSQL etc..
Other Requirements

Good to Have Skills

Cloud platforms: AWS, Azure, or GCP.
Data integration tools such as Informatica, Matillion, Fivetran, Talend, or Azure Data Factory.
CI/CD tools such as GitHub, GitLab, Azure DevOps, Jenkins.
Exposure to data governance and data quality frameworks.
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

📌 Senior Technical Lead (India)
🏢 HCLTech
📍 India