Business Intelligence Senior Analyst

Job ID
2025-10352
# Positions
1
Job Type
Temporary (Full-Time)
Career Level
Experienced
Years of Experience
3

Job Description

CARE AND BE CARED FOR – THIS IS YOUR HOME
Are you an equal part strategist, innovator, collaborator, leader, and problem solver?  Are you a results-driven Analyst with a proven track record of success in driving an organization’s financial health and operational effectiveness?  Are you seeking a rewarding career that cares for others in an organization that cares for you?  You’re looking in the right place. 

 

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. ​​​We are amid a momentous time for health care in Ontario as we move to a more connected health care system through the Ontario Health Teams model of care.

 

Ontario Health at Home is looking for an experienced leader to drive wellness initiatives across the organization. Reporting to the Director, Organizational Development, the Wellness Lead is accountable for the leadership and performance of the provincial Employee Wellbeing and Wellness Program and is responsible for the development, implementation and management of programs and strategies.

 

Reporting to the Manager, Business Intelligence, the Senior Analyst Business Intelligence Senior Analyst is responsible for performing strategic business intelligence (BI) development and analyses in support of corporate goals and objectives. This includes using BI tools and data cubes to access and analyze data and information to streamline business processes and decision-making and to discover and remove process inefficiencies. This position will help develop and improve reporting processes to support the organization’s current and future reporting needs and will also produce analytics products for Ontario Health atHome reporting. This position works directly with internal and external stakeholders to determine the analytic needs of the customer, engaging peers and leadership as needed.

 

What will you do?

  • Understand home care delivery and how that is captured within our databases
  • Engage with leadership across the organization and from our health care partner organizations to understand their information needs, and translate those needs into data requirements
  • Develop data migration plans and jobs to migrate SQL databases from on-premises to Azure cloud
  • Use technical tools to access patient and organizational data from multiple data holdings to develop reports and analyses that meet these requirements
  • Provide and present information and analysis to leadership and work with leadership to support their understanding and interpretation of the analysis
  • Develop on-demand reports and dashboards that provide accurate well curated data to support management in ensuring high quality, highly efficient home care delivery
  • Develop, monitor and enhance jobs and stored procedures that extract, transform and load data from both internal as well as external data sources into the local Business Intelligence environment

 

What must you have?

  • University degree in Computer Science, Information Systems, Business Management, Epidemiology, specialized training/certification, or another relevant field
  • 3-5 years' direct work experience
  • Experience analyzing and manipulating large data sets
  • Experience developing ETL jobs using MS SSIS
  • Experience synthesizing information and presenting complex results in concise and easy to interpret graphs, charts and tables
  • Excellent Microsoft Excel skills
  • Good written and oral communication skills
  • Strong problem solving, analytical and critical thinking skills. Demonstrated abilities in data analysis, interpretation and report generation; the ability to use data and information to "tell the story"
  • Proficient in a Windows environment

 

What would give you the edge?

  • 2 to 3 years working in healthcare
  • Experience working with data in SQL databases and writing SQL queries
  • Strong knowledge of building reports using SQL Server Reporting Services (SSRS)
  • Experience with both MS Power BI on-premises and cloud
  • Knowledge of MS Fabric
  • Knowledge of SSIS and SSAS
  • Aptitude and interest in Python, .NET Technology, XML/XSLT, JavaScript
  • Knowledge of interRAI suite of tools and the Client Health and Related Information System (CHRIS)

 

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 model (subject to change)
  • Flexible work location - this position can be located at any of the Ontario Health atHome offices
  • Salary - $79,285 to $94,671

 

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.

 

All applications will be reviewed; however, only those selected for an interview will be contacted.

 

#LI-hybrid

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed