Data Analyst, Clinical Division

Job Summary:

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’s Agencies/Divisions/Services, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.
The Clinical Division of BC Clinical and Support Services (BCCSS) includes the Agency for Pathology and Laboratory Medicine (Agency) and the Provincial Blood Coordinating Office (PBCO). The Agency has been established to provide oversight and service planning for diagnostic lab services within the province. The Agency has a mandate to ensure that clinical laboratory diagnostics are quality driven, achieve excellent clinical outcomes, and remain sustainable by being provided effectively and efficiently. The PBCO has responsibility to provide and coordinate provincial blood and blood product utilization programs, and to manage specialized provincial resources.
Reporting to the Provincial Lead, the Data Analyst is responsible for producing information products for decision support. This includes: formulating the information requests; performing queries and data extraction from relevant databases, checking data quality; analysis and modelling; interpreting the data; preparing reports and visualizations; and presenting the information and findings for administrative and operational decision making. The Analyst is also responsible for checking for data quality throughout the continuum, statistical analysis, and generating routine and ad hoc reports for internal and external stakeholders including but not limited to BCCSS, the Ministry of Health (MoH), care providers in the BC Health Authorities, Canadian Blood Services, and the Public Health Agency of Canada.

Duties/Accountabilities:

• Receives and facilitates internal and external data requests for planning, policy making and research purposes by engaging with the stakeholders, understanding the information needs and reviewing data information requested.
• Performs the necessary analysis including: data extraction and queries; ensuring data quality (checking and cleaning); data manipulation, linkage and aggregation; and statistical analysis and modelling
• Produces information findings through regular and ad hoc reports and dashboards using business intelligence and reporting software. These information products may monitor and benchmark costs, utilization and other quality and performance indicators for transfusion medicine, laboratory medicine and pathology, and other clinical areas.
• Interprets these findings and provide advice and recommendations.
• Presents findings to different audience (ex: clinicians, operational staff, administrators and patients) at an appropriate level
• Provides support for the development and maintenance of data collections such as databases, spreadsheets, reports and other relevant applications.
• Write SQL and other programming code to perform queries and analysis.
• Provides statistical analyses and/or modeling for internal and external use such as time series, regressions, data mining and simulation model.
• Creates, implements and performs routine data quality reviews and audits on data registries and web applications.
• Utilizes reporting and business intelligence applications such as JReport and Tableau. This involves creating and adding new reports, users and groups to the system and ensuring a proper privilege framework is in place for all users.
• Provides day-to-day support working with database such as ad-hoc querying and providing periodic insertions of information submitted by partner agencies.
• Generates proper technical documentation on the current reporting environment and on all reports and data extracts.
• Performs other related duties as required.
Working Relationships
• Communicates findings in a meaningful manner to internal staff and external stakeholders at the local, regional, provincial and national levels.
• Consults internal stakeholders to gather report specifications; identifies and provides advice to internal stakeholders about data limitations and ensures adequate data quality for analytical purposes.
• Participates in the preparation and presentation of educational material related to statistical data collection to internal and external stakeholders. Provides training to other internal staff as required.
Leadership
• Not responsible for managing or overseeing a team.
• Provide advice and recommendations to leadership.
Decision-Making
• Retrieves and extracts data, analyzes and summarizes statistical information, performs complex calculations and tallies.
• Understands and evaluates the limitations of the data, analyses and statistical calculations.
• Interprets the data and information, and its potential applicability.
• Propose alternative methods to obtain, extract and analyze data to improve data quality and decision support.
• Chooses the most appropriate method to disseminate findings (ex: reports, presentations, other visualizations).
Budget
• No responsibility.

Qualifications:

Education, Training and Experience
A level of education, training, and experience equivalent to or greater than a Bachelor’s Degree in Health Informatics, Math, Statistics, Computer or Health Science, Operations Research or Data Science, or a related program with a minimum of five to seven years of recent related experience working with health and statistical information in a sophisticated computer environment.
Minimum of five years of work experience including the use of Structured Query Language (SQL) and working with data warehousing, integration, mining and report writing, such as Business Objects / SAP BI / SPSS / Cognos / Oracle BI/ Jreport or other Statistical / Analytical / Visualization tools such as Tableau/R/SAS).
Knowledge, Skills and Abilities
• Demonstrated ability to perform data manipulation, analysis and information presentation at a moderate to advanced level through the use of database, spreadsheet and statistical software. Moderate to advanced data management skills and a high degree of computer literacy are required.
• Superior analytical and problem solving skills, including the ability to troubleshoot, comprehend, analyze and resolve complex issues.
• Moderate to advanced knowledge of relational database modeling and query writing tools to create ad-hoc queries and reports.
• Demonstrated ability to develop complex and customized SQL queries for relational databases, with applied experience with business intelligence tools (ex: Tableau, IBM Cognos, SAP BusinessObjects)
• Knowledge of descriptive statistics, statistical inference and modeling using statistical software such as SPSS, R and/or SAS.
• Demonstrated ability to communicate effectively both verbally and in writing
• Strong interpersonal skills and collaboration skills and the ability to establish and maintain effective working relationships internally and externally.
• Excellent organizational skills, attentive to detail with the ability to multi-task and prioritize workload and work quickly and accurately under pressure to meet deadlines.