Snowflake Architect

Unicorn Technologies LLC; Boston (MA); On-site; USD 140,000 - 190,000; Full time

Job summary

Unicorn Technologies LLC in Boston, MA seeks a highly skilled Snowflake Architect with extensive Snow SQL and Spark experience to design scalable data solutions. The role requires deep Snowflake knowledge and collaboration across cross-functional teams.

The candidate will design and implement data architecture, develop ETL with Snow SQL and Spark, and optimize pipelines while staying abreast of Snowflake best practices. Strong communication and mentoring skills are essential.

Qualifications

• Bachelor's degree in computer science, Information Technology, or a related field.
• 10-15 years of software development experience with data architecture focus.
• Proven Snowflake Architect experience with Snow SQL and Spark.
• Experience with cloud platforms (AWS or Azure).

Responsibilities

• Design and implement data architecture solutions using Snowflake, ensuring optimal performance and scalability.
• Develop and maintain ETL processes using Snow SQL and Spark to facilitate data ingestion and transformation.
• Collaborate with data engineers, analysts, and 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 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

Snow SQL

Spark

SQL

Data modeling

Cloud platforms (AWS/Azure)

Communication

Education

Bachelor's degree in computer science or related field

Tools

Tableau

Power BI

Job description

Job Summary
We are seeking a highly skilled Snowflake Architect with extensive experience in Snow SQL, 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.

Job Title: Snowflake Architect
Location: Boston, MA
Client: Tech Mahindra
Years of Experience: 10 - 15 Years
Client: Tech M / State Street.
Job Summary
We are seeking a highly skilled Snowflake Architect with extensive experience in Snow SQL, 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 Snow SQL 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 Snow SQL.
• 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.