Data Integration Analyst

Queen's University; Kingston; On-site; CAD 70,000 - 85,000; Full time

Job summary

Une université de premier plan recherche un analyste d'intégration de données pour concevoir et mettre en œuvre des stratégies d'intégration. Le candidat idéal aura une solide expérience en développement d'APIs et en gestion des données, avec un fort accent sur la qualité et la sécurité des données. Les responsabilités comprennent la collaboration avec des équipes technologiques pour optimiser les flux de données et fournir une documentation technique.

Qualifications

• Baccalauréat ou équivalent avec certification technique.
• Plus de 3 ans d'expérience en technologies d'intégration.
• Expérience dans la gestion de bases de données souhaitée.

Responsibilities

• Développer et mettre en œuvre des stratégies d'intégration de données.
• Fournir des conseils techniques pour le développement de solutions d'intégration.
• Effectuer des audits pour garantir l'intégrité des données.

Skills

API Development

Data Integration

Data Mapping

Database Management

Project Management

Education

Four-Year Bachelor Degree

Tools

MySQL

PostgreSQL

Oracle

Job description

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.

Apply Online.