Snowflake Architect
The role involves designing and implementing Snowflake architecture and performance tuning within the insurance domain. It also focuses on building and deploying AI/ML and GenAI solutions integrated with cloud platforms.
- Hybrid
- Markham, ON
- Posted Aug 6, 2026
- Apply by Sep 5, 2026
- 1 position
Job summary
Position Name – Snowflake Architect Type of hiring – Fulltime Location – Markham, ON (Mandatorily need to visit office 3 days – Mon/Tue/Wed) NOTE: First round will be Virtual and 2nd customer round will be in-person please inform candidates. Candidate needs to be onsite Mon/Tue/Wed (this is mandatory) Job Description: 12+ Years in data engineering, cloud analytics, or architecture roles. 5+ Years of deep hands-on experience with Snowflake architecture and performance tuning. Strong experience in the insurance domain (Life, P&C, Health, or Commercial lines). Experience building and deploying AI/ML or GenAI solutions (RAG, LLM apps, embeddings, vector databases). Strong SQL, Python, Snowpark, and cloud platform expertise (AWS preferred). Experience integrating Snowflake with AI/ML services (Bedrock, SageMaker, Azure AI, Cortex). Strong understanding of governance, data privacy, and insurance compliance. Excellent communication, solutioning, and leadership skills. Should be SnowPro Certified and should have one professional level certification from AWS/Azure/GCP.
What you’ll do
The role involves designing and implementing Snowflake architecture and performance tuning within the insurance domain. It also focuses on building and deploying AI/ML and GenAI solutions integrated with cloud platforms.
Requirements
Requires over 12 years of experience in data engineering and 5+ years of deep Snowflake expertise. Candidates must be SnowPro certified and hold a professional level certification from AWS, Azure, or GCP.
Listed skills
- SQLPreferred
- Amazon Web ServicesPreferred
- PythonPreferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Snowflake Architecture
- Performance Tuning
- Insurance Domain
- AI/ML
- GenAI
- RAG
- LLM
- Vector Databases
- SQL
- Python
- Snowpark
- AWS
- Bedrock
- SageMaker
- Azure AI
- Cortex
Job areas
- Data & Analytics
- Technology
- Software
- Consulting
- Engineering
Additional details
- Minimum education
- Professional degree
- Minimum experience
- 10+ years
- Apply by
- Sep 5, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Office presence
- 3 days per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available