Temporary Full-time until 27th August, 2027

37.5 hours/week Mississauga Site Work Arrangement: 3-days remote, 2-days on-site Replacement Position Compensation Range: $45.80-$53.87/hour

Position Summary

Reporting to the Supervisor, Decision Support, this role combines advanced technical expertise with strong analytical and communication skills to support evidence-based decision-making, performance monitoring, and continuous quality improvement across the organization.

The Decision Support Specialist works closely with clinical, operational, finance, and information systems teams to translate complex data into meaningful reporting, actionable insights, and scalable business intelligence solutions. This role supports the design, development, maintenance, and ongoing enhancement of data models, reports, dashboards, and analytical processes that improve organizational performance, reduce manual effort, and strengthen data quality.

Key Responsibilities

Reporting, Analytics & Performance Measurement

Produce accurate, timely, and reliable reporting and analytics to support internal decision-making, operational planning, quality improvement, and external reporting commitments. Develop and support metrics, key performance indicators, scorecards, utilization reporting, and performance measurement frameworks aligned with organizational priorities. Extract, transform, validate, and analyze complex data from multiple sources to identify trends, produce insights, and support strategic and operational initiatives. Complete assigned projects and ad hoc analysis independently while managing competing priorities and deadlines.

Business Intelligence Development & Optimization

Develop, maintain, and enhance Power BI dashboards, reports, scorecards, data models, and other business intelligence products that improve access to timely, actionable information. Identify opportunities to streamline reporting workflows, reduce manual effort, automate recurring processes, and optimize reporting performance and model design. Support scalable reporting solutions that are maintainable, well-documented, and aligned with organizational reporting standards.

Stakeholder Engagement & User Enablement

Collaborate with clinical, operational, finance, and information systems teams to gather requirements, interpret reporting needs, and deliver meaningful analysis that supports service planning and performance improvement. Provide user support and stakeholder guidance on report interpretation, data literacy, and the effective use of reporting and visualization tools. Deliver training, knowledge transfer, and ongoing support to end users and stakeholders, responding to reporting questions and troubleshooting needs as required.

Data Quality, Governance & Documentation

Monitor data quality, investigate anomalies, and recommend improvements to data collection, validation, and reporting processes. Document business rules, metric definitions, validation logic, report specifications, and reporting processes to support consistent interpretation and governance. Develop and maintain clear technical, functional, and user-facing documentation, including reference materials and support resources that promote consistent use and sustainability of reporting solutions.

Qualifications

Education Undergraduate degree in a relevant field such as Health Informatics, Statistics, Mathematics, Computer Science, Business Intelligence, or a related discipline; a master’s degree is considered an asset. A combination of relevant education and experience will be considered.

Experience

Progressive experience in decision support, analytics, business intelligence, or data reporting environment; healthcare experience is strongly preferred. Demonstrated expertise in advanced SQL, relational databases, enterprise data environments, and the development of analytical reporting solutions. Advanced experience developing Power BI datasets, dashboards, scorecards, and reports using SQL, DAX, Power Query, and industry best practices. Experience with performance measurement, balanced scorecards, indicator development, data quality improvement initiatives, and reporting governance practices. Experience developing and maintaining technical, functional, and user-facing documentation, including report specifications, business rules, reference materials, and support resources. Experience providing user support, responding to reporting questions, and delivering training or knowledge transfer to stakeholders and end users.

Knowledge & Technical Skills

Advanced SQL skills, including data extraction, transformation, validation, and optimization in complex reporting environments. Familiarity with automation, modern analytics platforms, and emerging technologies such as Python, Microsoft Fabric, Azure, or related tools. Strong understanding of data modelling, semantic models, and enterprise reporting architecture. Ability to design scalable, high-performing, and user-friendly business intelligence solutions. Strong dashboard and visualization design skills with the ability to communicate complex information to diverse audiences. Experience supporting data quality, validation, reconciliation, and reporting governance practices. Understanding of healthcare privacy, security, access management, and data protection principles.

Team & Interpersonal Skills

Strong analytical, critical thinking, problem-solving, and communication skills, with the ability to independently explore complex data, identify trends, investigate issues, and translate findings into practical, actionable insights for both technical and non-technical audiences. High attention to detail, strong organizational skills, and the ability to manage multiple priorities, projects, and deadlines in a fast-paced environment. Proficiency with Microsoft Office applications, and familiarity with healthcare systems, data standards, or reporting repositories is an asset. Demonstrated ability to work both independently and collaboratively, actively contributing to team discussions, knowledge sharing, problem-solving, and continuous improvement initiatives while building effective working relationships across teams and stakeholder groups.

Internal Deadline: August 7, 2026

Attn: Internal Staff Staff actively working in these roles may be prioritized based on your circumstances: Expression of Interest (EOI): Employees currently in this position who wish to be considered for a transfer (including a change in stream, site, or employment status) should select “Paste Resume” and clearly outline your requested change in the text box provided. Position Change: Employees applying for change in position or a promotion, please submit a cover letter and resume. We’re committed to creating an accessible and inclusive candidate experience. If you need an accommodation at any point in the hiring process, please reach out to our People & Culture team when someone contacts you and we’ll be happy to support you. Join us on our mission to make a difference and impact on the lives of children and youth with disabilities. Apply today to join the ErinoakKids team!

@Erinoakkids The successful candidate will be required to complete a vulnerable sector search. Please note that all prospective ErinoakKids employees are subject to mandatory immunization requirements, as a condition of obtaining and maintaining employment.