AI and Data - Manager - Solution Architect

EY; Waterloo; On-site; CAD 104,000 - 150,000; Full time

Job summary

EY is seeking a Manager, Data Analytics, Solution Architect to lead projects and enhance clients' data capabilities. The role requires 7+ years of experience in data architecture, focusing on designing scalable solutions and mentoring teams. Join EY to build a better working world with your expertise.

Benefits

Comprehensive medical, dental, and prescription coverage

Defined contribution pension plan

Flexible vacation policy

Support and coaching from colleagues

Opportunities for career development

Qualifications

• Minimum 7 years experience in data architecture and engineering.
• Experience with Snowflake architecture and Data Vault 2.0.
• Bilingualism (English and French) is an asset.

Responsibilities

• Lead design and execution of data architectures and solutions.
• Collaborate with clients to develop cloud-based data strategies.
• Mentor project teams and ensure successful project delivery.

Skills

Data architecture

SQL

Cloud computing

Data modeling

Leadership

Education

Bachelor's or Master's degree in Computer Science

Job description

AI and Data - Manager - Solution Architect

Join to apply for the AI and Data - Manager - Solution Architect role at EY

AI and Data - Manager - Solution Architect

1 day ago Be among the first 25 applicants

Join to apply for the AI and Data - Manager - Solution Architect role at EY

Get AI-powered advice on this job and more exclusive features.

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 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. Our clients need the vision to articulate the big picture and the precision to see the smallest of details.

Information and intelligence are the assets which enable this, and our Analytics practice provides innovative approaches to unlocking this information, solving many of our clients’ biggest challenges. We are working to integrate this capability into all Advisory service offerings and assists clients to leverage data as an asset throughout its business processes.

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. We believe in the power of high-performing teams from diverse backgrounds, and we are looking for individuals with experience in industry, consulting, delivery, or vendors. If this is your first step into consultancy, we will provide the necessary support to help you transition successfully into the team.

With a minimum of 7 years of experience, the Solution Architect 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. You will play a pivotal role in defining data strategies, developing scalable data architectures, and implementing innovative solutions to address complex business challenges. This role involves close collaboration with clients, project teams, and technical experts to deliver data solutions that drive substantial business value.

Skills And Attributes For Success

• 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, to represent business entities, relationships, and processes
• Lead and mentor onshore and offshore project teams, including data architects, data engineers, and developers, 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
• Collaborate with vendor account teams, technical support, and product management to stay updated on new features, enhancements, and best practices, and provide feedback and recommendations to clients
• 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, including Snowflake's multi-cluster architecture, data sharing, semi-structured data support, and security features
• Working knowledge and demonstrated experience designing data models with a focus on Data Vault 2.0 methodology as well as working knowledge of different approaches such as dimensional (Star, Snowflake)
• 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 and familiarity with data services
• Excellent leadership, communication, and interpersonal skills to effectively lead project teams, collaborate with clients, and influence decision-making at executive levels.
• 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, managing client relationships, and driving business outcomes.
• Bilingualism (English and French) would be considered an asset
  
  

Ideally, you’ll also have

• Enterprise data modeling experience across a variety of industry verticals
• Experience with data warehousing tools such as WhereScape, Coalesce, VaultSpeed
• Specific expertise in Snowflake data warehouse platforms
• Experience with Data Vault 2.0 data warehousing methodologies
• A high level of motivation, strong work ethic and self-starting attitude.
  
  

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, coaching and feedback from some of the most engaging colleagues around
• 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
  
  

The salary range for this job in British Columbia is $104,000 to $150,000. Individual salaries within this range are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and work location city.

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Professional Services

Referrals increase your chances of interviewing at EY by 2x

Get notified about new Data Solutions Manager jobs in Waterloo, Ontario, Canada.

Senior Manager, Enterprise Data Solutions

Senior Product Manager, Workflows & Actions

Senior Manager of Solution and Technical Delivery(Enterprise Applications)

Senior Technical Program Manager, AI/ML Programs

Technical Program Manager, Precision Health Platform

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.