Snowflake Solution Architect

KPI Partners; Bengaluru; On-site; INR 6,000,000 - 9,000,000; Full time

Job summary

KPI Partners in Bengaluru, India, seeks a Snowflake Solution Architect with 10+ years of data architecture experience to design scalable data solutions using Snowflake, DBT, Airflow and modern data modeling techniques.

You will lead the implementation of ETL/ELT pipelines, mentor junior engineers, work with business stakeholders to translate requirements into technical specs, and ensure security and regulatory compliance across data workstreams.

Qualifications

• Proven experience as a Snowflake architect or related role.
• Strong DBT, Airflow, and data modeling expertise.
• Proficient SQL and programming languages such as Python or Java.
• Deep understanding of cloud data warehouse concepts and best practices.
• Excellent problem-solving and collaboration skills.
• Bachelor’s degree in Computer Science or related field; advanced degree preferred.

Responsibilities

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

Skills

Snowflake

SQL

DBT

Python

Airflow

Data modeling

Education

Bachelor's degree in Computer Science / Information Technology or related field

Job 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.

Job Title: Snowflake Solution Architect

Experience: 10+ years

Employment Type: Full-time

Mandatory Skills: Snowflake, SQL, DBT, Python, Airflow

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.
• Bachelor’s degree in Computer Science, Information Technology, or a related field; advanced degree preferred.