Planning Data Analyst

Data Integration Analyst About Queen's University
Queen's University is the Canadian research intensive university with a transformative student learning experience. 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.
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. 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 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.

Experience in integration technologies, methods and capabilities considered an asset (e.g., 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.
Actively participate in project team meetings and develop individual and unit project plans.
Lead procedural or technological change within a unit.
Appropriately assesses risks before making a decision.
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.
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.