Data Integration Analyst

COVID 19 On-Campus Requirements

Prior to May 1 2022 the University required all students faculty staff and visitors (including contractors) to declare their COVID-19 vaccination status and provide proof that they were fully vaccinated or had an approved accommodation to engage in in-person University activities. These requirements were suspended effective May 1 2022 but the University may reinstate them at any point.

About Queens University

Queens University is the Canadian research intensive university with a transformative student learning experience. Here the employment experience is as diverse as it is interesting. We have opportunities in multiple areas of globally recognized research faculty administration engineering & construction athletics & recreation power generation corporate shared services and many more.

We are committed to employment equity and diversity in the workplace and welcome applications from individuals from equity seeking groups such as women racialized/visible minorities Indigenous/Aboriginal peoples persons with a disability persons who identify in the LGBTQ community and others who reflect the diversity of Canadian society.

Come work with us!

Job Summary

A Brief Overview

Reporting to the Associate Director Data Integration & AI Smith School of Business the Data Integration Analyst will design and implement data integration strategies to ensure seamless data flow across various systems while ensuring adherence to data security and privacy regulations. This role will collaborate with the Digital Solutions team to build efficient data APIs for integration into solutions and will perform data mapping transformation and cleansing activities. The Data Integration Analyst tests and validates data integration processes to ensure accuracy and consistency and identifies and resolves issues such as inconsistencies. The incumbent will develop and maintain documentation related to data integration processes including data source definitions data flow diagrams and system interactions and maintain Data Architecture. This role performs regular audits to ensure the integrity and quality of data. Experience developing and integrating APIs is required.

This position provides technical advice to support the development of data integration solutions transformations and improvements. This position plans and coordinates straightforward data integration projects. This position analyzes new technologies including testing evaluating and determining compatibility and functionality of integrations. This position also provides recommendations during the initial design phase to support overall planning efforts.

Job Description

What you will do

• Provides technical advice and expertise to support the development of data integration solutions transformations and improvements including analysis of business requirements and recommendation of solutions.


• Plans and coordinates straightforward data integration projects.


• Analyzes new technologies including testing evaluating and determining compatibility and functionality of integrations.


• Maintains troubleshoots connects and reviews existing data and data integration platforms including reviewing architecture integration and code reviews.


• Develops designs and implements reporting capability within applications.


• Provides recommendations during the initial design phase to support overall planning efforts.


• Develops and maintains data integration catalogs and technical documentation.
• Other duties as required in support of the department and/or unit.

• Four-Year Bachelor Degree or equivalent. In addition requires trade certification qualification or on-going learning to remain ahead of changes in technology or emerging fields.

• More than 3 years and up to and including 5 years of experience.
• Experience in integration technologies methods and capabilities considered an asset (e.g. REST SOAP API etc.).


• Experience in database administration/management design and/or technologies considered an asset (e.g. MySQL PostgreSQL and/or Oracle/DB2 relational databases warehoused databases etc.).


• Experience in platform solutions considered an asset.


• Experience working with diverse populations/equity deserving groups considered an asset.

• Knowledge of concepts and principles in a specialist field that is typically acquired through a combination of advanced professional or academic qualifications and/or substantial work experience.
• Provide effective consultation and advice on non-straightforward and/or complex issues.


• Interaction with others requires interpersonal skills and the ability to understand and influence.


• Adapt messages to meet the different needs of different audiences.


• Builds relationships trust and credibility.
• Prioritize and distribute work to deliver objectives on time and to the highest standard.


• Identify in advance when the intended results may not be achieved and develops a plan to address the gaps.


• Actively participate in project team meetings and develop individual and unit project plans.


• Lead procedural or technological change within a unit.
• Identify opportunities to improve the effectiveness and efficiency of work processes.


• Seek information and input to fully understand the cause of problems.


• Appropriately assesses risks before making a decision.


• Contribute to the creation and evaluation of possible solutions.


• Take action to remove obstacles and address problems before they impact performance and results.
• Apply equity diversity accessibility inclusion and Indigenization considerations to decision making and planning.


• Promote a work environment that is free from sexual violence harassment and discrimination and the ability to show empathy for those who have experienced trauma.

Employment Equity and Accessibility Statement

The University invites applications from all qualified individuals. Queens is strongly committed to employment equity diversity and inclusion in the workplace and encourages applications from Black racialized persons Indigenous people women persons with disabilities and 2SLGBTQI persons. In accordance with Canadian Immigration requirements priority will be given to those who are legally eligible to work in Canada.

The University provides support in its recruitment processes to all applicants who require accommodation due to a protected ground under the Ontario Human Rights Code including those with disabilities. Candidates requiring accommodation during the recruitment process are asked to contact Human Resources at .