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
Design, develop and maintain databases, ETL, OLAP cubes, reports, dashboards and other BI content as required. Work collaboratively with clients and business analysts to gather requirements, create definitions and specifications and translate into data models, ETL packages and reports as appropriate. Write ad-hoc queries and reports to support analysts and leaders in data analysis. Create and maintain report subscriptions for staff and operational leaders across participating organizations.
Administer the SQL Server databases (data marts) including security, user permissions, performance and usage monitoring. Maintain data quality and ensure data integrity and daily refresh of data warehouse and OLAP cubes and BI content. Maintain lookup tables, write technical and user documentation, troubleshoot issues with reports, data sources, performance and other related duties. Maintain the reporting environment (SQL SSRS, Tableau, Power BI, SharePoint TeamSites). Ensure that databases, reports and other BI content are developed and maintained in accordance with PHSA Privacy and Confidentiality guidelines.
Provide first-line support to users for all published BI content. Provide technical and educational support to colleagues and stakeholders and report writers.
Collaborate 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. Communicate 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.
Evaluate current solutions, research new and alternative technologies, processes and approaches according to industry best practices.
What you bring
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.
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.
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 and development.
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 (12) with generous vacation entitlement and accruement.
Flexible work options including flextime, work locations and job sharing (eligibility will vary)
Perks include access to fitness classes and discounts to 350 BC-wide recreational programs, travel, technology, car and bike sharing, and more.
Job Type: Regular Full-Time
Location: 1795 Willingdon Ave. Burnaby, BC
Closing date: Open until position is filled
Hours of Work: Monday to Friday 08:30 – 16:30
Requisition # 110428E
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 – Cultivate partnerships – Serve with purpose.
Learn more about PHSA and our programs: jobs.phsa.ca/programs-and-services
PHSA is 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.