Data Integration Analyst

Job Responsibility: Data Integration Analyst About Queen's University

Queen's 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.

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.

Required Education

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

Required Experience

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

Consideration may be given to an equivalent combination of education and experience. Job Knowledge and Requirements

• 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. Queen's 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 .

SkillsReference 414145