Business Intelligence Senior Analyst

Are you a business intelligence expert interested in supporting community healthcare leaders in system wide transformation? Do you have demonstrated success in the analysis of performance management information and in providing support, education, and advice to staff and leaders to enhance business decision making? Are you passionate about data analysis and supporting projects and strategic objectives for an organization whose goal is to help others?

If so, take a look at this rewarding career opportunity working alongside a supportive and collaborative team of over 9,000 regulated health care and other professionals.

​​​

Ontario Health atHome is looking for a Business Intelligence Senior Analyst for the Decision Support Team who will lead and collaborate on the compilation and analysis of organizational performance management information to support projects and initiatives across the organization. This position will require someone who has a strong knowledge of SQL, report creation and report writing, and data extraction and analysis.

Supporting the Manager, Decision Support, the Business Intelligence Senior Analyst provides education and recommendations to management and staff with respect to the use of information and recommendations based upon the results of their data analysis.

This position acts as a partner to management and leverages analytical skills to enhance business decisions and support the performance measurement of strategic and operational objectives across the organization.

What will you do?

Data Analysis/Business Intelligence

• Responsible for Data Extraction, Analysis, Interpretation and Reporting for the organization. Develop and maintain a SQL database warehouse, SQL & MDX scripts, GIS analysis infrastructure and Business Intelligence (BI) tools.
• Consult with management on business needs, translating business needs into analytics/reporting requirements and interfacing with management to ensure successful delivery of analysis or information reporting.
• Create, writes, and maintains reports from the client database systems.
• Provide business intelligence, report discrepancies/data quality issues or advise on projects.
• Analyze data and provides interpretations, recommendations and summaries when necessary.
• Ensure system design and usage are compliant to relevant policies.
• Participate on provincial committees for the Decision Support department.
• Assist external partners and projects with BI information.
• Develop and provide ad-hoc information requests and performance improvement reports to management and staff through the creation of graphs, charts, worksheets, standardized reports, metrics, and individual consultations by utilizing reporting analysis tools to access information, analyze the meaning of information, and to present information in such a way as to influence and create actions.

Consultation

• Work with CHRIS Operational Working Group and Business Process Staff to review and investigate system changes and business process changes.
• Foster and participate in the data quality practices; apply validation methodologies to support the primary data quality attributes.
• Work with departmental partners to support Ontario Health atHome projects.
• Work with the Decision Support team to ensure the timely completion of all informational requests entered into the work order system.

Data Quality

• Analyze and assess effectiveness of various methods for data collection and their ability to measure improvement and forecast future needs.
• Develop tools to support process improvements and evaluate the effect on quality outcomes.
• Ensure data integrity and compliance throughout the project life cycle.
• Monitor data quality against various systems and take investigative action where required;
• Uses problem-solving methodologies to conduct analyses and recommend corrective and/or preventative action.

What must you have?

• A four-year degree in statistics, mathematics, computer science or related field or the equivalent of education and related progressive experience;
• Minimum four (4) years' experience working with databases, SQL Server, writing data and information queries, designing and producing reports and providing quality assurance for data input;
• Extensive knowledge and experience in using various query and scripting languages (SQL, MDX, DAX);
• Extensive experience with Report Writing / SQL Server queries;
• Excellent oral and written communication skills with demonstrated success in the communication of complex data across a range of audiences;
• Experience preparing for and conducting training;
• Vehicle and valid Ontario driver's license is required;
• Strong planning and organizing skills;
• Solid working knowledge of MS Office business applications (e.g., Word, Excel, PowerPoint, etc.);
• Experience working with healthcare / home care data and systems considered a strong asset;
• We have a mandatory COVID-19 vaccination policy. As a condition of employment, all employees are required to submit proof of COVID-19 vaccination status prior to start date.

What would give you the edge?

• 2-3 years proven leadership experience in a healthcare setting;
• Knowledge of Ontario Health atHome services
• Ability to speak French or another second language

What do we offer?

We know wellness is supported with work-life balance. In an inclusive culture committed to support your passion for continuous learning, growth and innovation, we offer: ​

• Attractive comprehensive compensation packages and benefits​
• Valuable development opportunities​
• Membership in a world class defined benefit pension plan​
• Hybrid work environment and flexible work location [a mix of on-site and remote work allow for flexibility in work locations including any of the Ontario Health atHome offices across Ontario]
• Salary: OHaH Non Union Band 5 - $79,285.64 to $94,671.25 annually

Who are we?

We are Ontario Health atHome, ready to serve every person in Ontario. We partner with patients and caregivers, family physicians, hospitals, long-term care and retirement homes, service providers and Ontario Health Teams, to deliver responsive, accessible, integrated, patient-centred care.

Why join us?

If you're interested in driving excellence in care and service delivery, and seeking an unparalleled opportunity to lead and learn, partner and connect, care and be cared for, this is your home.

Equity, Inclusion, Diversity and Anti-Racism Commitment

Ontario Health atHome is committed to a culture of equity, inclusion, diversity and anti-racism. We are committed to attracting, engaging and developing a workforce that reflects the diverse communities we serve. We welcome and encourage applications from all qualified applicants. Accommodations for persons with disabilities required during the recruitment process are available upon request.

We thank all applicants for their interest; however, only those selected for an interview will be contacted.

Date Posted: February 20, 2025 Closing Date: February 27, 2025

Job Title: Business Intelligence Senior Analyst

Job Type: Permanent Full Time

Hours in a Bi-weekly Period: seventy-five (75)

FTE: 1.0

Reports To: Manager, Decision Support

Department: Decision Support

Group: Non Union

Location: Flexible (can be located at any of the Ontario Health atHome South East offices - Kingston, Belleville, Brockville, Smiths Falls, ON)