Database Analyst (MT0604, IST2F, GR5)

Job Category: 
Term positions for management and excludeds

Position Summary

The Canadian Center for Computational Genomics (C3G) at McGill University C3G offers a stimulating and rewarding working environment, where projects bring concrete contributions to the advancement of research in fields such as human health and the environment. Our team is composed of people that are passionate about what they are doing, and that work with cutting edge sequencing technologies and high performance computing equipment. Learn more about why McGill is an exciting place to work: https://www.mcgill.ca/careers/why-mcgill.

C3G develops customized and case-by-case bioinformatics solutions as well as an extensive suite of open-source software, including bioinformatics analysis pipelines (bitbucket.org/mugqic/genpipes) used by multiple academic institutions, and many data access and analysis portals. Since 2011, C3G has completed more than a thousand bioinformatic analysis projects for over 600 distinct groups of researchers across Canada.

Under the supervision of a Bioinformatics Manager, the Database Analyst will plan, implement and maintain local and public web-based databases, to solve challenges arising from the management and analysis of scientific data, fulfilling C3G’s engagements towards Open Science. Short development cycles will involve small but frequent data and application releases, and constant interactions with the bioinformatics platform team members.

Duties and Responsibilities

  • Organize and maintain large sets of data and metadata for projects in genomics, epigenomics and other life science-related fields;
  • Participate in all key points of the data handling process, at the levels of ingestion, discovery and retrieval;
  • Maintain and improve existing data models to reflect recent experimental technological advances, following metadata organization best practices.
  • Setup and maintain automation tools for databases sanity checks and testing;
  • Follow internal and community-established conventions for data storage and exchange;
  • Through the development and usage of quality control scripts, software and pipelines, abstract user-submitted data and metadata, and oversee its quality.
  • Implement curation tools that are reusable by other curators and the rest of the C3G team;
  • Serve as a contact point, through helpdesks and mailing lists, for the research community, to facilitate deposition and acquisition of data from our databases and applications;
  • Create user documentation, reports and demonstration material on tools and services usage;
  • Ensure software development is done by following the best coding practices, including proper code commenting, unit testing, etc. ;
  • Make use of an issue tracking system to document tasks, issues and bugs, and their resolution status;
  • Run existing bioinformatics analysis pipelines on submitted data, and contribute to the development of new pipelines for data curation purposes.

Education and Experience

Undergraduate Degree

Three (3) years’ related experience

Other Qualifying Skills and Abilities

Undergraduate or graduate degree in computer science, engineering. bioinformatics or related field with three to five years of relevant work experience preferred. Knowledge in the field of genetics and bioinformatics, high-throughput experimental methodologies and with large genomic databases; Prior experience generating and curating genomic datasets and/or bioinformatics analysis experience is a plus; .Familiarity with the use of controlled vocabularies and ontologies to describe biological concepts; Experience with some web application frameworks on the front and back end, such as Flask, React, NodeJS.; Experience with applications containerization (e.g. Docker, Singularity); Experience with the Git version control system.; Experience with creating, querying and maintaining relational databases (RDBMS), such as MySQL and Postgre.; Experience with server-side scripting, such as Python, Perl, Bash.; Excellent attention to details; Excellent communication and organizational skills and ability to work in a highly interactive group; Open mind towards new technologies, having at least basic knowledge of the various layers involved in public databases and application; Capable of getting multiple tasks assigned at once, and making them all progress steadily. English and French, spoken and written.

How to Apply

Please submit your application online at http://www.mcgill.ca/medhr/positions-available/apply-now

Click on “APPLY NOW” and clearly indicate the reference number.

The deadline to apply for this position is February 21, 2019 at 5:00 PM.

*Current employees: please indicate your McGill ID number in your application.*

We thank all applicants for their interest in McGill University. However, the Faculty of Medicine will only contact applicants selected for an interview.

Employment Equity

McGill University hires on the basis of merit and is strongly committed to equity and diversity within its community. We welcome applications from racialized persons/visible minorities, women, Indigenous persons, persons with disabilities, ethnic minorities, and persons of minority sexual orientations and gender identities, as well as from all qualified candidates with the skills and knowledge to productively engage with diverse communities. McGill implements an employment equity program and encourages members of designated groups to self-identify. Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, Professor Angela Campbell, Associate Provost (Equity and Academic Policies) at angela.campbell [at] mcgill.ca or 514-398-1660

Faculty/Unit: 
Faculty of Medicine
Salary Range: 
(Grade 05) $56,000 - $70,000 (midpoint) - $91,000
Hours: 
33.75
Duration: 
Twelve (12) months
Reporting to: 
Bioinformatics Manager
Reference no.: 
MT0604