Snowflake Technical Lead (IN)

HCLTech

Fresher India Full Time Work from office
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a Snowflake Technical Lead with extensive experience in cloud data warehousing and modern ELT development using dbt. This role demands a strong command of advanced SQL, dimensional modeling techniques, and strategies for incremental data processing and snapshots. You will be responsible for optimizing Snowflake performance and managing costs effectively.

Proven ability to design robust, production-grade ELT pipelines is essential. The role also includes implementing CI/CD for dbt, integrating orchestration tools, and establishing data quality through automated testing and observability. A solid understanding of cloud platforms, Snowflake security, version control with Git, and DevOps practices is required. This position involves leading technical design reviews and mentoring data engineering teams, including offshore members, to ensure successful project delivery.

Responsibilities

Key responsibilities include developing and maintaining dbt models within the Snowflake environment, building reliable and well-documented data transformation pipelines, and implementing rigorous data quality checks, lineage, and governance standards.

Optimize SQL queries and dbt models for enhanced performance and cost-efficiency. Collaborate closely with data engineering, BI, analytics, and business teams. Support Git-based development, CI/CD processes, and deployment workflows. Lead technical projects from initiation to completion, offering expert guidance to team members and translating stakeholder requirements into effective technical solutions.

Qualifications

Candidates must possess strong SQL and data modeling skills, with hands-on experience in dbt Core or dbt Cloud and Snowflake. Proficiency in ELT pipeline development, testing methodologies, documentation, and version control is crucial.

Demonstrate a solid understanding of analytics engineering and dimensional modeling principles. Advanced knowledge of Python for data manipulation and ETL processes is also required. The ideal candidate will be adept at working in a fast-paced setting, managing multiple priorities, and exhibiting excellent problem-solving abilities and meticulous attention to detail. Strong communication and leadership skills are necessary for guiding and mentoring team members effectively.

Essential Skills

SQLData ModelingSnowflakedbtPythonELTCI/CDVersion ControlGitDevOpsData Quality

Good to Have

Dimensional Modeling (Kimball/Data Vault)Incremental StrategiesSnapshot StrategiesPerformance TuningCost OptimizationOrchestration ToolsObservability FrameworksCloud PlatformsSecurity in SnowflakeTroubleshootingLeadership

Highlights

  • Actively hiring

More Details

RoleSnowflake Technical Lead (IN)
Employment TypeFull Time, Work from office

About the Company

HCLTech logo

HCLTech

IT Consulting