Data Architect jobs in Canada

You will also integrate with line of business applications like Microsoft Dynamics 365. While many of our solutions extend Microsoft Dynamics 365, this role also involves extending and integrating with other enterprise systems such as SAP, Salesforce, and industry-specific platforms. You will help our clients harness the Power Platform to create modern omnichannel experiences, empower employees, and enable new business capabilities, while also guiding adoption models, governance, and community enablement.

Your key responsibilities

• Lead presales activities by designing and delivering compelling demos of Microsoft Copilot Studio and Power Platform solutions tailored to client needs.
• Architect and deliver enterprise-scale applications using Power Platform (Canvas, Model-driven, Power Automate, Power Pages) integrated with Dataverse and external systems.
• Design customer- and employee-facing applications that support omnichannel service, digital self-service, and workforce enablement scenarios.
• Leverage emerging AI capabilities, including Copilot Studio (multi-agent orchestration, plugins/actions, grounding) and Azure AI Foundry, and begin to apply Agentic AI approaches to create adaptive, intelligent solutions.Assess AI readiness for clients including data governance, compliance, and infrastructure prerequisites for deploying Copilot and autonomous agent.
• Develop integration patterns to extend ERP/CRM platforms such as Microsoft Dynamics 365, SAP, or Salesforce, and connect Power Platform with line-of-business applications and external APIs.
• Advise clients on licensing, architecture trade-offs, and cost models, shaping solution design for scalability and sustainability.
• Provide technical leadership in solution design, architecture documentation, and strategic decision-making across cloud and business application landscapes.
• Support and lead junior technical team members by sharing best practices, providing design recommendations, offering guidance on complex challenges, and conducting peer reviews to ensure high-quality deliverables and continuous learning.Drive delivery excellence: guide backlog shaping, oversee sprint-level architecture, and ensure non-functional requirements such as performance, security, and maintainability are met.
• Mentor and coach EY delivery teams and client stakeholders on Power Platform best practices, including secure development and AI safety considerations.
• Support business development by contributing to proposals, creating proofs-of-concept and demos, and engaging with client executives to shape solution vision.
• Promote adoption and governance by advising clients on Center of Excellence models, Managed Environments, and enabling federated maker communities that balance innovation with control.
• Advance EY’s practice maturity through reusable reference architectures, solution accelerators, and delivery playbooks tailored for Power Platform engagements.

Skills and attributes for success

• Delivery leadership: serve as the accountable architect for major Power Platform programs, ensuring technical quality, scalability, and business value from blueprint through go-live.
• Business development: support pursuits by shaping solution architectures, creating compelling demos, and articulating the business impact of Power Platform and AI-driven solutions.
• Practice maturity: contribute to EY’s Microsoft Business Applications and Power Platform competency by codifying solution patterns, accelerators, and delivery frameworks.
• Adoption & governance: advise clients on enabling federated maker communities, platform guardrails, and CoE/ALM models to drive safe and scalable adoption of Power Platform.

To qualify for the role, you must have:

• 10+ years in enterprise solution architecture, with at least 5 years hands-on experience delivering solutions with Microsoft Power Platform (Canvas and Model-driven apps, Power Automate, Dataverse, Power Pages).
• Proven experience building robust applications that are customer- or employee-facing, enabling omnichannel service, digital engagement, or workforce empowerment—not just process automation.
• Track record extending Power Platform alongside enterprise applications such as Microsoft Dynamics 365, SAP, Salesforce, or other industry platforms.
• Hands-on delivery experience with AI-driven solutions, including Copilot Studio and Azure AI Foundry; familiarity with emerging patterns in Agentic AI.
• Integration expertise across Microsoft ecosystem and third-party APIs, with an understanding of event-driven and API-first patterns.
• Experience advising on governance, ALM, and community enablement (CoE Starter Kit, Managed Environments, ALM Accelerator, and fostering federated maker communities).
• Strong consulting skills: client-facing leadership, solution shaping, workshop facilitation, pre-sales contributions, and executive communication.

Ideally, you’ll also have

• Microsoft certification: Power Platform Solution Architect Expert (PL-600).
• Additional certifications: PL-400 (Developer Associate), PL-200 (Functional Consultant Associate), PL-300 (Power BI Data Analyst).
• Relevant AI certifications such as AI-102 (Azure AI Engineer Associate) or AI-900 (Azure AI Fundamentals).

What we look for

• We’re interested in talented professionals with the ability to design and deliver a customer self-service portal built on Power Pages integrated with SAP order management, supported by Copilot Studio agents for digital assistance.
• Build an employee-facing mobile app using Canvas Power Apps and Power Automate to streamline field operations, integrated with Dynamics 365 or other ERP platforms.
• Extend a CRM or ERP platform with AI-driven copilots using Copilot Studio, Azure AI Foundry, and agentic AI principles for adaptive workflows.
• Guide a client’s IT and business leaders in standing up a Managed Environment and CoE to govern a federated maker community, enabling innovation while maintaining compliance.

The Azure Databricks Data Engineer will be instrumental in building and maintaining an optimized data ecosystem using Azure Databricks. You will be responsible for developing and managing data pipelines, ensuring data quality, and enabling advanced analytics capabilities. Your role will involve close collaboration with data scientists, analysts, and other stakeholders to deliver data-driven solutions that support the strategic goals of EY.

Your Key Responsibilities

As a Data Engineer, you will:

• Design, construct, and maintain scalable data pipelines and ETL/ELT processes across Snowflake and/or Azure Databricks environments.
• Develop data processing workflows using Databricks Notebooks, Spark SQL, and/or Snowflake SQL.
• Optimize data storage and processing performance to support real-time analytics and business intelligence.
• Collaborate with cross-functional teams to gather requirements and translate business needs into technical specifications.
• Build and maintain data models, data marts, and data warehouses to support analytics and reporting.
• Implement data governance, security, and compliance best practices across cloud data platforms.
• Troubleshoot and resolve data processing issues, ensuring high data quality and integrity.
• Provide technical guidance on platform capabilities and mentor junior data engineers.
• Stay current with the latest features and trends in Snowflake, Databricks, and cloud data engineering.
• Develop and maintain documentation related to data pipeline architecture, development processes, and governance.

Skills and Attributes for Success

• Certifications such as Snowflake SnowPro, Azure Data Engineer Associate, or Azure Data Scientist Associate.
• Experience with BI tools like Power BI, Tableau, or Looker.
• Familiarity with machine learning frameworks, data science concepts, and big data tools.
• Experience with version control systems (e.g., Git) and workflow orchestration tools (e.g., Apache Airflow).
• Understanding of DevOps practices, CI/CD pipelines, and data integration techniques.

To Qualify for the Role, You Must Have

• A Bachelor's or Master’s degree in Computer Science, Engineering, Information Systems, or a related field.
• Proven experience as a Data Engineer with hands-on expertise in Snowflake, Databricks, and/or Azure.
• Strong programming skills in Python, Scala, or Java.
• Proficiency in SQL, data modeling, and data warehousing concepts.
• Knowledge of cloud platforms such as Azure, AWS, or GCP, and their integration with Snowflake.
• Experience with Apache Spark and its integration with Databricks.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work collaboratively in a fast-paced, team-oriented environment.

What we offer

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 flexibility to handle your role in a way that’s right for you

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.

In the Assurance Digital and Innovation team, you will be joined by a team of multidisciplinary professionals in versatile roles, which includes data analytics, programming, automation, and data visualization. You will experience ongoing professional development through diverse experiences, world-class learning and individually tailored coaching. That’s how we develop outstanding leaders who team to deliver on our promises to all of our stakeholders, and in so doing, play a critical role in building a better working world for our people, for our clients and for our communities.

Your Key Responsibilities

• Work within our Assurance Digital and Innovation team to design and develop complex Power BI reports, following industry standards
• Export, transform, validate, and output large and complex data sets for use in reports
• Collaborating with EY teams and clients to understand the relevant business problems and data needs to develop reports
• Ensure all solutions comply with the highest levels of security, privacy and data governance requirements
• Work on and manage mid-size projects, and ensure smooth service delivery on assigned products and engagements
• Maintain and develop positive, productive, and professional relationships with clients and stakeholders

Skills and attributes for success

• 3+ years of professional experience with dashboards and data visualization using Microsoft Power BI, including data model design. Deep understanding of writing SQL, and DAX functions
• Strong understanding of BI best practices, analysis, visualization, and latest BI trends
• Solid working knowledge of report and dashboard design and development tools and techniques
• Curiosity to learn the business methodology, data model and user personas.
• Experience following DevOps best practices, such as unit testing, branching, builds, deployment, regression testing, etc.
• The ability to provide excellent client service and manage and build strong relationships both internally and externally, coupled with a strong interest in further developing and integrating operations with technology skills

To qualify for the role you must have:

• An undergraduate degree in computer science, computer engineering, business or accounting, or another related field
• A minimum of three years’ work experience, with preference for experience at a Big 4, or top tier consulting firm with data analytics services, or a similar transformation change role
• A basic understanding of financial or accounting terminology
• Strong interest in BI design, data analytics, data transformation
• Strong project management and organizational skills with an ability to multitask
• Excellent communication skills with an ability to explain technical terms to a non-technical audience
• A critical and logical thinker who is able to work both independently and in a team environment
• Process driven individual with a strong attention to detail

In this role, you will analyze complex financial data, operational metrics, and market trends, transforming them into actionable insights that facilitate informed decision-making. By concentrating on these critical areas, you will enable organizations to optimize their operational efficiency and achieve their strategic goals, significantly impacting their journey toward excellence.

Our team leverages a wide range of leading EPM platforms, including:

• Acterys
• Anaplan
• Board
• Microsoft Business Performance Planning
• OneStream
• Oracle EPM
• SAP SAC and Group Reporting
• Wolters Kluwer CCH Tagetik

Your key responsibilities

• Lead the design and implementation of EPM solutions across planning, budgeting, forecasting, and reporting.
• Translate business requirements into scalable technical architectures for modern EPM systems.
• Collaborate with clients and internal teams to ensure successful delivery and measurable impact.
• Serve as a technical lead on EPM projects, developing models, integrations, and custom functionalities.
• Guide junior developers and ensure high-quality delivery aligned with client expectations.
• Support the development and configuration of EPM solutions, including system setup, testing, documentation, and user support.
• Learn and grow within a dynamic team focused on financial performance technologies.

Skills and attributes for success

• Strong understanding of EPM platforms and financial planning processes (e.g., FP&A, HR planning, CapEx).
• Ability to translate business requirements into technical solutions.
• Experience with data modeling, scripting, and system integration.
• Excellent communication and collaboration skills.
• Ability to work independently and manage multiple priorities in a fast-paced environment.

Ideally, you’ll also

• Relevant certifications as a solution architect in one or more of the EPM systems EY Canada implements.
• Experience integrating EPM platforms with other enterprise systems.
• Familiarity with planning processes such as G&A Planning, Workforce Planning, Capital Expense Planning, and Project Planning.
• Exposure to pre-sales activities, including solution demos and proposal development.

We are seeking a Senior Consultant or Manager - Data Architect for our AI & Data practice team. We are looking for a candidate with strong technical leadership background, hands experience with Azure, Microsoft Fabric, Data Bricks, Pursuits, proposal and delivery.

Skills and attributes for success

• The ability to provide excellent client service and manage and build strong relationships both internally and externally, coupled with a strong interest in further developing and integrating operations with technology skills
• Provide architecture leadership & subject matter expertise to client engagements focusing on complex & innovative products and reusable assets
• Develop solution plans, prior to kicking off a project as part of a product life cycle, intended to support business investment decisions which means they must hold the appropriate balance between costs, risks and quality of the product
• Create innovative and practical designs that account for the end-to-end technical solution of a system, in line with the business strategy and objectives and within the context of EY's technology environment
• Work closely and continuously with the business/client to focus on meeting business/client requirements and incorporating broader aspects such as overall product costs/revenue, data privacy & sovereignty, business continuity, information security, integration with other systems etc.
• Identify, define and implementing reusable assets and standards. The data architect is also responsible for adherence to these standards and consumption of reusable assets across products and portfolios
• Ensure relevant technical strategies, policies, standards, and practices are applied correctly across Technology programs/projects and products
• Contribute to the development of architecture governance structures, methodologies, and compliance activities
• Work with the vendors to assess vendor products, understand vendor's delivery models and assist in implementing them at EY
• Ability to work across multiple projects with varied stakeholders. A Data Architect sets architectural direction, builds consensus, mediates conflicts providing technical leadership and advisory services to the business. He/she anticipates needs and potential objections and helps to create an environment which solicits positive contributions from all participants: Data and Technical Architects, engineering teams, product manager, project managers, product analysts, test and project teams, Information Security and Operations
• Demonstrate excellent interpersonal communication and organizational skills that are required to operate as a leading member of global, distributed teams that deliver quality services and solutions.
• Cultivate lasting relationships across business, IT and vendors / industry analysts to maintain insight into the broader enterprise as well as industry trends
• Recognizes industry technology trends and emerging technologies, understands how they apply to EY and can drive their adoption into our organization
• Evangelizes and encourages the importance of technical quality, emerging technologies, sharing & experimentation across the org through mentoring, hackathons, communities etc.
• Drives an ongoing communication plan to educate stakeholders on the purpose and benefits of data architecture
• Guide others in resolving complex issues in data architecture and solves complex, escalated aspects of a project
• Monitor the progress and the quality of the project and reviews and develops due diligence to confirm the developed solution complies with architectural design

To qualify for the role, you must have

• Bachelor’s degree in computer science, mathematics, data science, informatics, operations research, engineering, or a related field
• Awareness of emerging issues, including regulations, industry practices and new technologies
• Data Platform experience
• Microsoft Azure
• Data Modelling skills
• Databricks
• Data Engineering

Ideally, you’ll also have

• Interest in Data Analytics along with experience in programming is a highly desired. You will need to demonstrate strong technical problem-solving abilities
• Cloud infrastructure
• Microsoft Fabric
• Unity Catalog
• Data Bricks assets Bundles (DAB)
• CI/CD
• Data Migration
• 5+ years of experience in the field

What we offer

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 flexibility to handle your role in a way that’s right for you

In the lab, you will be joined by a team of multidisciplinary professionals in versatile roles, which includes data analytics, programming, automation, and data visualization. You will experience ongoing professional development through diverse experiences, world-class learning and individually tailored coaching. That’s how we develop outstanding leaders who team to deliver on our promises to all of our stakeholders, and in so doing, play a critical role in building a better working world for our people, for our clients and for our communities.

Your key responsibilities

• Work within our Assurance Digital team to export, transform, validate, and output large and complex data sets for use in EY’s data analytics tools
• Work and build strong relationships with EY audit teams while co-developing a robust and repeatable data analytics delivery process
• Proactively monitor, manage, and execute projects with engagement teams
• Collaborate with the data analytics and engagement teams to design and implement improvements to the data delivery process

Skills and attributes for success

• An undergraduate degree in business or accounting with a minor in computer science, computer science, computer engineering, data analysis, financial mathematics or another related field
• A minimum of two years’ work experience
• A basic understanding of a company’s financial reporting process and financial terms
• Strong interest in data analytics, data transformation, robotics process automation, and finance or accounting
• Strong project management and organizational skills with an ability to multitask
• Excellent communication skills with an ability to explain technical terms to a non-technical audience
• A critical and logical thinker who is able to work both independently and in a team environment
• Process driven individual with a strong attention to detail
• This role involves interaction with clients operating nationally and globally where fluency in French and English is required. Bilingualism in both French and English is therefore a requirement of this role.