AI and Data - Senior Consultant/Architect (Snowflake)

Ernst & Young Advisory Services Sdn Bhd; Toronto; On-site; CAD 110,000 - 160,000; Full time

Benefits offered by this job

Competitive compensation package with

Job summary

EY in Toronto seeks a Senior Consultant/Architect to lead Snowflake-based data architectures and end-to-end data solutions. You will translate business needs into secure, scalable Snowflake architectures, supervise data modeling, security, and governance, and mentor junior staff while guiding client engagements.

Ideal candidates have extensive Snowflake experience, cloud platform proficiency (AWS/Azure/GCP), and strong communication skills to partner with stakeholders across engagements.

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.
• Broad and deep knowledge of Snowflake features.
• Experience with cloud platforms (AWS, Azure, GCP).
• Strong background in analytical data modeling (dimensional, Data Vault).
• End-to-end enterprise data and solution architectures including warehouses and lakes.
• Experience in scalable data pipelines (batch/streaming) and data governance.

Responsibilities

• Lead solution architecture for Snowflake-based projects.
• Design logical and physical data models to support analytics, AML, reporting, and AI use cases.
• Define security architecture (RBAC, masking, row access).
• Develop cost monitoring, telemetry, and governance.
• Produce architecture artifacts and lead technical reviews.
• Mentor junior team members and build client relationships.

Skills

Snowflake

Data architecture

Cloud platforms

Leadership

Stakeholder communication

Education

Bachelor's degree in CS / math / data science / informatics / eng

Tools

Snowflake

AWS / Azure / GCP

Data governance tooling

Job description

AI and Data - Senior Consultant/Architect (Snowflake)

Location: Toronto

Other locations: Primary Location Only

Date: Aug 9, 2026

Requisition ID: 1603494

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

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 Senior Consultants/ Data Architects for o ur 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.

This job posting relates to an existing vacancy within our organization.

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
• Design data storage layers (e.g., raw, curated, consumption)
• Define security architecture (e.g., roles, RBAC, masking, row access policies)
• 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 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

To qualify for the role, you must have

• 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
• 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's one of the many reasons we repeatedly win awards for being a great place to work.

We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our Total Rewards package allows you decide which benefits are right for you and which ones help you create a solid foundation for your future. Our Total Rewards package includes a comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, a great vacation policy plus firm paid days that allow you enjoy longer long weekends throughout the year, statutory holidays and paid personal days (based on province of residence), and a range of exciting programs and benefits designed to support your physical, financial and social well-being. Plus, we offer:

• Support and coaching from some of the most engaging colleagues in the industry
• Learning opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you\

EY reports salary ranges in accordance with applicable provincial pay transparency legislation. Individual salaries within the anticipated salary ranges noted below are determined through a wide variety of factors including but not limited to internal equity, education, relevant experience, knowledge, and applicable skill sets.

• Toronto: $110,000to $160,000
• London/Ottawa/Waterloo: $104,500 to 154,500
• Victoria: $99,500 to 149,000

To help create the best experience during the recruitment process, please describeanyaccommodations you may need.

Inclusiveness at EY

Inclusivenessisat the heart of who we are and how we work.We’recommitted to fostering an environment where differences are valued, policies and practices areequitable, and our people feel a sense of belonging. We embrace diversity and are committed to combating systemic racism, advancing gender equity and women in leadership, advocating for the 2SLGBTQIA+ community, promoting ourneuroinclusionand accessibility initiatives, and are dedicated to amplifying the voices of Indigenous peoples (First Nations, Inuit, and Métis) nationally as we strive towards reconciliation. Our diverse experiences, abilities, backgrounds, and perspectives make our people unique and help guide us. Because when people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world.

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

At EY, we use artificial intelligence (AI) tools as one element of our recruitment process to enhance efficiency and improve the candidate experience. While AI supports us in our process, human judgment and decision-making remain integral in our candidate experience. We are committed to the responsible use of AI, and our practices are continuously reviewed and refined to ensure they align with ethical principles and regulatory requirements.