Data 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!

Applicant Guidance & Information

At Queen's, we are committed to helping people achieve their best. Whether you are beginning your career at Queen's or seeking your next opportunity, we are here to support you. Visit our Applicant Resources for guidance on applying, showcasing your skills and experience, and preparing for interviews.

Disclaimer: As part of the application process at Queen's University, our recruitment system uses Artificial Intelligence (AI), as defined under the Ontario Employment Standards Act, to ask job-related questions and confirm eligibility for hire. All final hiring decisions are made using non-AI related processes.

Job Summary

A Brief Overview
This position builds databases, data pipelines, and dashboards, and performs queries to generate relevant information, and interpret and communicate results. This position analyzes and makes recommendations to improve database, query, and report functioning. This position designs and implements data discipline, quality assurance, data sharing, and legislative compliance. This position also updates and maintains the data catalogue and metadata repository. To be successful in this position, proficiency in Power Automate including the ability to develop and deploy Copilot Studio agents with custom Power Automate flows is essential.

Job Description

What you will do
• Builds databases, data pipelines, and dashboards.
• Builds database queries to generate relevant information, and interpret and communicate results.
• Develops and maintains reports, dashboards and visualizations.
• Performs data analysis using statistics and modeling and creates reports.
• Analyzes and makes recommendations to improve database, query, and report functioning.
• Interprets data needs, and determines which data sources to use.
• Supports staff on use of systems, troubleshoots issues that may arise, and communicates problems to technical resources.
• Designs and implements data discipline, quality assurance, data sharing, and legislative compliance.
• Updates and maintains the data catalogue and metadata repository.
• Serves as a liaison between technical and non-technical resources.
• Designs, develops, and delivers educational material for a range of data management workshops.
• 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 with Microsoft Power Automate considered an asset.
• Familiarity with Copilot Studio Agents, including integration with Power Automate (Power Flows), 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.