Manager - AI and Data - Solution Architect

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

Job summary

Join a forward-thinking company as a Manager in Data Analytics, where you will lead innovative data architecture projects and collaborate with clients to enhance their data capabilities. This role offers the opportunity to work on cutting-edge cloud solutions, mentor teams, and drive impactful change in data management practices. With a commitment to diversity and inclusion, the organization fosters an environment where your unique contributions are valued. If you are passionate about leveraging data to support business decisions and thrive in a collaborative setting, this position is perfect for you.

Benefits

Comprehensive medical coverage

Prescription drug coverage

Dental coverage

Defined contribution pension plan

Variety of benefits for well-being

Qualifications

• 7+ years of experience in data architecture and database design.
• Proficiency in SQL and cloud data platforms like AWS, Azure, or GCP.

Responsibilities

• Lead data architecture projects ensuring alignment with client objectives.
• Collaborate with clients to develop cloud-based data strategies.

Skills

Data Architecture

Data Engineering

SQL

Cloud Computing

Leadership

Communication

Education

Bachelor's degree in Computer Science

Master's degree in Information Systems

Tools

AWS

Azure

GCP

Snowflake

Job description

Location: Toronto

Other locations: Primary Location Only

Date: Mar 10, 2025

Requisition ID: 1550430

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. Join us and build an exceptional experience for yourself, and a better working world for all.

The opportunity

We are seeking a Manager, Data Analytics, Solution Architect. Our IT Advisory Analytics practice works collaboratively with our clients to enhance their ability to use and interpret data, and develop their own enhanced information management capabilities to support better decision making, along with regulatory compliance within their business.

Your Key Responsibilities

As a Manager, Data Analytics, Solution Architect at EY, you will apply your expertise to lead key projects, cultivate meaningful relationships both within EY and with clients, and develop your capabilities through formal training and mentorship from senior colleagues across various functions. With a minimum of 7 years of experience, you will be responsible for leading the design and execution of data architectures and solutions that align with business needs and support organizational goals across industries.

• Lead and oversee data architecture projects, from initial discovery and design to implementation and optimization, ensuring alignment with client objectives and best practices.
• Collaborate with clients to understand business requirements, data challenges, and technical constraints, and develop cloud-based data strategies and roadmaps to address client needs.
• Architect, design, and implement scalable and performant data platforms, including data warehouses, data lakes, and data pipelines.
• Develop and document data architecture designs, data models, and integration patterns, ensuring alignment with industry standards, security requirements, and regulatory compliance.
• Develop conceptual, logical, and physical data models, including dimensional modeling (star schema, snowflake schema), Data Vault 2.0 modeling, and graph data modeling.
• Lead and mentor onshore and offshore project teams, providing technical guidance, coaching, and support to ensure successful project delivery.
• Conduct performance tuning, optimization, and troubleshooting of data environments, identifying and addressing performance bottlenecks, data loading issues, and query optimization opportunities.
• Manage client relationships, expectations, and escalations, ensuring timely delivery, quality assurance, and customer satisfaction.
• Commitment to continuous learning and staying abreast of emerging trends, technologies, and best practices in data management.

To qualify for the role you must have

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• Minimum 7 years experience in data architecture, data engineering, and database design, preferably in a consulting or professional services environment.
• Minimum 3 years’ experience in designing and implementing Snowflake architecture, features, and capabilities.
• Working knowledge and demonstrated experience designing data models with a focus on Data Vault 2.0 methodology.
• Demonstrated proficiency in SQL.
• Strong understanding of cloud computing principles, cloud-native architectures, and best practices for deploying and managing data solutions on cloud platforms.
• Hands-on experience with cloud data platforms such as AWS, Azure, or GCP.
• Excellent leadership, communication, and interpersonal skills.
• Technical Skills/Certifications: SnowPro Core, SnowPro Advanced Architect (considered an asset) / Data Vault 2.0 (considered an asset).
• Proven track record of delivering complex data architecture projects on time and within budget.

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. We offer a competitive compensation package based on performance, comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, and a variety of benefits designed to support your well-being.

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 and our people feel a sense of belonging.

EY | Building a better working world