Business Intelligence Senior Analyst

Business Intelligence Senior Analyst

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.

If so, take a look at this rewarding career opportunity to work alongside a supportive and collaborative team of over 9,000 regulated health care and other professionals. ​​​We are in a momentous time for health care in Ontario as we move to a more connected system through the Ontario Health Teams model of care.

Ontario Health at Home is looking for a Senior Analyst Business Intelligence who will report to the Manager, Business Intelligence. The Senior Analyst Business Intelligence will perform strategic business intelligence (BI) development and analyses supporting 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
• 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
• 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
• 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)

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-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. Accommodation for persons with disabilities required during the recruitment process is available upon request.

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