Research Data Quality Analyst at St. Michael's Hospital
Toronto, ON — contract
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