Lead Consultant(Development)

Technology, Data & Digital · Data, AI & Analytics · Data Engineering

In short

We are looking for an experienced Snowflake & dbt Developer / Data Engineer to design, develop, and maintain scalable cloud data solutions. The role involves building and optimizing ELT/ETL pipelines, developing dbt models, and working with SQL and data warehousing concepts.

Responsibilities

Design, develop, and maintain data solutions using Snowflake and dbt.
Build and optimize ELT/ETL pipelines for data ingestion and transformation.
Develop reusable and modular dbt models, tests, macros, and documentation.
Design and implement dimensional and analytical data models.
Write and optimize complex SQL queries for performance and scalability.
Implement data quality checks, testing, monitoring, and troubleshooting.
Work with structured and semi-structured data within Snowflake.
Perform Snowflake performance tuning and query optimization.
Collaborate with business analysts, architects, BI teams, and upstream/downstream application teams.
Support deployment and version control processes using Git and CI/CD practices.
Troubleshoot data pipeline, transformation, and production issues.
Follow data engineering standards, security practices, and development best practices.

Requirements

Strong hands-on experience with Snowflake.
Strong working experience with dbt (Data Build Tool).
Advanced knowledge of SQL.
Good understanding of data warehousing, dimensional modeling, and ELT/ETL concepts.
Experience developing scalable data transformation pipelines.
Experience with Git/version control and CI/CD.
Knowledge of Snowflake concepts such as warehouses, databases, schemas, stages, and performance optimization.
Strong debugging, analytical, and problem-solving skills.
5+ years of overall Data Engineering / Data Warehousing experience.
2+ years of hands-on Snowflake and dbt experience preferred.

Desired Qualifications

Experience with Python for data engineering or automation.
Exposure to cloud platforms such as Azure, AWS, or GCP.
Experience with orchestration/integration tools such as Airflow, Azure Data Factory, or similar technologies.
Understanding of data governance, security, and data quality practices.
dbt certification or Snowflake certification is an added advantage.

Skills

SnowflakedbtSQLdata modelingETLELTGitCI/CDPythonAzureAWSGCPAirflowAzure Data Factory

#Data Engineer#Snowflake#dbt#SQL#data modeling#ETL#ELT#Git#CI/CD#Python#Azure#AWS#GCP#Airflow#Azure Data Factory

About HCLTech

Supercharging progress through technology and innovation

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2022 totaled $12.1 billion. To learn how we can supercharge progress for…

See all open jobs at HCLTech Read more about HCLTech Website