Azure Data Architect - Snowflake

Appex Innovation; Boston (MA); On-site; USD 140,000 - 190,000; Full time

Job summary

Appex Innovations in Boston, MA is seeking a Snowflake Architect to join our onsite data team. The role focuses on shaping the Azure Snowflake roadmap, migration, and agent-based data engineering solutions.

The candidate will design scalable data architectures, implement SnowSQL and Spark ETL, and collaborate across disciplines to deliver high-quality cloud data solutions. Onsite requirement emphasizes teamwork and hands-on leadership.

Qualifications

• Proven Snowflake Architect with SnowSQL and Spark experience.
• Strong Snowflake architecture knowledge and best practices.
• SQL proficiency and data modeling skills required.
• Cloud platform experience, AWS or Azure.
• Excellent problem-solving and collaboration abilities.

Responsibilities

• Design and implement data architecture using Snowflake for performance and scalability.
• Develop ETL processes with SnowSQL and Spark for data ingestion and transformation.
• Collaborate with data engineers, analysts, and stakeholders to translate requirements into specs.
• Optimize data pipelines for efficiency and reliability.
• Perform performance tuning and troubleshoot Snowflake environments.
• Stay updated on Snowflake features and best practices; document designs and processes.
• Mentor junior team members and participate in code reviews.

Skills

Snowflake Architecture

SnowSQL

Spark

SQL

Azure Cloud

Data Modeling

AWS/Azure

Problem Solving

Communication

Education

Bachelor's degree in CS/IT

Tools

Tableau

Power BI

Job description

Boston, United States | Posted on 08/05/2026

At Appex Innovations, we believe in the power of technology to transform healthcare, we believe in being nimble and in continual innovation, we believe that every customer is unique and we believe in listening to our clients. With our deep expertise in the health care domain, solid resource base, constant industry interface and the drive to be the best in the industry, we strive to provide services that re-define health care in the years to come. The secret to our success is Appex Innovations commitment to our people and our work. We thrive on teamwork, intelligence, and innovation. Our bright and energetic employees, hailing from over different parts of the world, share a passion for leading the way to improved healthcare outcomes. Together we work diligently to add value to our clients.

Job Description

We are hiring a Snowflake Architect with our Client in Boston, MA (Onsite)

Job Title:

Snowflake Architect

Note: Need a snowflake data architect with Azure Cloud Experience and Agentic AI,

Senior Data Architect who can shape the Azure snowflake roadmap, Migration, Agents for Data Eng SDLC.

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