AI and Data - Data 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 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 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 to 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

Toronto – $110,000 to $160,000

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.

Inclusiveness at EY

Inclusiveness is at the heart of who we are and how we work. We’re committed to fostering an environment where differences are valued, policies and practices are equitable, 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 our neuroinclusion and 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.

Learn about our commitment to Inclusiveness at https://www.ey.com/en_ca/about-us/corporate-responsibility/equity

EY | Building 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 the highest 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.

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.