Specialist Business Intelligence Performance Measurement and Reporting

Specialist Business Intelligence Performance Measurement and Reporting

Decision Support Services
Vancouver, BC

Reporting to the Consultant, Business Intelligence (BI), the Specialist, BI is responsible for providing advanced technical leadership and solution architecture in support of the Business Intelligence (BI) program activities and initiatives.

The position designs leading edge approaches and guides the detailed implementation of these solutions from inception to completion. The position also contributes to the development, implementation and evaluation of training and business process improvement strategies to ensure that the BI environment and the various BI project processes and systems are working efficiently in order to improve transactional and reporting activities.

The Specialist provides input to the overall goals, objectives and operations of the department by providing feedback and recommendations to the Consultant, specifically with respect to Business Intelligence issues. The Specialist works across all levels of PHSA providing leadership and support in the area of Business Intelligence development/maintenance and information reporting via dashboards, scorecards or reports.
What you’ll do

Architect and implement leading edge solutions to develop, enhance and improve the Business Intelligence (BI) Program. This includes leading the design, creation, documentation and implementation of complex multidimensional cubes, reports and front-end interfaces which deliver information via the web to end users.
Provide technical expertise in the development of the Business Intelligence (BI) Program by assessing client needs/requirements, reviewing technical options, determining software architecture and leading all levels of the solution development and deployment. Ensure security and permission levels maintain patient, physician and data confidentiality.
Maintain familiarity with the latest web technologies and an awareness of current information system trends and issues. Evaluate and recommend products or methods to deliver Business Intelligence in an accurate, timely and user friendly manner.
Mentor other developers and team members and provide technical and educational support to Business Intelligence end users by developing training materials, delivering training sessions and training trainers.
Collaborate with members of the Data Integration team on conceptual design of databases and the development and implementation of the Enterprise Data Warehouse. Work with IMITS departmental staff and others to manage and maintain the BI servers and applications including system administration, maintenance and performance monitoring of various servers to ensure optimal uptime and production readiness.

What you bring

Qualifications

A level of education, training and experience equivalent to a Bachelor’s Degree in Health Information Science, Computer Science or Management Information Systems from a recognized school plus a minimum of five (5) years of recent related Business Intelligence (BI) work experience preferably in a healthcare 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 Decision Support Services 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

Expert knowledge and understanding of relational and multidimensional (OLAP) databases as well as proven knowledge and experience in working with SQL Server 2005 or 2008 Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Performance Point, Sharepoint, Visual Studio 2008, etc.
Ability to create and understand complex T-SQL and MDX queries and previous administrative experience setting up new users and monitoring performance. Knowledge of web authoring technology such as JavaScripts, HTML, and ASP .NET, AJAX is also required. High level of expertise in Microsoft Office suite of applications.
Ability to understand management reporting and statistical concepts. Strong analytical, problem solving and system analysis skills. Demonstrated ability to analyze operational problems and recommend innovative solutions. Self-directed and motivated to learn new technology including hardware, software applications, and programming applications.
Ability to work independently with little direct supervision and as a member of a multi-disciplinary team. Excellent time management skills with the ability to organize and prioritize work. Ability to be customer service focused. Excellent interpersonal and communication skills. Physical ability to perform the duties of the job.
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: Temporary, Full-Time (Until December 27, 2027)
Salary Range: $76,111 - $109,409 /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: 1333 W Broadway, Vancouver, BC V6H 1G9Closing date: Applications accepted until position is filledHours of Work: 09:00-17:00 (Monday to Friday)Requisition #: 202164E

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 workforce and 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 [email protected].

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.

Attention current employees of PHSA:

You must apply via your internal profile at http://internaljobs.phsa.ca.

The internal job posting expires on August 5, 2026 and will no longer be accessible. If the internal job posting has expired, please e-mail [email protected] with the six-digit job requisition number and your PHSA employee ID number to be considered as a late internal applicant. Please do not apply for the external job posting.

If you have not yet set up an internal profile, please e-mail [email protected] with your PHSA employee ID number to obtain your temporary password. Our business hours are Monday-Friday 8:30am-4:30pm, excluding Statutory Holidays and a Help Desk Representative will respond to you with 1-2 business days.

If you are not a current employee of PHSA and require assistance with your application, please contact the External Careers team at [email protected].