Technical Lead / Architect - Snowflake & Cortex AI

Bootminds; Bengaluru; On-site; INR 3,800,000 - 6,800,000; Full time

Job summary

Bootminds seeks a Technical Lead / Architect with deep Snowflake and Cortex AI expertise to guide the data engineering team in Bengaluru. You will design scalable data solutions and enforce best practices in data modelling and Snowflake architecture.

Responsibilities include leading design reviews, optimizing queries, and mentoring engineers while collaborating with stakeholders to translate requirements into robust, enterprise-grade data platforms.

Qualifications

• Strong hands-on expertise in Snowflake and Snowflake Cortex AI is mandatory.
• Experience in data modelling techniques including Star Schema, Snowflake Schema and Data Vault is required.
• Proven ability to guide and mentor technical teams and drive architectural decisions.
• Excellent communication and stakeholder-management skills are essential.

Responsibilities

• Lead and guide the technical team in planning, designing, and delivering Snowflake-based data solutions.
• Own technical decisions related to Snowflake architecture, data modelling, performance, and optimization.
• Provide technical guidance, task allocation, and support to team members.
• Review technical solutions, code, and implementation approaches to ensure quality and scalability.
• Design and implement efficient data models using Star Schema, Snowflake Schema, and Data Vault.
• Perform performance tuning and query optimization in Snowflake.
• Work with Snowflake Cortex AI and understand its capabilities and application within enterprise data and AI solutions.
• Collaborate with business and technical stakeholders to translate requirements into scalable technical solutions.

Skills

Snowflake

Snowflake Cortex AI

Data Modelling

Performance Tuning

Query Optimization

Snowflake Native Apps

Technical Leadership

Communication

Job description

Technical Lead / Architect - Snowflake & Cortex AI

Role Overview: We are looking for a Strong Technical Lead / Architect with extensive expertise in Snowflake and Snowflake Cortex AI. The ideal candidate will provide technical leadership, guide the development team, design scalable data solutions, and drive best practices around data modelling and Snowflake architecture.

Key Responsibilities

• Lead and guide the technical team in planning, designing, and delivering Snowflake-based data solutions.
• Own technical decisions related to Snowflake architecture, data modelling, performance, and optimization.
• Provide technical guidance, task allocation, and support to team members.
• Review technical solutions, code, and implementation approaches to ensure quality and scalability.
• Design and implement efficient data models using: Star Schema, Snowflake Schema, Data Vault.
• Perform performance tuning and query optimization in Snowflake.
• Analyze query performance and identify opportunities to improve warehouse utilization, execution time, and overall solution efficiency.
• Work with Snowflake Cortex AI and understand its capabilities and application within enterprise data and AI solutions.
• Design and work with Snowflake Native Apps and understand their architecture, development, and deployment considerations.
• Evaluate Snowflake native capabilities and recommend appropriate solutions based on business and technical requirements.
• Collaborate with business and technical stakeholders to understand requirements and translate them into scalable technical solutions.
• Conduct technical discussions, solution reviews, and knowledge-sharing sessions with the team.
• Identify technical risks and proactively drive resolution.
• Ensure adherence to engineering best practices, coding standards, and architectural guidelines.

Requirements

• Technical Skills:
  • Snowflake: Strong hands-on expertise – Mandatory
  • Snowflake Cortex AI: Strong knowledge / hands-on exposure – Mandatory
  • Data Modelling: Star Schema, Snowflake Schema, Data Vault
  • Performance Tuning: Strong experience in Snowflake performance optimization
  • Query Optimization: Strong hands-on experience
  • Snowflake Native Apps: Good understanding / hands-on experience
  • Technical Leadership: Ability to guide and mentor technical teams
  • Communication: Excellent communication and stakeholder-management skills
• Leadership & Soft Skills:
  • Strong technical leadership and problem-solving abilities.
  • Ability to handle and guide team tasks effectively.
  • Strong mentoring and knowledge-sharing skills.
  • Excellent verbal and written communication.
  • Ability to communicate complex technical concepts clearly to both technical and non-technical stakeholders.
  • Strong ownership and accountability for technical deliverables.
  • Ability to work collaboratively across multiple teams.

Work Arrangements

• Location: Bengaluru, Karnataka, India
• Work Type: FullTime
• Remote: Not specified