Business Intelligence Senior Analyst

Are you an experienced Business Intelligence Senior Analyst seeking a rewarding career that cares for others, in an organization that cares for you? You’re looking in the right place.

As a Business Intelligence Senior Analyst, you will be responsible for performing strategic business intelligence (BI) development and analyses in support of corporate goals and objectives. The 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 analytic products for Home and Community Care (HCC) 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. 

By applying your business intelligence experience - you will have an opportunity to play a key role in providing connected, accessible, patient-centred care – and be supported by our collaborative team that includes over 8,000 regulated health care and other professionals.

As a valued team member, your mission will be to help our patients be healthier at home, while you benefit from our supports for professional growth, personal wellness and work-life balance.

What will you do?

• Understand home care delivery in Toronto Central and Provincially, and how that is captured in home cara data
• 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, high 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, or specialized training/certification required
• 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-3 year's experience 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). Knowledge of SSIS and SSAS
• Experience with MS Power BI
• Aptitude and interest in Python, .NET Technology, XML/XSLT, JavaScript
• Knowledge of interRAI suite of tools and the Client Health and Related Infomation 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​

Who we are

We are Home and Community Care Support Services, ready to serve every person in Ontario. We partner with patients and caregivers, primary care providers, hospitals, long-term care and retirement homes, service providers and Ontario Health Teams, to deliver responsive, accessible, integrated, patient-centred care.

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

Home and Community Care Support Services 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.

#LI-Hybrid