Business Intelligence Analyst, West Alliance Office - Burnaby, Canada - PHSA

PHSA

Verified Company

Burnaby, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Business Intelligence Analyst, WEST Alliance Office
BC Clinical & Support Services

Burnaby, 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 as a member of the management team is primarily focused on transforming data into insights to drive business value and evaluating progress with business goals, such as vendor metrics and performance, as well as developing and maintaining reporting solutions and carrying out analysis for recommendations on changes in services and design.

The BI Analyst works closely with colleagues and the vendor to audit, identify and follow-up on issues related to data quality, metric definitions or process deficiencies.

Responsibilities also include identifying data trends, finding gaps in information as well as asking what is not in the data, creating visualizations that communicate findings, suggesting possible solutions; database development and monitoring, data modeling, data dictionary development and maintenance; and ad-hoc reporting, report development, documentation, maintenance of users and user permissions in support of management decision-making.

The BI Analyst identifies, documents, and resolves issues with data in collaboration with business and vendor stakeholders, and supports and liaises with Technology Services regarding hardware and network problems as related to data warehouse and BI environments.

This role regularly attends and provides updates at management meetings including governance meetings, is privy to sensitive management and vendor information in order to carry out their duties, and communicates with stakeholders at all levels to ensure requirements are met.

What you'll do

Provides business intelligence expertise and functions as a member of the management team to enable senior leadership decisionmaking and to drive value and innovation, including service design and model changes. Analyses and evaluates data; looks for trends, risks, and performance or quality issues; and clearly communicates findings and makes recommendations to achieve strategic direction. Attends and presents at management team meetings, including governance meetings.
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 adhoc 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. Liaises with the vendor to ensure data integrity and availability. Validates 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) as required. Ensures that databases, reports and other BI content are developed and maintained in accordance with PHSA Privacy and Confidentiality guidelines.
Provides firstline support to users for all published BI content. Provides advice, guidance, and 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. Maintains and advances own knowledge of business intelligence tools, methods and best practices.

What you bring

Qualifications:

A level of education, training, and experience equivalent to a Bachelor's degree in Information Systems/Computer Sciences, Business or Statistics from a recognized program, plus a minimum of five (5 years' recent related work experience, preferably in a health care environment.
An indepth working knowledge of relational and multidimensional (OLAP) databases, as well as proven knowledge and experience in working with SQL Server BI stack. Proven ability to balance the line between IT and the business. Effective communication skills, both verbal and written. Excellent ana