Mindruby Technologies - Lead Data Engineer - Snowflake DB

Role Overview :

We are looking for a Lead Data Engineer - Snowflake who will own end-to-end data engineering delivery, lead a team, and drive scalable data solutions on Snowflake. The role requires strong technical expertise along with client-facing and delivery management capabilities.

Key Responsibilities :

- Technical & Architecture

- Design and implement scalable data warehouse solutions using Snowflake.

- Develop and optimize ETL/ELT pipelines.

- Perform data modeling (dimensional modeling, star/snowflake schemas).

- Ensure performance tuning, cost optimization, and workload management in Snowflake.

- Implement data security, RBAC, governance, and compliance standards.

- Hands-on experience with Snowflake Streams & Tasks for data processing and orchestration.

- Experience implementing and managing Snowpipe for automated data ingestion.

- Troubleshoot pipeline failures, warehouse contention, query spills, and task failures.

Team Leadership :

- Lead and mentor the data engineering team, drive technical standards, conduct code reviews, and ensure continuous improvement.

Delivery Management

- Own end-to-end project planning and execution, ensuring timely delivery and high stakeholder satisfaction while collaborating with cross-functional teams.

Client & Presales Engagement

- Participate in presales and solutioning discussions.

- Understand client requirements and propose scalable architectures.

- Provide technical presentations and effort estimations.

Required Skills & Experience :

- 6-8 years of experience in Data Engineering (5-6 years may be considered with strong exposure).

- 3+ years of hands-on Snowflake experience.

- Strong SQL and performance optimization skills.

- Experience with ETL tools (DBT, Airflow, Informatica, Talend, etc.).

- Experience working on cloud platforms (AWS / Azure / GCP).

- Strong communication and client interaction skills.

- Proven experience in team handling and project delivery.

Good to Have :

- Snowflake certification

- Experience with Snowflake Dynamic Tables.

- Exposure to CI/CD implementation for Snowflake objects (Git-based deployments).

- Experience in defining migration validation strategies for data warehouse projects.

- Ability to perform credit workload sizing and cost estimation for Snowflake environments.