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

EY; Toronto; On-site; CAD 120,000 - 150,000; Full time

Job summary

A leading consulting firm in Toronto is seeking an experienced Data Architect to design and implement modern data architectures. The ideal candidate will have over 10 years of relevant experience and strong analytical skills. This role offers competitive compensation and comprehensive benefits, emphasizing diversity and inclusion within the workplace.

Benefits

Competitive compensation

Comprehensive health coverage

Pension plan

Generous vacation policies

Opportunities for skill development

Qualifications

• 10+ years of experience in data architecture for large-scale solutions.
• Strong knowledge of data modeling principles.
• Familiarity with cloud environments like AWS, Azure, or GCP.

Responsibilities

• Lead the design of end-to-end data solutions.
• Conduct stakeholder discovery sessions to understand business needs.
• Present proposed solutions to technical groups.

Skills

Data management patterns

SQL proficiency

Knowledge of SAS

Expertise in ETL/ELT

Strong analytical skills

Education

Bachelor's degree in IT, Software Engineering, Computer Science

Tools

Tableau

Power BI

Azure Data Factory

Informatica

Databricks

Job description

At EY, we’re committed to shaping your future with confidence.

We aim to help you succeed in a globally connected environment with diverse teams and to advance your career in any direction you choose.

Join EY and contribute to building a better working world.

The opportunity

We are seeking an experienced Data Architect who can translate business strategies and requirements into world-class technical solutions, applications, and process designs. The role involves responsibility for all technical aspects of solution delivery, from inception through design to implementation. The Data Architect will conduct detailed solution analysis and provide expert judgment on complex technical issues, including development, infrastructure, data, and configuration management. This role requires a unique blend of skills typically found in Cloud Architects, Data Analysts, Data Engineers, and Reporting Specialists. The Data Architect will also help establish and enforce architectural standards and best practices to ensure consistency across data solutions.

Your Key Responsibilities:

• Lead the design of end-to-end data solutions, including data architecture, integration, modeling, security, privacy, regulatory compliance, performance, data governance, and business intelligence, ensuring alignment with business needs.
• Provide technical oversight and recommendations on data infrastructure, both on-premises and cloud-based.
• Conduct discovery sessions with stakeholders to understand business objectives, challenges, and requirements.
• Present and socialize proposed solutions to technical and stakeholder groups.
• Support solution delivery by providing insights to application development teams and project managers.
• Participate in project activities and support implementation processes.
• Ensure the quality and standards compliance of the implemented solutions.
• Create architecture documents explaining solution attributes and benefits.
• Stay current on emerging technologies relevant to data solutions.
• Identify opportunities for continuous improvement of solution management methodologies.
• Recommend solutions, upgrades, replacements, or decommissioning options considering business and technology factors.

Minimum Qualifications:

• Bachelor’s degree in IT, Software Engineering, Computer Science, or related field; professional certifications are a plus.
• 10+ years of experience in designing and implementing modern data architectures for large-scale solutions.
• Expertise in data management patterns, including ETL/ELT, Data Mesh, Data Lake, Data Lakehouse, Data Warehouse, streaming, and virtualization.
• Strong knowledge of SAS, SAS Viya, and migration strategies.
• Understanding of data modeling principles (dimensional, data vault) based on established methodologies like Kimball.
• Experience with ETL tools such as Informatica, SSIS, Talend, DataStage, etc.
• Knowledge of data governance frameworks and platforms like Collibra, Informatica EDC/Axon.
• Experience with data visualization tools such as Tableau and Power BI.
• Proficiency in SQL and applying it to diverse business requirements.
• Knowledge of ETL frameworks using Azure Data Factory and Databricks.
• Understanding of data warehousing concepts and platforms like Snowflake and Databricks.
• Familiarity with Azure architecture and services like RBAC, AAD, VM, ADLS, Azure DevOps, and Event Hubs.
• Ability to build secure architectures with encryption, Key Vault, access control, network security, and data security.
• Knowledge of MDM concepts and solutions.
• Experience deploying data solutions on Big Data platforms such as AWS, Azure, or GCP.
• Strong analytical, decision-making skills, and experience working in collaborative, distributed environments.

What we look for

Passionate leaders with a vision and a desire to stay current with IT Advisory trends. If you are enthusiastic about helping businesses achieve their IT strategies, this role is for you.

What we offer

Our Total Rewards package supports our commitment to a high-performance culture where everyone can reach their potential and contribute to a better working world. It includes competitive compensation, comprehensive health coverage, a pension plan, generous vacation policies, paid holidays, personal days, and programs supporting your well-being. We also offer:

• Support and coaching from industry-leading colleagues
• Opportunities for skill development and career progression
• Flexibility to manage your role effectively

Diversity and Inclusion at EY

We are committed to fostering an inclusive environment where differences are valued. We actively promote equity, combat systemic racism, support gender and neurodiversity, advocate for the LGBTQ+ community, and work towards reconciliation with Indigenous peoples. Our diverse backgrounds and perspectives help us innovate and excel. When our people can be their authentic selves, they perform their best and help us build a better working world.

EY | Building a better working world

We create value for clients, society, and the planet through data, AI, and technology, helping shape the future with confidence. Our teams operate across assurance, consulting, tax, strategy, and transactions in over 150 countries, leveraging sector insights, a global network, and diverse partnerships.