Job Description

Specialist, Business Intelligence, Strategic Information Management
BC Mental Health & Substance Use Services
Vancouver, BC

What you\xe2\x80\x99ll do

• Architect and implement analytics solutions to develop, enhance and improve analytics and use of data at various BCMHSUS programs and external stakeholders. This includes leading the design, development, documentation and implementation of complex data marts, multidimensional cubes or other semantic models, reports, dashboards and other front-end interfaces.
• Architect and implement optimal database schemas and ETL solutions to integrate data from various source systems into integrated linked data marts. Collaborates with other members of the team on conceptual design, development, and implementation of the Enterprise Data Warehouse.
• Lead the identification of new data sources and implements data extraction routines from departmental feeder systems. Provides advice and direction on data availability and quality. Consults and problem-solves with feeder departments regarding routine data extracts.
• Participate in the development, definition and reporting of performance indicators as related to program operations, access and throughput, for use at the program director and executive level. Liaises on behalf of the agency with external consultants on the provisioning of patient specific data, as well as providing education on analysis and interpretation.
• Provide technical expertise in the development of Analytics and Business Intelligence solutions by assessing client needs and requirements, reviewing technical options, determining the design and architecture and leading all levels of the solution development and deployment.
• Ensure the designed solutions meet the established architectural, security, and quality standards set by the department by actively engaging peers and leads in design and review processes. Maintains current metadata, definitions and documentation of the solutions.

What you bring

• A level of education, training, and experience equivalent to a Bachelor\xe2\x80\x99s degree in Computer Science, Information Technology, Health Information Science, Management Information Systems or a related field, plus 3 to 5 years of recent BI, data warehousing, data modelling or analytics experience. Strong understanding of health care system operations and public and population health concepts is definite asset.
• Advanced knowledge, and experience in application of best practices of data standards, database design, data architecture and modelling.
• Expertise in developing ETL solutions, relational and multi-dimensional databases and data marts.
• Superior database querying, and query optimization skills using Structured Query Language -preferably T-SQL, MDX or DAX or equivalents
• Knowledge of experience with BI and visualizations tools such as Microsoft Power BI, and Tableau, and collaboration solutions such as SharePoint.
• Proven hands-on experience with standard data warehousing and Business Intelligence tools such as Microsoft SQL Server, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), and related development tools and version control tools, or comparable technologies from other vendors.

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\xe2\x80\x99s why we\xe2\x80\x99re focused on your care too \xe2\x80\x93 offering health, wellness, development programs to support you \xe2\x80\x93 at work and at home.

• Join one of BC\xe2\x80\x99s largest employers with province-wide programs, services and operations \xe2\x80\x93 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\xe2\x80\x99yas 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 (1.00 FTE)
Salary Range: $72,445- $104,139/year. The starting salary for this position would be determined with consideration of the successful candidate\xe2\x80\x99s 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: 4949 Heather Street, Vancouver BC V5Z 3L7
Applications will be accepted until position is filled.
Hours of Work: Monday \xe2\x80\x93 Friday; 0900-1700.
Requisition # 157308

As per the current Public Health Order, full vaccination against COVID-19 is a condition of employment with PHSA as of October 26, 2021.

What we do

(BCMHSUS) cares for people with complex mental health and substance use challenges.

BCMHSUS is part of the Provincial Health Services Authority (PHSA).

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 \xe2\x80\x93 Be compassionate \xe2\x80\x93 Dare to innovate \xe2\x80\x93 Cultivate partnerships \xe2\x80\x93 Serve with purpose.

Learn more about PHSA and our programs:

PHSA and BCMHSUS are committed to employment equity, encouraging all qualified individuals to apply. We recognize that our ability to provide the best care for our diverse patient populations relies on a rich diversity of skills, knowledge, background and experience, and value a safe, inclusive and welcoming environment.

Reconciliation is an ongoing process and a shared responsibility for all of us. The BC Governments\xe2\x80\x99 unanimous passage of the Declaration on the Rights of Indigenous Peoples Act was a significant step forward in this journey\xe2\x80\x94one that all health authorities are expected to support as we work in cooperation with Indigenous Peoples to establish a clear and sustainable path to lasting reconciliation. True reconciliation will take time and ongoing commitment to work with Indigenous Peoples as they move toward self-determination. Guiding these efforts Crown agencies must remain focused on creating opportunities that implement the Truth and Reconciliation Commission Mandate.

ATTN: PHSA Employees:

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

Please note the internal job posting will no longer be accessible after the expiry date of December 22, 2023. 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 604-875-7264 or 1-855-875-7264. Please note regular business hours are Monday \xe2\x80\x93 Friday (excluding stats), 8:30am to 4:30pm. For inquiries outside of regular business hours, please email the Internal Jobs Help Desk at and a Help Desk Representative will contact you the next business day.
Labor Agreement Excluded
Requisition # 157308E-2409930
Work Site 4949 Heather Street, Vancouver BC V5Z 3L7
Job Type Regular, Full-Time
Salary/Rate $72,445.00 - $104,139.00 / Year
FTE 1.00
Hours of Work 0900-1700
Work Days Mon, Tue, Wed, Thu, Fri
Expiry Date 13-Jan-2024

Provincial Health Services Authority