Data Architect jobs in Canada

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
• Excellent oral and written communication skills in French and English

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 and approximately 5 - 10 year’s experience
• Solid experience on transformational programs that involve informational systems
• Project execution skills to oversee highly technical implementations at scale
• Experience in architecture and conception in data warehousing, business intelligence, data management, data transformation, Big Data and data visualization
• Experience with range of data tools, for example: Tableau, SAS, Teradata, Informatica, Power BI
• Experience with data virtualization, data visualization, data automation, data modeling
• Experience with databases and data warehouse platforms such as SQL Server, Oracle, DB2,
• Awareness of emerging issues, including regulations, industry practices and new technologies

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 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 includes medical and dental coverage, both pension and 401(k) plans, a minimum of 15 days of vacation plus ten observed holidays and three paid personal days, and a range of programs and benefits designed to support your physical, financial and social well-being. Plus, we offer:

• The opportunity to manage a portfolio of talent within a designated service line
• A collaborative environment where everyone works together to create a better working world
• Excellent training and development prospects, both through established programs and on-the-job training
• An excellent team of senior colleagues, dedicated to managing and varying your workload

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

A career in our EPM practice within Consulting services provides opportunities to work alongside Finance leaders to optimize their finance functions.

Our EPM team sits within the Business Consulting Finance Transformation practice, which assists clients with:

• Finance Transformation Strategy & Roadmap
• FP&A, Controlling Excellence & Management Reporting
• Finance Operating Model Design
• Finance & Accounting Process Improvement
• Global Business Services including Shared Service Centers, Outsourcing
• As an EPM practitioner, you will either support EPM components of projects in those areas or standalone projects focused on transforming and technology enabling:
• FP&A and Management Reporting
• Integrated Business Planning/Supply Chain Planning
• FP&A Operating Model Design
• Automation of Reconciliations

Skills and Attributes for Success

• Collaborating with clients, business analysts, and other stakeholders to gather requirements and understand business needs.
• Designing and developing solutions using OneStream software that meet client's financial and performance management objectives.
• Creating technical architectural designs and documentation, including data models, process flows, integration requirements, and security considerations.
• Designing and developing OneStream solutions, including reports, workflows, forms, data integrations, and custom functionalities.
• Writing efficient, maintainable, and scalable code in OneStream scripting languages.
• Performing system configurations and customizations to meet specific client requirements.
• Conducting unit testing and debugging to identify and fix software defects.
• Participating in system integration activities, including data imports and exports, API integrations, and data validations.
• Providing support and troubleshooting assistance to end-users and system administrators.
• Creating technical documentation, including design specifications, test plans, and user guides.
• Staying updated with the latest releases, features, and functionalities of OneStream software.
• Collaborating with cross-functional teams, including database administrators, business intelligence specialists, and infrastructure teams, to ensure seamless system operations.
• Assisting in system upgrades, patches, and performance tuning activities.
• Contributing to the continuous improvement of development processes and coding standards.
• Assisting in pre-sales activities, including solution demonstrations, proposal development, and client presentations.

To Qualify for the Role, You Must Have

• A strong academic record including a bachelor's degree and a minimum of 8 years’ experience in industry or with a recognized consulting firm.
• Bachelor's degree in Finance, Accounting, Business Administration, Computer Science, or a related field. Advanced degree or relevant certifications are a plus.
• Relevant OneStream certifications (such as OneStream Certified Implementation Consultant, Solution Architect, Developer, etc.)
• Strong understanding of OneStream architecture, modules, and functionalities.
• Proven experience as a Solution Architect, Technical Consultant, or similar role, with a focus on OneStream software.
• Proficiency in OneStream configuration and administration, including metadata management, dimensionality, and security models.
• Experience with integration between OneStream and other enterprise systems.
• In-depth knowledge of finance and accounting principles, along with expertise in EPM processes and methodologies.
• Ability to translate current customer spreadsheet or other financial systems to effective and efficient OneStream solution.
• Deep understanding of planning processes, including G&A Planning, HR Planning, Capital Expense Planning, Project Planning.

Ideally, You’ll Also Have

• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.
• Ability to manage multiple projects simultaneously and work independently in a fast-paced environment.
• Willingness to travel to client sites as needed.

What We Offer

We offer a competitive compensation package where you’ll be rewarded based on performance and recognized for the value you bring. Our total rewards package includes a comprehensive medical, prescription drug and dental coverage, a contribution pension plan, a great vacation policy, firm paid days, statutory holidays and paid personal days (based on province of residence), and a range of exciting programs/benefits designed to support physical, financial and well-being. Plus, we offer:

• Continuous learning: you’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for how you are and empowered to use your voice to help others find theirs.
• Join us and be part of a team that is shaping the future of business planning and performance management. Apply today to embark on a rewarding career as an OneStream Solution Architect!

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.

Security Technology - Cloud Security Engineer

We are looking for a Cloud Security Engineer, who will become part of our Security Technology Services Engineering team. In this role you will be involved in managing and coordinating activities related to cloud technologies, business drivers, and most importantly, security posture. In this role you will have the opportunity to work alongside like-minded individuals, stand up new technologies, and coordinate with internal and external groups to ensure the related systems are secure and robust.

Your key Responsibilities

As an individual contributor, you’ll bring your engineering expertise into efforts which introduce new technologies and upgrade existing ones. Active project participation in new or integrated technologies as the Subject Matter Expert for the Information Security use cases pertaining to Cloud Security technology. You will be responsible for the design, engineering, implementation, and early life cycle support of systems and services within our EY multi-cloud environments. You will work closely with Teams across EY such as: Security Architects, Service Delivery, Security Operations, and Cyber Defense for the enablement of security solutions and services. You will also provide consulting services to other teams and act as a level four contact for operational issues.

• Provide technical oversight of Information Security technologies that fall under the team’s responsibilities, confirming they are operating within agreed service levels and at peak possible performance
• Represent the team in specific Project activities, including Leading projects and managing the activity of others towards successful completion.
• Engineer security solutions and services following all relevant EY standards and practices for On-Premises, Hybrid and Cloud-Based environments.
• Lead the design, implementation, testing of security solutions and services for a large or more complex project to its completion which includes production support and documentation.
• Take accountability for the design, delivery, and maintenance of new and existing security solutions or services, driving compliance with and contributing to the development of relevant standards.
• Apply modern standards/principles, global product-specific guidelines, security standards, design standards, to security solutions and services as appropriate.
• Improve existing security solutions and services in use by partnering with Security Architecture, Service Owners, and Security Operations. Drives automation and innovation across the security solutions supported.
• Work in a diverse, global environment and build strong relationships across all levels of a matrixed, geographically, and culturally dispersed organization.
• Be flexible to work out of regular office hours to accommodate the team and organizational calls and meetings. Weekend or late-night work may occur during project and early life cycle support phases.
• No direct supervision responsibilities though technical leadership required within assigned projects.
• Articulate technology issues/concerns that may emerge at any level of the technical stack, and from any component across the ecosystem, to senior business and technology leaders.

To qualify for the role, you must have

• Hands-on experience and in-depth knowledge in several of the following areas: Cloud services (Azure, GCP, or AWS), cloud resource delivery and management, and security enforcement in cloud environments.
• Hands-on experience with containers and Kubernetes, such as Azure Kubernetes Service (AKS), Google Kubernetes Engine (GKE), or Elastic Kubernetes Service (EKS), as well as serverless container platforms such as Azure Container Apps (ACA), Azure Container Instances (ACI), AWS Fargate, etc.
• Proficiency in scripting with PowerShell, Bash, Python, or similar languages.
• 4+ years of experience in Security, with a strong focus on cloud or container security.
• Proven track record of working with a team as well as managing projects and initiatives.
• Proficiency with change control management processes.
• The ability and desire to train and mentor staff in technical process and best practices.
• Extensive experience working in large, global, and virtual environments.
• Strong English language skills, both written and verbal.

Ideally, you’ll also have

• Hands-on experience with container security platforms such as AquaSec Platform & Trivy.
• Experience or awareness of observability & operation telemetry platforms, such as Azure Log Analytics Workspace, Grafana, Logstash, etc.
• Experience working with automation and workflow orchestration services, such as Logic Apps/PowerAutomate, n8n, etc
• Relevant certifications in cloud administration, engineering, or security (e.g., Azure, GCP, AWS).
• Security certifications such as GSEC, CISSP, or equivalents from ISC2 or GIAC.
• Project management experience and familiarity with service introduction and readiness processes.
• Proficiency with DevOps CI/CD tools, such as Azure Pipelines, GitHub Actions, or AWS CodePipelines.
• Familiarity with hybrid cloud architectures and connectivity solutions like Azure ARC, AWS Direct Connect, and Azure ExpressRoute.
• Expertise in Infrastructure as Code (IAC) and automation tools such as Terraform, Puppet, Chef, Azure DSC, or AutoManage.

What we look for

• This role is perfect for you, if you have excellent problem solving, decision making and communication skills.
• We are looking for people who are comfortable working with culturally diverse on/offshore team members, able to react appropriately during stressful and ambiguous situations, and drive efforts to successful and timely completion.

What we offer:

As part of this role, you will work in a highly coordinated, globally diverse team with the opportunity and tools to grow, develop and drive your career forward. Here, you can combine global opportunity with flexible working. The EY benefits package goes above and beyond too, focusing on your physical, emotional, financial and social well-being. Your recruiter can talk to you about the benefits available in your country. Here’s a snapshot of what we offer:

• Continuous learning: You will develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We will provide the tools and flexibility, so you can make a significant impact, your way.
• Transformative leadership: We will give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You will be accepted for who you are and empowered to use your voice to help others find theirs

From your very first day you'll earn a salary, work toward a globally recognised professional qualification and apply your insights and skills to solve complex business challenges.

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