AI and Data - Manager or Senior Manager - Data Architect (SAS)

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

Job summary

A global advisory firm in Toronto is seeking an experienced Data Architect to lead the design and implementation of data solutions. The ideal candidate will have over 10 years of experience in data management and architecture, possess strong expertise in data tools and methodologies, and demonstrate a proven ability to work collaboratively with business stakeholders. This role offers a competitive salary and a commitment to diversity and inclusion.

Benefits

Support and coaching from industry colleagues

Learning opportunities

Flexible work arrangements

Qualifications

• 10+ years of experience in data architecture design and implementation.
• Expert knowledge of data management concepts including ETL/ELT.
• Strong analytical and decision-making skills.

Responsibilities

• Design end-to-end data solutions aligned with business needs.
• Provide technical oversight for data infrastructure.
• Lead discussions to gather business requirements.

Skills

Data architecture

Data integration

Data modeling

SQL

ETL tools

Data governance

Data visualization

Cloud services

Education

Bachelor’s degree in Information Technology or related field

Tools

SAS

Informatica

Power BI

Tableau

Azure Data Factory

Databricks

Snowflake

Job description

Overview

Location: Toronto

Other locations: Primary Location Only

Date: Sep 27, 2025

Requisition ID: 1631718

The opportunity

We are seeking an experienced Data Architect that can translate business strategies and requirements into world-class technical solutions, applications, and process designs. The role assumes the responsibility for all technical aspects of solution delivery, from inception through design to implementation. They will conduct regular detailed solution analysis and provide expert judgment pertaining to highly complex technical issues including all aspects related to development, infrastructure, data, and configuration management perspectives. This role requires a rare blend of skills normally found in the specialized roles of Cloud Architect, Data Analyst, Data Engineer and Reporting Specialist. The Data Architect will also assist in the establishment and enforcement of architectural standards and best practices to ensure consistency in data solutions delivery across development teams.

Responsibilities

• Lead and provide oversight into the design of end-to-end data solutions including data architecture, data integration, data modelling, security, privacy, regulatory, performance, data governance, business intelligence, etc. and to ensure alignment to the overall business needs.
• Provide technical oversight and recommendations on data infrastructure (on-prem and Cloud).
• Lead discovery sessions with primary business stakeholders to obtain knowledge of business objectives, challenges, and requirements.
• Present and socialize proposed solutions to technical boards during review sessions as well as articulate and communicate designs to stakeholder groups.
• Support solution delivery by providing insights to the application development teams and project managers that plan and execute delivery activities.
• Support implementation processes in association with internal and external development teams. Participate in project-related activities.
• Assume responsibility for the quality of the implemented solution and its adherence to technology strategies, standards, and best practices.
• Create solution architecture documents that describe and explain solution attributes and associated benefits.
• Stay current on emergent technologies relevant to supporting the data solutions delivered for customers.
• Support the identification of opportunities for continuous improvement of solution management methodologies, including obtaining feedback after the solution has been implemented.
• Assist in the identification and recommendation of appropriate solutions, upgrades, replacements, or decommissioning options incorporating business and technology productivity, usability, and total cost of ownership.

Qualifications

• Bachelor’s degree in Information Technology, Software Engineering, Computer Science, or related field. Related professional certifications and/or training is considered an asset.
• 10+ years demonstrated experience in the design and implementation of modern data architectures to support large scale data solutions.
• Expert knowledge of data patterns to support architectures and data management concepts/processes including ETL/ELT, Data Mesh, data lake, data lakehouse, data warehouse, data streaming, data virtualization, etc.
• Strong Expertise in SAS, SAS Viya, SAS migration roadmap and strategy.
• Strong understanding of data modeling (dimensional, data vault, etc.) principles and techniques based on established methodologies (e.g., Kimball).
• Strong knowledge of ETL tools such as Informatica, SSIS, Talend, DataStage, etc. as well as standards and best practices for ETL development.
• Strong knowledge of data governance framework principles and vendor platforms (e.g., Collibra, Informatica EDC/Axon).
• Experience with data manipulation and visualization tools such as Tableau, Power BI, etc.
• Strong knowledge of SQL and demonstrated ability to apply SQL to a wide variety of business requirements.
• Strong Knowledge of ETL frameworks using Azure Data Factory and Databricks Notebooks.
• Strong knowledge in data warehousing concepts and data platforms (e.g., Snowflake, Databricks).
• Strong knowledge of Azure-based architecture and services such as RBAC, AAD, VM, ADLS, Azure DevOps, and Events hub.
• Proficient in building secure architecture using: Encryption, Azure key vault, Access control, Network security, and Advanced data security.
• Knowledge of MDM concepts and solutions.
• Demonstrated experience deploying data solutions in Big Data platforms (e.g., AWS, Azure, GCP, etc.).
• Strong analytical and decision-making skills.
• Experience working within multidisciplinary, distributed, and collaborative environments.

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

• 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

Diversity and Inclusion at EY

Diversity and inclusiveness are 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 Metis) 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 | 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.

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.