Database Warehouse Developer

Job Responsibility:

Please note this role will work in a hybrid environment. The successful candidate will be working out of one of the following locations: Brampton, Toronto, Calgary, Winnipeg, or Vancouver, with a mixture of on and off-site work based on the parameters for our operations to meet the needs of our donors, our staff and our communities. Currently, employees are expected to have an in-person presence for at least 40% of their work time. This requirement may vary depending upon circumstances.

Job category: Information technology Job posting ID: 5277

Employment status: Temporary full-time Position's anticipated start date: 2023-12-18 Position's anticipated end date: 2024-12-30

Classification: PTS/MGT/IT B Salary/Rate of pay: $67,000 - $79,500

Application deadline: 2023-11-29 Please save a copy of the job posting, once the application deadline has passed, it will no longer be available.

Do you currently work for Canadian Blood Services? All employees must apply via the internal career page .

Together, we can make all the difference in the lives of others.

Be part of a dynamic, collaborative and caring organization committed to saving and improving lives. Thousands of patients depend on us every day for reliable access to safe blood, plasma, stem cells and organs and tissues.

If you are looking for a rewarding experience with a values and mission-driven team, join Canada's Lifeline and make a meaningful difference.

We acknowledge that the work of Canadian Blood Services spans many Territories and Treaty areas across the country, and we are grateful for the Traditional Knowledge Keepers and Elders who have guided us in this important work. We recognize the land and waters that have inspired our work and offer gratitude to those Indigenous peoples on whose territory we work, live and play.

About the role Canadian Blood Services is looking for a Temporary full-time Database Warehouse Developer to join our dynamic Donor Relations Supply Chain-Testing team.

The Donor Relations Supply Chain-Testing team is responsible for performing testing on donor samples and patient samples, providing national reference testing for antibody identification, genotyping, and HLA matched platelets, in addition to providing QC testing on blood component products.

In this role, you will be designing prototypes and deploying data infrastructures associated with Extract Transform Load (ETL) and analytics processes to prepare data for analytical or operational uses. You will support ETL, cloud analytics and classification algorithm deployment in Azure to integrate data from different sources, to deploy software solutions that will establish optimal technical setup that aligns with Canadian Blood Services regulatory, privacy and digital security framework.

Formula for success

• Leveraging your knowledge and expertise with Azure, you will integrate, transform, and consolidate data from various data systems into structures that are optimal for building analytics solutions, and craft codes that meets Canadian Blood Services' standards for style, maintainability, and best practices.
• Utilizing your exceptional attention to detail, and analytical skills you will ensure all data pipelines and data repositories are high-performing, efficient, organized, and reliable, by frequently testing and documenting the developed products.
• With your desire for excellence, you will design and develop database, API and UI solutions to store, interact with, query and report on high-throughput molecular-level blood-type data generated at Canadian Blood Services.
• Drawing on your proven ability for design and implementation, you will establish internal databases to store, query, intersect and interact with data from various sources (clinical, genomic, LIS, etc.), as well as build external public reference databases of blood group alleles,,
• With your excellent ability to build solid working relationships, you will work closely with Canadian Blood Service medical, bioinformatics and Information Technology staff to assist in the systematic molecular blood group data review and contribute to publications.
• Leveraging your continuous growth mindset, you will, train clinical staff, be an effective participant in PFx processes for procurement, and openly advise laboratory management on any operational gaps, challenges, and opportunities within scope of practice.

Desired education and skills

• Bachelor or Master's degree in a computer science or related field is required.
• Certified engineer for cloud-Distributed systems (i.e. Azure, Databricks, PowerBI, etc.) is required.
• Minimum of 3 years' experience working in clinical, or research setting related to laboratory information systems and data management is required; however, an equivalent combination of education, training and experience may be considered.
• Solid knowledge and professional experience with data processing languages (including SQL and Python, ETL, UI design and data solutions is required.

What we offer you

• Payments in lieu of vacation, and benefits.
• Annual performance award up to 6%.
• Defined benefit pension plan.
• Employee discounts, wellness program, professional resources.

What you can expect

• This role will work in a hybrid environment with requirements to be onsite at a Canadian Blood Services location 40% of the time of the week.
• Travel Requirements-travel will be required for team meetings and projects as they arise.

Diversity and inclusion play a vital role in ensuring health equity for patients across Canada. We are committed to reflecting Canada's population in our organization and fostering an environment where all employees can be their authentic selves, with equal opportunities to succeed and contribute.

Canadian Blood Services requires that all employees be fully vaccinated (COVID 19 vaccine doses as approved by Health Canada), subject to any medical or other human rights considerations. Persons who have been vaccinated outside of Canada must contact their local Public Health Unit in order to obtain a vaccine equivalency certificate.

If this role resonates with you, we encourage you to apply by providing your up-to-date resume. This could be your first step towards a meaningful and inspiring career. Come to work each day knowing that you save lives.

We thank all applicants for their interest. However, only those considered for an interview or those invited to participate in an assessment will be contacted. Applicants who require accommodation should discuss their needs with us.