Data Science Analyst - Data Integration

Job Description

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

Qualifications

• 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.

Additional Information

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 service
• A flexible work environment
• Opportunities for development and promotions within a large organization
• Additional perks (multiple corporate discounts including: travel, restaurants, parking, phone plans, auto insurance discounts, on-site gyms, etc.)

Current UHN employees must have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN's attendance management program, to be eligible for consideration.

All applications must be submitted before the posting close date.

UHN uses email to communicate with selected candidates.  Please ensure you check your email regularly. At University Health Network (UHN), artificial intelligence technologies may be used to assist in the screening, assessment, and selection of candidates for this position.

Please be advised that a Criminal Record Check may be required of the successful candidate. Should it be determined that any information provided by a candidate be misleading, inaccurate or incorrect, UHN reserves the right to discontinue with the consideration of their application.

UHN is an equal opportunity employer committed to an inclusive recruitment process and workplace. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

Compensation: 36.14 to 54.22 (CAD) (HOURLY)