AI and Data - Senior Consultant/Architect (Snowflake)

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

 

 

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
• 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'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 to 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,000 to $160,000
• London/Ottawa/Waterloo: $104,500 to 154,500
• Vancouver: $110,000 to $160,000
• Victoria: $99,500 to 149,000

 

 

 

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.

 

To all recruitment agencies: EY does not accept unsolicited resumes from recruitment agencies. Any resumes submitted without a prior agreement or request from our hiring team will not be considered. EY is not responsible for any fees related to unsolicited resumes.