Data Science Analyst (Data Integration)

Union: Non-Union Number of vacancies: 1 New or Replacement Position: New  Site: Princess Margaret Research, MaRS South Tower Department: UHN Research Reports to: Principal Investigator Hours: 37.5 hours per week Shifts: Monday-Friday Salary Range: $36.14 - $54.22 per hour Status: Temporary Full-time (12-months) Closing Date: November 13, 2026 Position Summary As part of the Structural Genomics Consortium, the  Centre for Collaborative Drug Discovery (C2D2) and the international Target 2035 community, our open science drug discovery pipeline span protein production, biophysical screening, chemistry and structural biology, across partner laboratories on five continents. The data and reagents generated are placed in the public domain without patent restriction. The pipeline is tracked end to end by an in-house Laboratory Information Management System (PHP, Python, PostgreSQL), developed and maintained by our senior database developer. As additional partner sites join the consortium, the work of integrating each site - mapping its records to the LIMS schema, migrating its legacy data and supporting its users - has grown beyond the capacity of a single position. The Data Science Analyst (Data Integration) will support the senior database developer, with primary responsibility for site onboarding and cross-site data integration. This is a full-time, one-year contract position reporting to the Principal Investigator. Duties • Onboard new contributing sites: map existing records to the LIMS schema, migrate legacy data, and verify data integrity following transfer • Develop and execute data loading procedures, including bulk imports, format conversions and scheduled transfers • Reconcile database identifiers and controlled vocabularies between incoming data and the LIMS, referring structural conflicts to the senior database developer • Monitor automated data feeds and resolve failures • Provide support and training to partner-site users, and maintain user documentation • At minimum, Bachelor's degree in computer science or a related discipline, required • At least one (1) year of practical and related experience, required  • Working proficiency in SQL (PostgreSQL preferred), Python and PHP for data transformation • Familiarity with CSV/Excel, JSON, REST APIs and scheduled file transfer, required  • Demonstrated attention to data integrity, including systematic verification of completed data transfers • Ability to communicate effectively with non-technical users across multiple time zones • Availability for approximately three to five international trips over the contract term, of three to five days each, to partner sites in Germany, Brazil, the United Kingdom, India and Australia; a valid passport and eligibility to obtain the applicable entry authorizations are required • Experience with scientific or laboratory data systems (LIMS, ELN, instrument software, research databases) • Familiarity with early-stage drug discovery data, including compounds, assays and structures • The position is well suited to a candidate in the early stages of their career. Applications are welcome from candidates who meet most, though not all, of the required qualifications. Why join UHN? In addition to working alongside some of the most talented and inspiring healthcare professionals and researchers in the world, UHN offers a wide range of benefits, programs and perks. It is the comprehensiveness of these offerings that makes it a differentiating factor, allowing you to find value where it matters most to you, now and throughout your career at UHN. • Competitive offer packages • Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https://hoopp.com/ ) • Close access to Transit and UHN shuttle servic