(\"snowflake architect\")

Kastech Software Solutions Group; Des Moines (IA); On-site; USD 120,000 - 170,000; Full time

Job summary

Kastech Software Solutions Group seeks a seasoned Snowflake Architect to design and optimize data platforms on Azure. You will own the Snowflake roadmap, drive migrations, and guide data engineering across the SDLC.

In this role you will build scalable ETL pipelines with SnowSQL and Spark, collaborate with analysts and engineers, review code, mentor juniors, and promote best practices for performance, security, and governance.

Qualifications

• Snowflake Architect with Azure Cloud Experience and Agentic AI.
• Senior Data Architect capable of shaping the Azure Snowflake roadmap, migration, Agents for Data Eng SDLC.
• Proven experience as a Snowflake Architect with strong SnowSQL.
• Expertise in Spark for data processing and transformation.
• In depth knowledge of Snowflake architecture, features, and best practices.
• Strong programming skills in SQL and data modeling.
• Experience with cloud platforms, AWS or Azure.
• Excellent problem solving skills and attention to detail.
• Strong communication and collaboration skills.

Responsibilities

• Design and implement data architecture solutions using Snowflake, ensuring optimal performance and scalability.
• Develop and maintain ETL processes using SnowSQL and Spark to facilitate data ingestion and transformation.
• Collaborate with data engineers, analysts, and other stakeholders to gather requirements and translate them into technical specifications.
• Optimize existing data pipelines and workflows for efficiency and reliability.
• Conduct performance tuning and troubleshooting of Snowflake environments.
• Stay updated with the latest Snowflake features and best practices, and provide recommendations for improvements.
• Document architecture designs, processes, and procedures for future reference and training.
• Participate in code reviews and provide mentorship to junior team members.

Skills

Snowflake Architect

Azure Cloud Experience

Agentic AI

Senior Data Architect

SnowSQL

Spark

SQL

Data Modeling

AWS

Tools

Tableau

Power BI

Job description

• Design and implement data architecture solutions using Snowflake, ensuring optimal performance and scalability.
• Develop and maintain ETL processes using SnowSQL and Spark to facilitate data ingestion and transformation.
• Collaborate with data engineers, analysts, and other stakeholders to gather requirements and translate them into technical specifications.
• Optimize existing data pipelines and workflows for efficiency and reliability.
• Conduct performance tuning and troubleshooting of Snowflake environments.
• Stay updated with the latest Snowflake features and best practices, and provide recommendations for improvements.
• Document architecture designs, processes, and procedures for future reference and training.
• Participate in code reviews and provide mentorship to junior team members.

Mandatory Skills:

• Snowflake Architect with Azure Cloud Experience and Agentic AI
• Skills – Senior Data Architect who can shape the Azure Snowflake roadmap, migration, Agents for Data Eng SDLC.
• Proven experience as a Snowflake Architect with a strong focus on SnowSQL.
• Expertise in Spark for data processing and transformation.
• In depth knowledge of Snowflake architecture, features, and best practices.
• Strong programming skills in SQL and experience with data modeling.
• Experience with cloud platforms, particularly AWS or Azure.
• Excellent problem solving skills and attention to detail.
• Strong communication and collaboration skills.

Preferred Skills:

• Experience with data visualization tools such as Tableau or Power BI.
• Familiarity with data governance and security best practices.
• Knowledge of machine learning concepts and tools.
• Experience with Agile methodologies and project management tools.