Business Intelligence Analyst, PDHIS

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

• 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.
• Demonstrated knowledge of the historic and ongoing impacts of settler colonialism on Indigenous Peoples in social and health contexts, including supported by significant knowledge of Indigenous-specific mandates, including clear understanding of and commitment to eradicate Indigenous-specific racism and discrimination and embed Indigenous Cultural Safety and Humility.
• Demonstrate comprehensive knowledge of the historic and ongoing impacts of settler colonialism and systemic racism on Indigenous Peoples within social and health contexts. This includes understanding how these factors contribute to current health disparities and barriers to care. Show a clear commitment to identifying, challenging, and eradicating Indigenous-specific racism and all forms of discrimination impacting equity-deserving groups within health care settings. This involves familiarity and understanding Indigenous Cultural Safety and Humility recognizing personal biases, institutional barriers, engaging in anti-racism education and training and advocating for systemic change.
• Demonstrated knowledge and understanding of legislative obligations and provincial commitments within Occupational Healthy & Safety contexts found in the foundational documents including 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 - BC Human Rights Code, BC Anti-racism Act and how they intersect across the health care system.

Core Competencies

• Brings an understanding of the Indigenous specific racism and the broader systemic racism that exists in the colonial health care structure, and has demonstrated initiatives in breaking down barriers and ensuring a safe environment ensuring a sense of belonging to all and informed by Indigenous Cultural Safety.
• Awareness of social, economic, political and historical realities of settler colonialism on Indigenous Peoples and familiarity with addressing Indigenous-specific anti-racism, anti-racism and Indigenous Cultural Safety and foundational documents and legislative commitments (the Declaration Act, the Declaration Action Plan, TRC, IPS, Remembering Keegan, etc.).

Skills & Knowledge

• 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.
• Demonstrates a commitment to beginning and/or continuing their personal learning journey related to Indigenous-specific racism and dismantling systems of oppression, as well as addressing racism more broadly. Shows willingness to articulate and share their learning experiences to contribute to a culture of motivation and inspiration among peers.
• Demonstrates foundational knowledge of the social, economic, and political realities of settler-colonialism and its impacts on Indigenous peoples and equity-deserving groups within social and health contexts. Understands the impact of social determinants of health-on-health outcomes. Shows a commitment to learning about and upholding legislative obligations and provincial commitments outlined in foundational documents such as 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, Remembering Keegan: A First Nations Case Study, the BC Human Rights Code, Anti-Racism Data Act, and the Distinctions Based Approach.

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.

• Join one of BC’s largest employers with province-wide programs, services and operations – offering vast opportunities for growth, development, and recognition programs that honour the commitment and contribution of all employees.
• Access to professional development opportunities through our in-house training programs, including +2,000 courses, such as our San’yas Indigenous Cultural Safety Training course, or Core Linx for Leadership roles.
• Enjoy a comprehensive benefits package, including municipal pension plan, and psychological health & safety programs and holistic wellness resources.
• Annual statutory holidays (13) with generous vacation entitlement and accruement.
• PHSA is a remote work friendly employer, welcoming flexible work options to support our people (eligibility may vary, depending on position).
• Access to WorkPerks, a premium discount program offering a wide range of local and national discounts on electronics, entertainment, dining, travel, wellness, apparel, and more.

Job Type: Regular, Full-time

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 (PHSA) 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: jobs.phsa.ca/programs-and-services

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 B.C. 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.employment@phsa.ca.

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.

ATTN: PHSA Employees:

To be considered as a PHSA employee (internal applicant) for this position, you must apply online via your internal profile at internaljobs.phsa.ca

Please note the internal job posting will no longer be accessible after the expiry date of November 14, 2025. If the internal job posting has expired, please contact the Internal Jobs Help Desk and advise that you would like to be considered as a late internal applicant for this position. Please do not apply for the external job posting.

If you have not registered your internal profile, a password is required to log in for the first time. To obtain your password, please contact the Internal Jobs Help Desk at internaljobshelpu@phsa.ca. Please note regular business hours are Monday – Friday (excluding stats), 8:30am to 4:30pm. A Help Desk Representative will respond to your inquiry within 1-2 business days.