AI and Data - Senior Consultant/Architect (Snowflake)

EY; Winnipeg; On-site; CAD 110,000 - 150,000; Full time

Job summary

EY is seeking a Snowflake Senior Consultant / Data Architect to lead architecture for Snowflake-based projects and to design scalable data solutions. You will define data models, ingestion patterns, and data sharing while enforcing governance and cost monitoring across client engagements.

You will collaborate with clients and EY teams to translate business goals into secure, scalable end-to-end data architectures and drive best practices in data management and analytics.

Qualifications

• 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 (roles, RBAC, masking, row access policies).
• Design data sharing (secure views, shares, inter-account patterns).
• Establish data quality controls (validation rules, control totals, reconciliation).
• Develop cost monitoring/telemetry/governance (warehouse sizing, auto suspend, usage monitoring).
• Produce architecture artifacts (diagrams, standards).
• Lead technical reviews
• Enforce standards across teams

Responsibilities

• Lead solution architecture for Snowflake-based projects.
• Define ingestion patterns (batch, streaming, file-based).
• Design data storage layers (raw, curated, consumption).
• Establish data quality controls and governance metrics.
• Develop cost monitoring and telemetry for data platforms.
• Mentor junior team members and lead technical reviews.
• Collaborate with clients to translate business needs into secure scalable architectures.

Skills

Snowflake

Data architecture

Data modeling

Data governance

Leadership

Tools

SQL

Data Warehousing

Cloud Platforms

Job description

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

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