Business Intelligence Analyst Jobs

This position is responsible for collecting, consolidating and analyzing data queried from large data sets and multiple data sources. The Business Intelligence (BI) Analyst will develop, disseminate and present information requiring low to moderate complexity analysis to support operational, management and strategic decision making for delivery of home and community care. The BI Analyst will also educate and train others in the understanding and use of information.

Key Responsibilities

• Provides data, reports, analysis and interpretation of information to support home and community care operations, HCCSS management reporting including scorecards, dashboards and indicators, HCCSS strategic projects and external reporting requirements.
• Other duties as assigned.
• Presents results of analysis and interpretation to internal audiences.
• Identifies gaps in current availability and accessibility of information, defines, and implements solutions to close the gaps.
• Develops and maintains tools and BI infrastructure including database and Visual Studio objects, worksheets, and cubes to support efficient self-serve access to reports and information.
• Develops and implements educational tools and materials to facilitate the use of information as a strategic resource.
• Collaborates closely with other teams, Managers and Directors to understand and inform their information needs and priorities.
• Ensures data integrity and compliance throughout the project life cycle.
• Supports definition, development and reporting of key indicators for home and community care performance management, quality improvement and accountability reporting.
• Performs "ETL" programming to extract, transform and load data from source databases into data warehouses.
• Participates in quality assurance/software testing of provincial initiatives to ensure the solution meets the identified requirements.
• Extracts, aggregates and analyzes data from multiple sources including large SQL databases.
• Provides integrated financial, statistical, and clinical information to support evidence-based decision-making.
• Develops and maintains an expert understanding of the content, quality, sources and meaning of data in home and community care and health system data holdings.
• Educates and trains others in the understanding and use of information.
• Provides support for BI and cross-functional projects, ensuring BI requirements are considered in decisions about business processes or data standards.

Patient Safety

• Supports patient safety culture by ensuring work completed recognizes the safety of the patient(s).

Risk Management

• Follows safe practices related to the security and privacy of information.
• Reports risks with causes, impacts or mitigations beyond scope of responsibility to management.

Health & Safety

• Must adhere to the duties of workers, as stipulated in Section 28 of the Occupational Health and Safety Act.
• Must adhere to all HCCSS NSM administrative and applicable occupational health and safety policies, procedures and protocol.

Position Requirements

Education

• University degree or college diploma in computer science, data management or related field

Experience / Knowledge

• Knowledge of the interRAI suite of tools and experience with the HCCSS Client Health and Related Information System (CHRIS) an asset.
• Aptitude and interest in Python, .NET technology, MSL/XSLT, or JavaScript an asset.
• Experience with the manipulation and extraction of information from large data holdings.
• Experience with SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analytical Services (SSAS) preferred.
• Excellent computer skills including databases, SQL queries, and programming. Data base design an asset.
• Experience with provincial Management Information Systems (OHRS/MIS) and Geographic Information Systems software an asset.
• Demonstrated abilities in data interpretation and analysis, and report generation.
• Knowledge of the health system and health patient information systems an asset.
• Strong problem solving, analytical and critical thinking skills.
• Skills with statistical tools and methods an asset.

Competencies

• Experience with ETL development and configuration; design and development of OLAP cubes an asset.
• Strong verbal and written communication skills. Demonstrated ability to collate and analyze data and present information in easily understandable and actionable forms.
• Excellent knowledge of Microsoft Office suite (Excel, Work, PowerPoint).
• Effective communication with internal and external stakeholders which includes respecting and valuing others, active listening and facilitating healthy relationships.
• Exceptional technical skills related to working with large data sets.
• Proficiency in French is an asset.
• Excellent organizational, interpersonal and teamwork skills including managing multiple priorities.
• Customer service philosophy.