Business Intelligence Analyst, IMITS

Burnaby, Canada

Apply Jump to Job Details

Overview

We enable health services providers to become leaders in providing patient-centered health care, using enterprise standards and frameworks to deliver useful information and clinical tools reliably and consistently, anytime, anywhere. IMITS manages over 300 applications across business, clinical and research environments, serving over 50,000 front line, administrative and research staff to enable over 4.8 million patient encounters a year. As a successful candidate, you will deliver support to enable PHSA, Vancouver Coastal Health (VCH) and Providence Health Care (PHC) to become leaders in providing patient-centered health care. You have initiative, vision, independent thinking and creative problem solving abilities, as well as excellent communication skills.

Job Type: Full-Time, Part-Time, Temporary, Casual, Contractor
Job Level: Entry, Mid, Senior
Travel: Minimal

Success Profile

What does it take to be a successful Laboratory team member at PHSA? Check out the top traits we’re looking for and see if you have the right mix.

Analytical
Communicator
Creative
Focused
Problem Solver
Technologically Savvy

About IMITS

Information Management/Information Technology Services (IMITS) is a service of the Provincial Health Services Authority (PHSA) which plans, manages, and evaluates specialty and province-wide health care services across BC. IMITS boasts a complement of 800 full-time staff who provide tech support and services to 50,000+ staff across PHSA, Vancouver Coastal Health and Providence Health Care. PHSA embodies values that reflect a commitment to excellence. These include: Respect people, Be compassionate, Dare to innovate, Cultivate partnerships, Serve with purpose.

“No two days are the same. It's a lot of analysis, a lot of thinking. If you like to pull things apart and bring them back together and make it something better.”
Shukri Ahmed
Clinical Lead

“I haven't been in any other workplace where the managers or teams have been so supportive of my development or pushing me to try new things.”
John Panzo
Business Analyst, Project Services

Benefits

Benefits vary by job type and are confirmed in the interview and hiring process.

Healthcare

Extended Health and Dental Benefits
Health and Wellness Programs

Discounts to 350 BC-wide recreational programs
Retirement Plans

Enrollment in defined benefit municipal pension plan
Professional Development

The opportunity to grow and advance your skill set in a large scale environment
Work/Life Balance

We encourage "YOU" time for activities that inspire and motivate
Collaboration

Work with individuals bringing expertise from a variety of backgrounds

Job Details

Business Intelligence Analyst, IMITS Burnaby, Canada

Apply

Job ID 2439328_pl355 Date posted 11/07/2025 Job Summary:

In accordance with the Mission, Vision and Values, and strategic directions of PHSA, safety, including both patient and employee safety, is a priority and a responsibility shared by everyone at PHSA. As such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.
The Business Intelligence (BI) Analyst reports to the Manager/Lead and is primarily focused on developing and maintaining “Extract Transform Load” (ETL) solutions. The BI Analyst works closely with colleagues to audit, identify and follow-up on issues related to data quality, metric definitions or process deficiencies. Responsibilities also include database development and monitoring, data modeling, data dictionary development and maintenance, ad-hoc reporting, report development, documentation, maintenance of users and user permissions. The BI Analyst identifies, documents, and resolves issues with data in collaboration with business stakeholders, and supports and liaises with Technology Services regarding hardware and network problems as related to data warehouse and BI environments. This role communicates with staff and stakeholders at all levels to ensure requirements are met.
.

Duties/Accountabilities:

• Designs, develops and maintains databases, ETL, OLAP cubes, reports, dashboards and other BI content as required. Works collaboratively with clients and business analysts to gather requirements, create definitions and specifications and translate into data models, ETL packages and reports as appropriate. Writes ad-hoc queries and reports to support analysts and leaders in data analysis. Creates and maintains report subscriptions for staff and operational leaders across participating organizations.
• Administers the SQL Server databases (data marts) including security, user permissions, performance and usage monitoring. Maintains data quality and ensures data integrity and daily refresh of data warehouse and OLAP cubes and BI content. Maintains lookup tables, writes technical and user documentation, troubleshoots issues with reports, data sources, performance and other related duties. Maintains the reporting environment (SQL SSRS, Tableau, Power BI, SharePoint TeamSites). Ensures that databases, reports and other BI content are developed and maintained in accordance with PHSA Privacy and Confidentiality guidelines.
• Provides first-line support to users for all published BI content. Provides technical and educational support to colleagues and stakeholders and report writers.
• Collaborates with Technology Services, vendors and other teams on hardware and software implementation, upgrades and troubleshooting as it relates to database and BI software and hardware. Communicates with various external clients such as HEABC, Ministry Of Health, and WSBC on definitions, ad hoc queries and regular data/report submissions as directed by stakeholders.
• Evaluates current solutions, researches new and alternative technologies, processes and approaches according to industry best practices.

Qualifications:

A level of education, training, and experience equivalent to a degree or diploma in Information Systems or Computer Science from a recognized program, plus a minimum of three (3) years’ recent related work experience, preferably in a health care environment.
An in-depth working knowledge of relational and multidimensional (OLAP) databases, as well as proven knowledge and experience in working with SQL Server BI stack. Administrative experience including setting up new users, monitoring performance, and query tuning. Effective communication skills, both verbal and written. Excellent analytical skills and ability to turn complex business requirements into analysis ready data-sets, data-marts, cubes or data-models. Knowledge of privacy and confidentiality policies and procedures.
Experience with and ability to develop technical documentation, and understand management reporting and statistical concepts. Demonstrated ability to analyze operational issues and recommend innovative solutions. Self-directed, motivated, and adaptable to new technology including hardware, software, and programming applications. Ability to work on project teams, organize workload, set priorities and meet deadlines in a dynamic environment, and flexibility to multi-task.

Apply