Snowflake Architect/ Lead

Mindsprint; Chennai District; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

A leading data solutions provider is seeking a Senior Lead Data Engineer / Architect in Chennai. The ideal candidate will have substantial experience with Snowflake data warehousing and Power BI, responsible for designing and implementing innovative data solutions. This role involves mentoring junior developers and ensuring data governance and security. The position is full-time and requires strong analytical and troubleshooting skills.

Qualifications

• 8-12+ years of experience in enterprise data warehousing and analytics.
• 4+ years of experience with Snowflake implementations.
• Expert-level SQL and DBT skills required.
• Strong analytical and troubleshooting abilities.

Responsibilities

• Lead the design and implementation of data solutions on Snowflake.
• Optimize Snowflake databases for performance and cost efficiency.
• Mentor junior developers on Snowflake best practices.
• Drive integration between Power BI and Snowflake.

Skills

Snowflake data warehousing

Power BI

SQL

ETL/ELT frameworks

Data governance

Security implementation

Education

Bachelor’s or master’s degree in computer science

Tools

Airflow

dbt

Python

Job description

Talent Acquisition Specialist @ Mindsprint | Strategic Hiring, Executive Search

Job Summary:

We are looking for a highly experienced Senior Lead Data Engineer / Architect specializing in Snowflake data warehousing, with strong skills in Power BI. The ideal candidate will have 8–10 years of experience in data engineering and analytics, with proven leadership in designing, implementing, and optimizing large-scale Snowflake architectures and developing high-impact business intelligence solutions using Power BI.

Key Responsibilities:

• Lead the end-to-end architecture, design, and implementation of enterprise-grade data solutions on Snowflake.
• Build and maintain complex data pipelines and advanced ETL/ELT frameworks, leveraging Snowflake’s native features for scalability and performance.
• Optimize Snowflake databases, warehouses, secure data sharing, and storage structures for cost and performance efficiency.
• Collaborate with data architects and engineers to establish best practices for data governance, data security (RBAC, masking), and lifecycle management in Snowflake.
• Leverage advanced Snowflake capabilities: Streams, Tasks, Time Travel, Zero Copy Cloning, Data Sharing, and Materialized Views.
• Write highly optimized SQL queries, UDFs (user-defined functions), and scripts for large-scale analytics workloads.
• Mentor junior developers in Snowflake best practices, performance tuning, and troubleshooting.
• Drive integration between Power BI and Snowflake using native connectors and optimal data modeling.
• Support data security implementation, including Row-Level Security (RLS) and Column-Level Security (CLS) in both Snowflake and Power BI.

Qualifications:

• Bachelor’s or master’s degree in computer science, Information Systems, or related field.
• 8–12+ years of hands‑on experience with enterprise data warehousing and analytics.
• Minimum 4 years of proven experience implementing, optimizing, and maintaining Snowflake environments.
• Deep expertise in Snowflake architecture, performance tuning, data modeling, security, and advanced features.
• Expert‑level SQL, DBT skills, with ability to author and optimize complex transformations and queries in Snowflake.
• Experience with Power BI for large‑scale reporting, including DAX scripting and Power Query.
• Familiarity with data pipeline orchestration tools (e.g., Airflow, dbt) and scripting languages (Python preferred) is highly desirable.
• Effective communication skills and the ability to lead technical discussions with stakeholders and mentor team members.
• Strong analytical and troubleshooting abilities, with a track record of delivering data solutions in complex, large‑scale environments.

Seniority Level

• Mid‑Senior level

Employment Type

• Full‑time

Job Function

• Design, Information Technology, and Project Management
• IT Services and IT Consulting, IT System Design Services, and Data Infrastructure and Analytics