Technical Lead / Architect - Snowflake & Cortex AI

Confidential Client; Bengaluru; On-site; INR 3,000,000 - 5,500,000; Full time

Job summary

Confidential Client seeks a Technical Lead / Architect with deep Snowflake and Cortex AI expertise to guide design and build of scalable data solutions. You will own architecture, data modelling, performance tuning, and validation of technical approaches while mentoring the team and ensuring best practices across projects.

You will collaborate with stakeholders to translate complex requirements into efficient Snowflake-based architectures, including Snowflake Native Apps, and drive knowledge

Qualifications

• Snowflake expertise and Cortex AI implementation experience.
• Strong data modelling skills (Star Schema, Snowflake Schema, Data Vault).
• Proven performance tuning and query optimization experience.
• Experience with Snowflake Native Apps and ecosystem tooling.
• Demonstrated technical leadership and ability to mentor teams.
• Excellent written and verbal communication with stakeholders.

Responsibilities

• Lead the Snowflake-based data solution design and delivery.
• Own Snowflake architecture decisions, data modelling, performance optimization.
• Provide technical guidance, assign tasks, and support team members.
• Review solutions, code, and approaches for quality and scalability.
• Design data models using Star Schema, Snowflake Schema, Data Vault.
• Tune queries and improve warehouse utilization and speed.
• Work with Snowflake Cortex AI and Snowflake Native Apps capabilities.
• Collaborate with stakeholders to translate requirements into scalable solutions.
• Conduct technical discussions and knowledge-sharing sessions.
• Identify risks and drive proactive resolutions.
• Ensure engineering best practices and architectural standards are followed.

Skills

Snowflake

Snowflake Cortex AI

Data modelling

Performance tuning

Query optimization

Snowflake Native Apps

Tech 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