Firstwave Technologies - Lead Data Engineer - Snowflake DB

Experience : 7 years to 12 years

Mandate Skills : Snowflake, Data Ingestion, SnowSight, SnowSQL, ADF,SQL, any ETL tool - SSIS, Talend, Informatica, Data Bricks, ADF (preferred), etc, Team Handling exp & communication is a must.

Location : Hyderabad / Chennai

Mode : Hybrid

Notice Period : Immediate Joiner to 15 Days

Job Summary :

We are seeking an experienced Lead Snowflake Data Engineer to join our Data & Analytics team. This role involves designing, implementing, and optimizing Snowflake-based data solutions while providing strategic direction and leadership to a team of junior and mid-level data engineers. The ideal candidate will have deep expertise in Snowflake, cloud data platforms, ETL / ELT processes, and Medallion data architecture best practices. The lead data engineer role has a strong focus on performance optimization, security, scalability, and Snowflake credit control and management. This is a tactical role requiring independent in-depth data analysis and data discovery to understand our existing source systems, fact and dimension data models, and implement an enterprise data warehouse solution in Snowflake.

Essential Functions and Tasks :

• Lead the design, development, and maintenance of a scalable Snowflake data solution serving our enterprise data & analytics team.
• Architect and implement data pipelines, ETL / ELT workflows, and data warehouse solutions using Snowflake and related technologies.
• Optimize Snowflake database performance, storage, and security.
• Provide guidance on Snowflake best practices
• Collaborate with cross-functional teams of data analysts, business analysts, data scientists, and software engineers, to define and implement data solutions.
• Ensure data quality, integrity, and governance across the organization.
• Provide technical leadership and mentorship to junior and mid-level data engineers.
• Troubleshoot and resolve data-related issues, ensuring high availability and performance of the data platform.

Education and Experience Requirements :

Knowledge, Skills, and Abilities :

(ref : hirist.tech)