Data Architect (Snowflake)

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

Job summary

A global professional services firm is seeking a Snowflake Data Architect to lead solution architecture for data-driven projects. The ideal candidate will have at least 8 years of data architecture experience and significant expertise in Snowflake. Responsibilities include designing data management solutions and collaborating with clients to meet their business objectives. This position offers competitive compensation between $110,000 and $160,000, along with a comprehensive benefits package.

Benefits

Comprehensive medical coverage

Defined contribution pension plan

Paid vacation

Qualifications

• 8+ years in data architecture or data engineering roles.
• 3+ years designing and developing on Snowflake.
• Snowflake SnowPro Core Certification required.

Responsibilities

• Lead solution architecture for Snowflake-based projects.
• Define and develop enterprise data strategies and architectures.
• Evaluate and recommend data technologies and platforms.

Skills

Strong SQL skills

Broad knowledge of Snowflake features

Strong communication skills (oral and written)

Education

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

Tools

Snowflake

AWS

Azure

GCP

Job description

Opportunity

We are seeking Snowflake Data Architects for our AI & Data practice team.

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

Key Responsibilities – 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 and extensible end-to-end data management solutions encompassing:
  • Data warehouses and data lakes, to support business analytics, reporting, and machine learning use cases
  • Target state and reference architectures
  • Conceptual, logical, and physical data models and graph data modeling to represent business entities, relationships, and processes
  • Data integration patterns for batch/streaming pipelines
  • Master data management
  • 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, such as cloud data services and data management solutions to meet client needs and requirements
• Provide technical leadership and guidance to project teams, including data architects, data engineers, and developers, to ensure alignment with architectural principles, design patterns, and best practices
• Conduct data architecture reviews, assessments, and audits to assess compliance with architectural standards, identify gaps, and recommend remediation actions
• Develop and deliver client presentations, executive briefings, and thought leadership content on data architecture trends, technologies, and best practices
• Mentor junior team members, provide coaching and support, and contribute to the professional development and growth of data architect capabilities within the practice
• Build valuable relationships both within EY and with clients

Qualifications

• Bachelor’s degree in computer science, mathematics, data science, informatics, engineering, or a 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 demonstrated knowledge of Snowflake features
• Demonstrated experience with cloud platforms (AWS, Azure, GCP)
• Strong background in analytical data modeling including dimensional and Data Vault methodologies
• Proven experience delivering end-to-end enterprise data and solution architectures including data warehouses and data lakes to support analytics and machine learning
• Demonstrated experience architecting scalable data pipelines across batch and streaming patterns
• Demonstrated experience integrating data management capabilities including MDM, metadata, and data quality
• Demonstrated 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 the IT Advisory space. 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 - built on high-performance teaming - where everyone can achieve their potential and contribute to building a better working world for our people, our clients and our communities. It includes comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, paid vacation, and flexibility to handle your role in a way that’s right for you. Competitive compensation is based on performance and the value you bring to our business.

Location and Salary

Toronto - $110,000 to $160,000

Apply Today

Are you ready to shape your future with confidence? Apply today. To help create the best experience during the recruitment process, please describe any accommodations you may need.