Business Intelligence Analyst, PDHIS

Job ID 2439328_pl355 Date posted 11 / 07 / 2025

Business Intelligence Analyst, PDHIS

Occupational Healthy & Safety

Vancouver, BC

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.

What you’ll do

• 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.

What you bring

Qualifications

Core Competencies

Skills & Knowledge

What we bring

Every PHSA employee enables the best possible patient care for our patients and their families. Whether you are providing direct care, conducting research, or making it possible for others to do their work, you impact the lives of British Columbians today and in the future. That’s why we’re focused on your care too – offering health, wellness, development programs to support you – at work and at home.

Salary Range : $74,618- $107,264 / year.  The starting salary for this position would be determined with consideration of the successful candidate’s relevant education and experience, and would be in alignment with the provincial compensation reference plan. Salary will be prorated accordingly for part time roles.

Location :   1795 Willingdon Avenue, Burnaby BC V5C 6E3

Closing date :   Applications accepted until position is filled

Hours of Work :   08 : 30-16 : 30 (Monday to Friday)

Requisition # :   191169E

What we do

The Provincial Health Services Authority () plans, manages and evaluates specialized health services with the BC health authorities to provide equitable and cost-effective health care for people throughout the province. Our values reflect our commitment to excellence and include : Respect people – Be compassionate – Dare to innovate – Create equity – Be courageous.

Learn more about PHSA and our programs :

PHSA is committed to anti-racism and equity in our hiring and employment practices. With learning and compassion, we are addressing existing inequities and barriers throughout our systems. PHSA is seeking to create a diverse workforceand to establish an inclusive and culturally safe environment. We invite applications and enquiries from all people, particularly those belonging to the historically, systemically, and / or persistently excluded groups identified under the Human Rights Code.

One of PHSA’s North Star priorities is to eradicate Indigenous-specific racism, which includes ongoing commitments to Indigenous recruitment and employee experience as well as dismantling barriers to health care employment at every level. We welcome Indigenous individuals to apply and / or contact the Sanya’k̓ula Team (Indigenous Recruitment & Employee Experience) for support at .

Indigenous-specific anti-racism initiatives are rooted in addressing the unique forms of discrimination, historical and ongoing injustices, and exclusion faced by Indigenous peoples. These initiatives align with an Indigenous rights-based approach, recognizing the inherent rights and title of BC First Nations and self-determination of all First Nations, Inuit and Métis communities. PHSA is mandated to uphold legislative obligations and provincial commitments found in the foundational documents including the Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan and Remembering Keegan : A First Nations Case Study.