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

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

Job summary

A leading advisory firm in Toronto is seeking an experienced Data Architect to lead and provide oversight on the design of end-to-end data solutions, ensuring alignment with business needs. The ideal candidate has over 10 years of experience in implementing modern data architectures and expert knowledge of data management processes. This role offers a competitive compensation package and solid growth opportunities.

Benefits

Comprehensive medical and dental coverage

Defined contribution pension plan

Flexible working arrangements

Qualifications

• 10+ years of experience in designing modern data architectures.
• Expert knowledge in data management processes.
• Strong analytical and decision-making skills.

Responsibilities

• Lead design of end-to-end data solutions.
• Provide oversight on data infrastructure.
• Support solution delivery and implementation processes.

Skills

Data architecture design

ETL/ELT processes

SAS knowledge

SQL proficiency

Data governance framework

Data manipulation and visualization

Education

Bachelor’s degree in Information Technology or related field

Tools

Informatica

Power BI

Azure Data Factory

Databricks

Job description

Press Tab to Move to Skip to Content Link

Location: Toronto

Other locations: Primary Location Only

Date: Jul 31, 2025

Requisition ID: 1631718

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.

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.

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

To qualify for the role you must have:

• 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, date 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'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 flexi bility 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 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 | 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.

Select how often (in days) to receive an alert:

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.