Job Title: Snowflake Architect Location: Des Moines Iowa / Boston, MA / Arlington VA onsite Job Summary: We are seeking a highly skilled Snowflake Architect with extensive experience in SnowSQL, Spark, and Snowflake to join our software development team.
The ideal candidate will have a strong background in data architecture and cloud based data solutions, with a proven track record of designing and implementing scalable data systems.
This role requires a deep understanding of Snowflake's capabilities and best practices, as well as the ability to collaborate with cross functional teams to deliver high quality data solutions.
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.
Mandatory Skills:- 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.
Qualifications:- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 10-15 years of experience in software development, with a focus on data architecture and cloud solutions.
- Relevant certifications in Snowflake or cloud technologies are a plus.