Solution Architect

KPI Partners; Pune District, Bengaluru, Hyderabad; On-site; INR 4,500,000 - 7,500,000; Full time

Job summary

KPI Partners in Pune, India, is seeking a Snowflake Solution Architect to design scalable data platforms using Snowflake, DBT and Airflow.

You will translate business requirements into technical specs, build robust data models, and optimize pipelines for performance and cost, while mentoring teammates.

The role emphasizes security, compliance, and collaboration with stakeholders to deliver analytics-driven insights.

Qualifications

• Experience as a Snowflake Solution Architect or similar role.
• Strong DBT, Airflow and data modeling expertise.
• Proficiency in SQL and programming languages like Python or Java.
• Understanding of cloud data warehousing concepts and best practices.
• Excellent problem-solving and collaboration skills.
• Effective communication with both technical and non-technical stakeholders.
• Bachelor's degree in CS/IT or related field; advanced degree preferred.

Responsibilities

• Design and implement scalable Snowflake data solutions.
• Develop ETL/ELT processes using DBT and Airflow.
• Translate business requirements into technical specs.
• Create comprehensive data models for analytics.
• Optimize pipelines and models for performance and cost.
• Mentor junior team members on best practices.
• Troubleshoot data integration and migration issues.
• Ensure data security and regulatory compliance.

Skills

Snowflake

DBT

Airflow

Data modelling

SQL

Python

Java

Cloud data warehousing

Problem solving

Communication

Education

Bachelor's degree in CS/IT or related field

Tools

Snowflake

DBT

Airflow

Job description

Description

KPI Partners is seeking a skilled and experienced Snowflake Solution Architect to join our dynamic team. The ideal candidate will have extensive knowledge in data architecture and a strong background in developing solutions using Snowflake, DBT, Airflow, and data modeling techniques.

Key Responsibilities:

• Design and implement data solutions using Snowflake, ensuring scalability, performance, and reliability.
• Develop and maintain ETL/ELT processes utilizing DBT and Airflow for data transformation and orchestration.
• Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
• Create comprehensive data models to support analytics and reporting needs.
• Optimize existing data pipelines and models for performance improvements and cost-effectiveness.
• Provide technical guidance and mentorship to junior team members in best practices and methodologies.
• Troubleshoot and resolve issues related to data integration and migration processes.
• Ensure data security and compliance with industry standards and regulations.

Qualifications:

• Proven experience as a Snowflake Solution Architect or in a similar role.
• Strong expertise in DBT, Airflow, and data modeling concepts.
• Proficiency in SQL and experience with other programming languages such as Python or Java.
• Deep understanding of cloud data warehousing concepts and best practices.
• Excellent problem-solving skills and the ability to work collaboratively in a team environment.
• Strong communication skills, both written and verbal, to effectively convey technical information to non-technical stakeholders.
• Bachelors degree in Computer Science, Information Technology, or a related field; advanced degree preferred.