Job description
What you’ll do
- Supports Performance Measurement and Reporting services in the development and distribution of healthcare data via business intelligence tools. Serves as a technical expert to program managers, physicians and the executive on accessing patient specific data and provides orientation to the tool as required for staff and clients.
- Develops data warehousing infrastructure to enable distribution of complex reports in a more robust way.
- Participates in the development, definition and reporting of patient specific data based performance indicators as related to agency 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.
- Performs database administration tasks including database creation, database tuning, security administration, file management and data replication.
- Performs data administration tasks including the maintenance and integrity of patient specific data infrastructure, modelling the conceptual, logical and physical data architecture, creating value added data elements, and reporting of complex integrated information. Leads the identification of new data sources and implements data extraction routines from departmental feeder systems. Provides advice and direction on patient specific data availability and quality. Consults and problem-solves with feeder departments regarding periodic downloads.
- Oversees routine processing activities within the Performance Measurement and Reporting department related to key decision support applications. Develops and executes detailed, complex database scripts with regard to extraction, transformation, loading and analysis of patient specific data.
- Represents Performance Measurement and Reporting on committees at various levels with regard to data standards, appropriate usage, availability and quality.
- A level of education, training, and experience equivalent to a Bachelor’s degree in Computer Science or Health Information Science/Management from a recognized school plus a minimum of three (3) to five (5) years recent related work experience.
- Ability to apply in-depth subject matter knowledge in a healthcare, science or business discipline to the design of a business intelligence solution. Superior analytical and problem solving skills including the ability to comprehend complex large scale health care environment operational issues and related data/information and present information in concise meaningful ways. Ability to understand and explain complicated technical issues in non-technical terms.
- Advanced knowledge, and experience in application of best practices of data standards, database design, data architecture and modeling. Expertise in developing ETL solutions using SQL Server Integration Services (2008). Superior database querying skills using Structured Query Language -preferably T-SQL. Understanding of report writing tools such as Crystal Reports and SQL Server Reporting Services. Ability and experience in developing technical documentation. Customer focused with ability to facilitate and encourage cooperation between professionals from other disciplines. Ability to educate and lead management staff on the importance of using high quality data for decision making, via business intelligence tools and other means. Demonstrated administrative, organizational, work planning and control skills. Ability to communicate effectively both verbally and in writing. Ability to work under pressure and multi-task with little direct supervision. Persistence and a positive attitude are essential given the iterative development cycle and sometimes problematic data integration issues.
- Commitment to upholding the shared responsibility of creating lasting and meaningful reconciliation in Canada as per TRC (2015) and BC's Declaration on the Rights of Indigenous Peoples Act (2019).
- As a strong asset for consideration, we are looking for our successful candidate to have: Knowledge of social, economic, political and historical realities impacting indigenous communities and familiarity with Indigenous Cultural Safety and anti-racism and accompanying reports (BC DRIPA, TRC, etc.).
- 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.
Salary Range: $67,864 - $97,555 /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 1G9
Closing date: Applications accepted until position is filled
Hours of Work: 0900-1700 (Monday to Friday)
Requisition # 145987E
About Provincial Health Services Authority
CEO: Dr. David Byres
Revenue: $2 to $5 billion (USD)
Size: 10000+ Employees
Type: Non-profit Organisation
Website: www.jobs.phsa.ca
Year Founded: 2001