AI and Data - Data Architect (Snowflake)

EY; Edmonton; On-site; CAD 110,000 - 160,000; Full time

Benefits offered by this job

Comprehensive medical, prescription drug and dental coverage

Defined contribution pension plan

Great vacation policy

Learning opportunities to develop new skills

Job summary

A leading global professional services firm is looking for a Snowflake Data Architect to join their AI & Data practice. The role involves leading solution architecture for Snowflake projects, developing enterprise data strategies, and mentoring junior team members. The ideal candidate should have over 8 years of experience in data architecture, strong SQL skills, and demonstrated knowledge of cloud platforms. Competitive compensation is offered alongside a comprehensive benefits package, promoting both professional growth and well-being.

Qualifications

• 8+ years in data architecture or data engineering roles.
• 3+ years designing and developing on Snowflake.
• Strong communication (oral and written).

Responsibilities

• Lead solution architecture for Snowflake-based projects.
• Define and develop enterprise data strategies aligning with clients' business objectives.
• Conduct data architecture reviews and assessments.

Skills

Snowflake

SQL

Data Governance

Cloud Platforms

Analytical Data Modeling

Education

Bachelor’s degree in computer science, mathematics, data science, informatics, engineering, or related field

Tools

AWS

Azure

GCP

Job description

Overview

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

The Opportunity

We are seeking Snowflake Data Architects for our AI & Data practice team. We are looking for a candidate with strong technical leadership and experience to translate and deliver business needs into secure scalable solutions and architectures for the Snowflake data platform.

Your Key Responsibilities

Snowflake

• Lead solution architecture for Snowflake-based projects
• Design or review logical and physical data models to support analytics, AML, reporting, and AI use cases
• Define ingestion patterns (e.g., batch, streaming, file-based)
• Design data storage layers (e.g., raw, curated, consumption)
• Define security architecture (e.g., roles, RBAC, masking, row access policies)
• Design data sharing (e.g., secure views, shares, inter-account patterns)
• Establish data quality controls (e.g., validation rules, control totals, reconciliation)
• Develop cost monitoring/telemetry/governance (e.g., warehouse sizing, auto suspend, usage monitoring)
• Produce architecture artifacts (e.g., diagrams, standards)
• Lead technical reviews
• Enforce standards (e.g., reference architecture) across teams

Core

• Lead and facilitate data architecture assessments, workshops, and strategy sessions with clients to understand business goals, challenges, and opportunities
• Define and develop enterprise data strategies, roadmaps, and architectures aligned with clients\' business objectives, regulatory requirements, and industry best practices
• Design and architect scalable end-to-end data management solutions encompassing data warehouses and data lakes, target state and reference architectures, data models, data integration patterns for batch/streaming pipelines, master data management and data governance
• Develop and maintain data standards, guidelines, and best practices for data management and governance
• Collaborate with business stakeholders, data scientists, and data engineers to define data requirements, source data integration strategies, and data quality standards
• Evaluate and recommend data technologies, platforms, and tools to meet client needs
• Provide technical leadership and guidance to project teams to ensure alignment with architectural principles and best practices
• Conduct data architecture reviews, assessments, and audits to assess compliance with standards and identify gaps
• Develop and deliver client presentations, executive briefings, and thought leadership on data architecture
• Mentor junior team members and contribute to professional development of data architect capabilities
• Build relationships within EY and with clients

Qualifications

• Bachelor’s degree in computer science, mathematics, data science, informatics, engineering, or related field
• 8+ years in data architecture or data engineering roles
• 3+ years designing and developing on Snowflake
• Snowflake SnowPro Core Certification
• Strong SQL skills
• Broad and deep knowledge of Snowflake features
• Demonstrated experience with cloud platforms (AWS, Azure, GCP)
• Strong background in analytical data modeling including dimensional and Data Vault methodologies
• Experience delivering end-to-end enterprise data and solution architectures including data warehouses and data lakes
• Experience architecting scalable data pipelines across batch and streaming patterns
• Experience integrating data management capabilities including MDM, metadata, and data quality
• Experience embedding security, privacy, and governance controls into data platforms
• Strong communication (oral and written)

Ideal Certifications

• Snowflake SnowPro Advanced Architect
• AWS Certified Solutions Architect (Associate or Professional)
• Azure Solutions Architect Expert

What We Look For

We’re interested in passionate leaders with a strong vision and a desire to stay on top of trends in IT Advisory. If you have a strong passion for helping businesses achieve their IT strategy, this role is for you.

What We Offer

At EY, our Total Rewards package supports our commitment to creating a leading people culture that fosters high-performance teamwork. We offer a competitive compensation package tied to performance, comprehensive medical/dental coverage, a defined contribution pension plan, vacation and paid days, holidays, and a range of programs to support well-being. We also provide:

• Support and coaching from engaging colleagues
• Learning opportunities to develop new skills
• Flexibility to handle your role in a way that suits you

Toronto - $110000 to $160000

Are you ready to shape your future with confidence? Apply today.

Inclusiveness

Inclusiveness is at the heart of EY. We are committed to fostering an environment where differences are valued, policies are equitable, and our people feel a sense of belonging. We embrace diversity and are committed to promoting gender equity, 2SLGBTQIA+ inclusion, neuroinclusion and accessibility, and the voices of Indigenous peoples. Learn about our commitment to inclusiveness at ey.com.