Business Intelligence Senior Analyst

Job Description

Business Intelligence Senior Analyst

Are you passionate about about exceptional health care and driven by a desire to help others? Interested in a rewarding career working alongside a supportive and collaborative team of over 8,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, Business Intelligence and Analytics, the Business Intelligence Senior Analyst 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 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.

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. 
• Flexible work location within the West Region ​

What do I need to know?

Position Status: Full-Time

Hours of Work: Monday - Friday (8:30am - 4:30pm)

Location: One of our offices within the Ontario West Region

This position is a Hybrid position and will be required to be onsite in the office as determined by the Employer. The successful applicant must be willing and able to attend onsite as required.

What will you do?

• Research and review processes that support business intelligence functions and system requirements.
• Collaborate with project managers, system owners, and end users to further refine business intelligence requirements and goals.
• Analyze the effectiveness and efficiency of business intelligence processes and develop strategies for enhancing them.
• Evaluate findings to develop new processes.
• Create and/or prototype new BI procedures to enhance business processes, operations, and data flow.
• Perform data analyses as requested.
• Develop and present ad hoc reports in support of various business process initiatives both internally and externally involving initiatives related to patient service and staffing planning and business continuity, including labour relations planning.
• Participate in, and at times lead, the collection and analysis of data to support the confidential strategic direction of the organization, including information related to employment and collective bargaining
• Provide critical BI analysis, data and support related to organizational metrics and staffing for budget preparation and strategic planning
• Provide consultative and technical support to the team and other strategic decision-making groups on BI tools.
• Work with internal and external customers and partners to collect requirements, negotiate and inform specifications, and implement solutions to data and analytical requests
• Implement mechanisms to maintain and provide up-to-date data, reports, analysis, and interpretation of information to support home and community care operations, HCCSS management reporting including scorecards, dashboards and indicators, strategic projects, and external reporting requirements.
• Provide input to business requirements for the design of BI solutions.
• Interpret business requirements and determines optimum BI solutions to meet needs.
• Design organization-wide “views” and custom reports to help stakeholders self-serve.
• May perform analysis for a wide range of requests using data in different formats and from various platforms.
• Research business problems and creates BI models that help analyze these business problems.
• May lead or provide direction for the planning, designing, and execution of user efforts and use of BI.
• Review test plans and monitors testing process to ensure that business results are tested.
• Resolve issues based on test results. Adheres to current standards.
• Provide input to standards, policies and procedures for the form, structure, and attributes of the BI tools and systems.
• Identify and provides input to new technology opportunities that will have an impact on the enterprise-wide BI systems.
• Maintain strict confidentiality and discretion when working with confidential organizational data and information, including but not limited to information relating to the organization’s collective bargaining strategies and the interests of the organization in the areas of labour relations and employment
• Embody HCCSS mission, vision and values and applies quadruple aim (enhancing patient experience, enhancing provider/staff experience, improving value, and improving populations health) to support continuous quality improvement in daily work
• Exemplify, embraces, and intentionally promotes an inclusive work environment where all are meant to feel they belong
• Continually demonstrate a commitment to create a positive culture of equity, inclusion, diversity, and anti-racism
• Other duties as assigned

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
• 2-3 years’ experience working in health care, highly desirable
• Demonstrated experience working with a team in a professional environment with tight timelines and highly sensitive material.
• Experience leading or participating in complex organizational projects.
• 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’.
• Strong communication skills (verbal, written, presentation), with an ability to display and explain complex analyses in an easily understood user-friendly manner geared to the target audience.
• Experience in a health care decision support environment and a solid understanding of the health care system.
• Demonstrated experience analyzing business intelligence and technical requirements
• Demonstrated experience modeling and mapping business intelligence processes using proven methodologies and models
• Expertise in designing, developing, and implementing re-engineered business intelligence processes and associated software and hardware
• Ability to troubleshoot business intelligence process changes, errors, and subsequent modifications; must be able to do this with the work of other analysts
• Able to interpret the operational requirements of end users, project managers, and other stakeholders
• Excellent organizational, project management, interpersonal and teamwork skills including managing multiple priorities in a dynamic work environment.
• Self-starter and highly motivated to make proactive changes
• Ability to design and write complex SQL code required
• Ability to validate large and complex data sets
• Experience with developing/creating data cubes and/or tabular models
• Demonstrated experience planning, implementing, and maintaining DBMS (installation, configuration, security, performance)
• Able to implement and maintain servers (hardware planning and specifications)
• Able to design, implement, and maintain ETL jobs
• Excellent knowledge of Microsoft Office Suite (Excel, Access, Word, PowerPoint)
• 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?

• Solid knowledge of interRAI suite of tools and the Client Health and Related Information System (CHRIS).
• Knowledge of provincial health care data holdings and methodologies as an asset (DAD, NACRS, CCRS, NRS, OMHRS, HCRS, MIS, iPort, WTIS).
• Experience using development tools such as Visual Studio and Azure Data Studio
• Experience working with version control tools such as Git and Team Foundation Version Control
• Direct knowledge of various query languages i.e., SQL, MDX, XML, DDL, JSON, and/or DAX
• Knowledge of statistical query languages such as Python, R, and/or SAS
• Experience with business intelligence tools such as SQL Server Management Studio (SSMS) / Azure Data Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS), Microsoft Fabric, and PowerBI
• Demonstrated experience of technologies such as SharePoint On-Line lists and/or MS Forms for manual data collection processes
• Direct knowledge of various report/dashboard builders i.e., Microsoft Paginated Reports (SSRS) and/or Power BI
• Proficient in both official languages

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

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.

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.