Specialist, Business Intelligence Data Warehouse

Vancouver Island Health Authority; Victoria; On-site; CAD 91,000 - 130,000; Full time

Job summary

Vancouver Island Health Authority in Victoria, BC, seeks a Specialist, Business Intelligence Data Warehouse to lead data modeling, architecture, and operations for our enterprise warehouse. You will design data models, data marts, and ETL processes, ensuring high availability and robust BI infrastructure.

The role requires 5+ years of related experience, Cognos expertise, and strong SQL skills, with travel between sites as needed.

Qualifications

• Bachelor's degree in Computer Science or equivalent; 5+ years in data warehouse environments.
• Experience with MS SQL Server DBA functions, backups, recovery, performance tuning.
• Ability to model data warehouses and manage ETL processes.
• Knowledge of Cognos development and architecture.
• Healthcare data warehouse experience preferred.

Responsibilities

• Develop, manage, and update data models for the data warehouse and data marts.
• Lead architecture, design, implementation, and operations of BI databases and infrastructure.
• Ensure 24/7 availability and support for mission-critical environments.
• Support recovery during outages and lead data quality initiatives.
• Collaborate with stakeholders across departments and IT teams.

Skills

Interpersonal skills

Programming languages

Knowledge transfer

Documentation

Continuous learning

Data standards & admin

HL7/XML/MIS

Cognos

Independent work

SQL querying

Physical ability

Conceptual/technical skills

Business-to-technical translation

Relational/data modeling

Education

Bachelor's Degree in Computer Science

Tools

Azure Databricks

Microsoft Azure

SQL Server

Job description

Specialist, Business Intelligence Data Warehouse - (234384)

Royal Jubilee Hospital (RJH) - Victoria, BC V8R 1J8 CA (Primary)

Work Area (FBA Only)

Multi-Site

Yes

Travel Requirement

Travel between multiple sites may be required

Shift Start Time/End Time

0800-1600, 08:30-16:30

Days Off

Vacancy Type

Temp FT Project

Salary Range (Hourly Rate)

$46.55 - $66.91

Paid FTE

1.0

Worked BI-WEEKLY HOURS

75.0

Planned Start Date

Sep. 21 2026

Approximate End Date (For Temporary Assignments ONLY)

Sep. 21 2027

Pending Return of Incumbent

No

CRC required? (employee will be working with or have access to children or vulnerable adults and requires a Criminal Record Check)

No

Job Description

In accordance with the Vision, Purpose, and Values, and strategic direction of the Vancouver Island Health Authority (Island Health), patient safety is a priority and a responsibility shared by everyone; as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.

Reporting to the Manager, Enterprise Data Warehouse, the Specialist, Business Intelligence Data Warehouse develops, manages, and updates data models, including physical and logical models of the data warehouse, data mart, and staging area, and sometimes the operational data store and source systems. The Specialist is a lead resource responsible for the architecture, design, implementation, and operational support of the Business Intelligence databases, data repositories, and related infrastructure.

The Specialist is accountable for the day-to-day data warehouse environment that includes applications, systems, and services that are mission-critical and requires twenty-four hour support. The Specialist plays a key leadership role in the recovery process in the event of critical system outages.

QUALIFICATIONS:

Education, Training And Experience

A level of education, training and experience equivalent to a Bachelor's Degree in Computer Science and at least five (5) years' recent related experience in areas such as management of data warehouse implementations, performance of MS SQL Server DBA functions including backup and recovery, performance monitoring, performance optimization, disk space utilization, software installation and upgrades, logical and physical data modeling, development of stored procedures, triggers, views, and other database objects, ETL procedures; large scale project management; health care clinical and administrative implementations.

Skills And Abilities

• Effective interpersonal, verbal, and written communication skills.
• Ability to write programs in a variety of programming languages.
• Ability to transfer knowledge and skills to other department staff.
• Ability to provide clear and concise system documentation and procedures for other staff.
• Ability to keep skill set up to date with new technologies as they are introduced to the workplace.
• Data standards, database structures, database server administration.
• Familiarity with HL7, XML, MIS guidelines.
• Strong understanding of Cognos from a development and architecture perspective.
• Ability to work independently and organize workload and priorities with minimal supervision.
• Superior database querying skills including using Structured Query Language.
• Physical ability to perform job.
• Strong conceptual, communications, and technical skills.
• Ability to translate business needs into technical solutions.
• Strong relational and dimensional data modeling and database design skills.

Excellent opportunity to gain hands‑on experience with a large-scale healthcare enterprise data warehouse while supporting key strategic initiatives that enhance health services across British Columbia. Experience with data management in Microsoft Azure and Azure Databricks a benefit.

The salary range for this position is $90,770 (minimum) to $113,462 (midpoint) to $130,481 (maximum) per annum (based on 1.0 FTE). Salary placement is typically between the minimum and midpoint and is determined based on experience, qualifications, and internal equity. BC’s health system is in the process of transformation. As part of the planned changes, certain IM/IT, Finance, and Supply Chain roles are expected to be in scope for transition to a new provincial shared services organization, BC Shared Health Services. Candidates applying to positions in these areas should be aware that, while the role is currently employed by the Health Authority, it may transition to BC Shared Health Services as part of the first or subsequent implementation phases. The intent of this transition is to support continuity of employment however, details regarding timing, process, and any impacts to employment arrangements will be confirmed as planning progresses. Providing this information at the recruitment stage is intended to ensure transparency about the broader system changes underway and to support informed decision-making by candidates.