Senior Analyst - Business Intelligence

Are you equal parts strategist, innovator, collaborator, leader and problem solver? Are you a results-driven Business 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.

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. ​​​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.

Reporting to the Manager, Decision Support, the Business Intelligence Senior Analyst is responsible for performing strategic business intelligence (BI) development and analyses in support of corporate goals and objectives. This includes the use of BI tools and data cubes to streamline business processes and decision making and to discover and remove process inefficiencies. This position participates in the re-engineering of 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 analytical needs of the customer, engaging peers and leadership as needed. The Business Intelligence Senior Analyst primarily focuses on the customer engagement and analytical aspects of the position.

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
• 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
• Exemplify, embrace and intentionally promote an inclusive work environment where all are meant to feel they belong

 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 of Business Analysis
• Experience analyzing and manipulating large data sets
• 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
• 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 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 MS Power BI
• 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)

As a condition of employment, all employees are required to submit proof of COVID-19 vaccination status prior to start date.

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
• Salary: $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-centered 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.