Job Description

Specialist Data Integration Data Analytics, Reporting & Evaluation

PHSA Corporate

Vancouver, BC

Reporting to the Decision Support Consultant, Information Integration, the Data Integration Specialist provides integrated healthcare data analysis and interpretation to senior leadership, agency committees, departments and external consultants. This role is responsible for opportunity identification, business requirements analysis, design and development of data marts and business intelligence solutions and extension of the Enterprise Data Warehouse. The Data Integration Specialist provides assistance to Performance Measurement & Reporting staff and to data/information creators in other departments with data quality, data manipulation and reporting, data integration (ETL), and data conversion.

What youll 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.

What you bring

Qualifications

• A level of education, training, and experience equivalent to a Bachelors 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.

Skills & Knowledge

• 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.).

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. Thats why were focused on your care too - offering health, wellness, development programs to support you - at work and at home.

• Join one of BCs 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 Sanyas 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
Salary Range: $67,864 - $97,555/year. The starting salary for this position would be determined with consideration of the successful candidates 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: Open Until Filled
Hours of Work: 0900-1700 Monday-Friday
Requisition #: 134023E

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

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

Learn more about PHSA and our programs:

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.

Reconciliation is an ongoing process and a shared responsibility for all of us. The BC Governments unanimous passage of the Declaration on the Rights of Indigenous Peoples Act was a significant step forward in this journey one 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.
Labor Agreement Excluded
Requisition # 134023E-2386822
Work Site 1333 West Broadway, Vancouver BC V6H 1G9
Job Type Regular, Full-Time
Salary/Rate $67,864.00 - $97,555.00 / Year
FTE 1.00
Hours of Work 0900-1700
Work Days Mon, Tue, Wed, Thu, Fri
Expiry Date 13-Oct-2023

Provincial Health Services Authority