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 40+ ON hospitals, where we have collected data on over 3 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 Analyst 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 are looking for a candidate with excellent data processing skills, demonstrated experience working with large datasets and databases, programming skills, strong understanding of the Canadian healthcare environment, and an aptitude for data visualization. You will be joining a dynamic, fun and mission-driven team of clinicians, researchers, and quality improvement experts. Strong interpersonal and communication skills will be an important asset in this role.
This is a one-year contract position with the possibility of renewal.
Duties and Responsibilities:
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 which includes formatting and merging data from multiple sources, as well as understanding overall data quality
Standardize and harmonize data from data sets to prepare for loading into database
Write HTML/PDF/Microsoft Word reports summarizing the analysis
Create and modify R code as required
Efficiently identify and correct syntax and programming logic errors in R code
Responds to ad-hoc requests from 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 assist with writing/updating standard operating procedures and other documents to support data processing work
Engage with stakeholders to clarify data quality issues
Notify manager and data scientists of any issues and errors with code/analysis
Write documentation and contribute to project code repositories so that all work is reproducible
Attend code review meetings to discuss any problems/solutions to project code bases
Support GEMINI’s data operation needs
Explains capabilities and limitations of databases and information to researchers and other stakeholders
Qualifications:
Bachelor’s degree in Computer Science, Statistics/Biostatistics and/or related discipline
At least 2 years of experience with R
At least one year of experience with SQL
At least one year of experience working in a Linux/Unix environment
Excellent attention to detail and proven ability to learn new skills
Experience working independently and as part of a team
Excellent organizational skills to manage multiple tasks in a timely manner
Demonstrated the ability to adapt and manage changing priorities
Excellent written and oral communication skills
Experience working with and manipulating large datasets including merging and analyzing data from multiple sources
Proficient with MS Office software (Word, Excel, PowerPoint, Outlook, etc.)
Experience with healthcare data is an asset
Experience with git is an asset
Experience with cloud-based database platforms (AWS RDS/DynamoDB, Google Cloud SQL/Firestore, Azure SQL Database) is an asset
Unity Health Toronto is committed to creating an accessible and inclusive organization. We strive to provide a recruitment process that is barrier-free and in compliance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code. We understand that you may require an accommodation at any stage of the recruitment process. When you are contacted, please inform the Talent Acquisition Specialist and we will work with you to meet your accommodation needs. We want to emphasize that all accommodation requests are handled with the utmost confidentiality, respecting your privacy and dignity.
