Research Data Quality Analyst GEMINI Data Ops

St. Michael's Hospital; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

St. Michael's Hospital is seeking three Data Quality Analysts to join the GEMINI team, supporting analytics and data quality improvement initiatives. The role involves data processing, ETL pipeline management, and engagement with stakeholders to ensure high-quality healthcare data. Join a collaborative team driven to enhance patient care through advanced data management techniques.

Qualifications

• At least 2 years of experience with R.
• At least 1 year of experience with SQL.
• Experience working independently and in teams.

Responsibilities

• Conduct pre-processing checks on raw data collected from hospitals.
• Perform quality control checks to ensure data is complete.
• Write HTML/PDF/Microsoft Word reports summarizing the analysis.

Skills

Data Processing

Data Visualization

Programming

Attention to Detail

Communication

Education

Bachelor’s degree in Computer Science, Statistics/Biostatistics, or related discipline

Tools

R

SQL

Linux/Unix

MS Office

git

Job description

Data Quality Analyst – GEMINI

GEMINI (www.geminimedicine.ca) is a unique big data platform in the Canadian healthcare landscape using advanced methods and analytics to extract and standardize data captured in hospital electronic health records. GEMINI currently exists at 30+ ON hospitals, where we have collected data on over 2 million hospital admissions across more than 30 hospitals. The GEMINI data platform supports the Ontario General Medicine Quality Improvement Network (GeMQIN), a provincial network led by Ontario Health to improve care for general medicine hospital patients. GEMINI is a collaborative data and analytics platform for all Ontario hospitals to accelerate research and quality improvement, leading to excellent hospital care.

We are looking to hire three Data Quality Analysts to join the GEMINI team and help develop a truly unique data platform in the Canadian healthcare landscape. The Data Quality Analysts will support and write reproducible code for GEMINI’s data pipeline, including conducting quality checks, formatting, validating, and standardizing data from multiple sources, supporting administrative tasks, performing descriptive analyses, and optimizing and retrieving data from our internal databases.

We seek candidates with excellent data processing skills, experience working with large datasets and databases, programming expertise, a strong understanding of the Canadian healthcare environment, and an aptitude for data visualization. You will join a dynamic, fun, and mission-driven team of clinicians, researchers, and quality improvement experts. Strong interpersonal and communication skills are essential.

This is a one-year contract position with the possibility of renewal.

Duties And Responsibilities

1. Data Processing and Analysis (80%)

• Conduct pre-processing checks on raw data collected from hospitals to align with GEMINI’s data reference model.
• Perform quality control checks following standard operating procedures to ensure data is complete and of high quality.
• Lead data processing workflow.
• Pre-process raw data, including formatting and merging data from multiple sources, and understanding overall data quality.
• Standardize and harmonize data from data sets to prepare for loading into the database.
• Write HTML/PDF/Microsoft Word reports summarizing the analysis.
• Create and modify R code as required.
• Identify and correct syntax and programming logic errors in R code.
• Respond to ad-hoc requests from the GEMINI team.

Design and maintain real-time ETL pipelines to extract, transform, and load streaming data from multiple sources.

Process and transform healthcare data formats including HL7 messages and JSON files.

Data Administration (20%)

• Maintain and update standard operating procedures and related documents to support data processing.
• Engage with stakeholders to clarify data quality issues.
• Notify managers and data scientists of issues and errors with code/analysis.
• Write documentation and contribute to project code repositories for reproducibility.
• Participate in code review meetings.
• Support GEMINI’s data operation needs.
• Explain database capabilities and limitations to researchers and stakeholders.

Qualifications

• Bachelor’s degree in Computer Science, Statistics/Biostatistics, or related discipline.
• At least 2 years of experience with R.
• At least 1 year of experience with SQL.
• At least 1 year of experience working in a Linux/Unix environment.
• Excellent attention to detail and ability to learn new skills.
• Experience working independently and in teams.
• Strong organizational skills to manage multiple tasks.
• Ability to adapt to changing priorities.
• Excellent written and oral communication skills.
• Experience manipulating large datasets from multiple sources.
• Proficiency with MS Office software.
• Experience with healthcare data and cloud platforms is an asset.
• Experience with git is an asset.

Unity Health Toronto is committed to creating an accessible and inclusive organization. We support accommodations during the recruitment process as per AODA and the Ontario Human Rights Code. Please inform us of your needs at any stage.