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.