Join us in re-imagining health care with the largest social enterprise in Canada. SE Health is leading a multi-year enterprise transformation project that leverages human-centered design to be at the forefront of innovation within the healthcare sector. As a leader in home care, we are expanding and enhancing our capabilities to provide personalized experiences using new platforms and cloud-native architectures, ensuring privacy and security by design. Our transformation is grounded in guiding principles drive to ensure that we prioritize team decisions, long-term planning, process standardization, data-driven insights, and balanced user adoption. If you are driven by the desire to have an impact, change the world of health care and shape the future, we invite you to be part of our journey.
Job Summary
This is a contract position.
The contractor will serve as the Workday data and reporting expert embedded within the EBI team. The role has three core mandates:
1. Build: Develop custom RaaS (Report as a Service) reports, web service integrations, and data extraction pipelines to move Workday data into the BI staging environment. The build must align with data warehousing needs/requirements.
2. Map: Complete field-level source-to-target mapping between legacy systems (Great Plains, PeopleSoft, Taleo) and Workday objects/fields, including transformation logic and business rules.
3. Transfer: Train and coach the existing BI team members to independently build, maintain, and govern Workday reports and data extractions, creating a sustainable internal capability.
Job Responsibilities
Workday Data Extraction & Integration
- Design and build custom advanced (RaaS) reports in Workday to extract transactional and master data for BI consumption across HCM, Finance, Payroll, Recruiting, Benefits, Absence, and Learning modules.
- Configure Workday web service integrations for setup/reference data extraction (organizations, cost centers, companies, locations, job profiles).
- Resolve extraction limitations, including the matrix/composite report constraint for summarized financial data (GL balances, income statements, balance sheets) that cannot be exposed as RaaS.
- Collaborate with the BI integration team (via CData middleware) to validate that extracted data populates staging and fact tables correctly, with field-level accuracy.
- Document all custom reports, data sources used, calculated fields created, filters applied, and business logic embedded — to a standard sufficient for ongoing maintenance by SE Health staff.
Source-to-Target Mapping & Data Modeling Support
- Complete the Workday-side field mapping for all GP Finance fact tables, identifying which Workday field, data source, and report corresponds to each legacy staging table column.
- Extend the mapping to PeopleSoft HR, Taleo Recruiting, and D2L/Lambda Learning staging tables as modules come into scope.
- Support the Enterprise Data Architect in validating Workday metadata for the Microsoft Purview business glossary, including object definitions, field descriptions, and relationship context.
- Advise the data modeling team on Workday-specific nuances: effective-dated records, multi-instance relationships, supervisory org hierarchies, and cross-module joins that impact dimensional model design.
- Support data reconciliation between legacy reports and new Workday-sourced reports, identifying and resolving variances caused by differing business logic, field semantics, or aggregation rules.
Knowledge Transfer & Training
- Conduct structured hands-on training sessions for 4 BI team members on Workday Report Writer, data sources, business objects, calculated fields, and custom fields.
- Create internal reference documentation: a practical Workday reporting guide tailored to SE Health’s configuration (not generic Workday training material).
- Pair-program with BI analysts on RaaS reports end-to-end, progressively transferring ownership so team members can build independently by month 4.
- Establish report development standards: naming conventions, security domain considerations, testing protocols, and change governance procedures.
Cross-Team Collaboration & Advisory
- Participate in CR20 and PFM integration meetings as the SE Health internal Workday data subject matter expert, reducing dependency on PwC for data-level questions.
- Liaise with the PFM Workday configuration team on custom objects, calculated fields, and security domain changes that impact BI data extraction.
- Advise on the Unified Reporting Strategy decision framework: which reports belong in Workday native vs. Power BI, based on data source constraints and platform capabilities.
Required Qualifications
Workday Technical Expertise
Minimum 4+ years of hands-on Workday reporting and integration experience, with demonstrated work across both Finance modules.
Deep proficiency in Workday Report Writer: advanced reports, matrix reports, composite reports, calculated fields, custom fields, and data source selection.
Hands-on experience with Workday web services (SOAP/REST), RaaS report-as-a-service exposure, and integration system configuration (ISUs, EIBs, Studio).
Understanding of Workday’s object-based data model: primary vs. related business objects, navigability constraints, data source filtering, and security domain architecture.
Experience building Workday custom reports specifically for external data consumption (BI tools, data warehouses, ETL pipelines) — not just internal operational reporting.
Data Integration & Warehousing Knowledge
Strong understanding of data warehouse concepts: star schemas, fact tables, dimension tables, grain definition, slowly changing dimensions, and ETL/ELT patterns.
Ability to perform source-to-target field mapping between legacy relational databases (SQL Server, GP Dynamics, PeopleSoft) and Workday’s object model.
Familiarity with data reconciliation techniques — comparing legacy report outputs against new-source outputs to identify and resolve variances.
Professional Skills
Exceptional documentation skills — able to produce clear, maintainable technical documentation that a non-Workday specialist can follow.
Strong teaching and coaching ability — comfortable leading hands-on training sessions and pair-programming with analysts of varying technical backgrounds.
Self-directed and able to work independently with minimal supervision in a fast-paced, deadline-driven environment.
Effective communicator across technical and business audiences — able to translate Workday platform constraints into business impact language for stakeholders.
Preferred Qualifications
Experience with Workday implementations in Canadian healthcare or not-for-profit organizations.
Familiarity with Microsoft Power BI, Azure SQL Managed Instance, or Microsoft Fabric as downstream BI/data platforms.
Knowledge of Workday Prism Analytics for curated dataset preparation.
Experience with Microsoft Purview or similar data governance/metadata management tools.
Prior experience working alongside PwC, Deloitte, or other Big Four implementation partners in a Workday engagement.
Workday Pro certification in Reporting or Integrations.
Why Join SE Health?
- 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.
- 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 careers@sehc.com.
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 addition. The hiring pay range is $69,000–$86,000 annually, based on experience.