Specialist Data Integration Data Analytics, Reporting & Evaluation
Provincial Health Services Authority View all jobs
- Vancouver, BC
- Permanent
- Full-time
- 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.
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.
Labor Agreement Excluded
Requisition # 197028E-2447280
Work Site 1333 West Broadway, Vancouver
Job Type Regular, Full-Time
FTE 1.00
Hours of Work 800-1600
Work Days Mon, Tue, Wed, Thu, Fri
Expiry Date 02-May-2026