Prism Analyst

Taleo; Markham; Hybrid; CAD 58,000 - 73,000; Full time

Benefits offered by this job

Competitive compensation

Pension

Car-loan support

Housing solutions

Exclusive staff perks

Job summary

SE Health in Markham, Ontario, seeks a Prism Administrator to design and maintain Workday Prism Analytics data pipelines and datasets. You will also assist with data ingestion, validation, and reconciliation, plus support integrations and reporting across Workday and external systems.

The role is a 12-month contract with hybrid work, requiring 2–3 days on-site per week and some travel for project support. Bachelor’s degree and 1–3 years of relevant experience are expected.

Qualifications

• Translate business requirements into technical data and reporting needs.
• Experience with enterprise data warehouses, ETL/ELT processes, or data integration platforms.
• Strong analytical and problem-solving skills with the ability to investigate complex data issues.

Responsibilities

• Prism Administration: design, develop, configure, and maintain Workday Prism Analytics data pipelines.
• Data Analysis: profile data, ensure quality, reconcile pay data and validate transformations.
• Integrations: support testing, troubleshooting, and documentation of Workday Prism integrations.

Skills

Translate business requirements

Data analysis

Analytical problem solving

Attention to detail

Large datasets handling

Education

Bachelor's Degree

Job description

The Prism Administrator supports the design and maintenance of Workday Prism datasets, data pipelines, calculated fields, integrations, and Workday reporting solutions. The role also assists with SQL-based data analysis, data reconciliation, troubleshooting, testing, and root-cause analysis across Workday and external systems.

Note: This is a 12-month contract hybrid role based out of Markham, ON. Occasional travel will be required for in-person meetings 2–3 times per week, or as needed for project support.

Key Responsibilities

• Prism Administration

  • Support the design, development, configuration, and maintenance of Workday Prism Analytics data pipelines.
  • Build and maintain Prism datasets by combining data from Workday and external data sources.
  • Support data ingestion, transformation, cleansing, and enrichment processes within Prism.
  • Monitor scheduled data loads and pipelines to ensure successful and timely processing.
  • Investigate and troubleshoot failed data loads, pipeline errors, and data quality issues.
  • Perform data validation and reconciliation between source systems, Prism datasets, and downstream reporting.
  • Assist with optimizing data pipelines for performance, reliability, scalability, and maintainability.
  • Maintain technical documentation for data sources, data pipelines, transformations, dependencies, and business logic.
  • Support the identification and resolution of upstream and downstream data dependencies.

• Data Analysis

  • Perform data profiling and quality checks to identify missing, duplicate, inconsistent, or inaccurate data.
  • Compare source and target data to validate data transformations and integrations.
  • Support pay data reconciliation activities.
  • Analyze large data sets to identify trends, anomalies, and data quality concerns.
  • Document findings and communicate technical issues and potential solutions to technical and functional stakeholders.

• Integrations

  • Support the administration, monitoring, testing, and troubleshooting of Workday integrations and data exchanges.
  • Assist with reviewing inbound and outbound integration data to identify errors and discrepancies.
  • Support integration testing between scheduling systems, Workday Prism, Workday Time Tracking, and Workday Payroll.
  • Analyze integration output files and data to validate completeness and accuracy.
  • Assist with troubleshooting integration failures and escalating complex issues to senior technical resources or integration partners.
  • Support the development and maintenance of integration-related documentation and data flow diagrams.
  • Help identify dependencies between integrations, Prism pipelines, reports, and downstream processes

Required Qualifications

Education

Bachelor's Degree

Data Analytics, Business Administration, Information Systems, Human Resources, Payroll, Finance, or related field

Workday Experience

• 1 to 3 years of experience in HRIS, data analytics, data engineering, systems administration, business intelligence, or enterprise applications.
• Hands-on experience working with data pipelines, data transformation, reporting, or data integration.
• Experience with Workday Prism Analytics and developing or maintaining Workday calculated fields.

Additional Skills/Abilities

• Ability to translate business requirements into technical data and reporting requirements.
• Experience with enterprise data warehouses, ETL/ELT processes, or data integration platforms.
• Strong analytical and problem-solving skills with the ability to investigate complex data issues.
• Strong attention to detail and ability to work with large, complex datasets

Competitive Total Rewards

So much more than a paycheque! Enjoy comprehensive benefits, pension, flexible pay options, car-loan support, housing solutions and exclusive staff perks.

Flexibility & Belonging

Thrive with hybrid work, flexible scheduling and a supportive, inclusive culture that puts people first.

At SE, we are always looking for new, innovative ways to improve. You’ll be encouraged and supported to identify and make improvements to the way we do our work. As a social enterprise, we support research into Senior’s Health and Aging.

Purpose & Impact

Join a national social enterprise where your voice matters. Every role helps advance health, spark innovation and strengthen communities across Canada.

Growth That Meets Your Ambition

Access tuition support, training and meaningful career pathways across a growing, future-focused organization.

About SE Health

SE Health is a not-for-profit social enterprise advancing health with heart. With 115+ years of impact, we bring hope, happiness and exceptional care to people and communities across Canada. We lead with empathy, dignity and purpose while building a future where everyone can realize their full health and well-being potential. We’re also an inclusive, supportive workplace offering competitive compensation, strong benefits and real opportunities to grow. We’re All In Together.

Accessibility

If you require accommodations due to illness or disability, please contact Talent Acquisition at [e-mail].

AI and compensation details

We use AI to take notes during our interview. All applications and interviews are reviewed by our Talent Acquisition team. This role is a new position. The pay range is $58,000 – $73,000 annually, based on experience.