Research Data Analyst

As a member of Research Services within the Vice Principal Research portfolio, the Research Data Analyst (Data Analyst) will have the significant opportunity to bring the story of research success at Queen’s University to light. Focused on management, analysis and reporting, the Data Analyst will create and maintain a comprehensive toolbox of data analytics procedures and dictionaries necessary for verifying, extracting, compiling, visualizing and reporting on research funding awards, trends and forecasts for both internal and external audiences. While the Data Analyst will work to fulfill a combination of regular reporting (e.g., annual research activity compliance reports) and special requests for funding data summaries (e.g., by research centre or Faculty), they will also bring a knowledgeable and creative approach to their work and share recommendations with Portfolio leadership for improving data analytics and data integrity. The Data Analyst will work collaboratively with colleagues in Research Services, including the Research Systems team and staff who support pre- and post-award aspects of the research funding data collection cycles, and will build effective relationships with colleagues in Research Accounting, Faculty offices, Institutional Planning and affiliated hospitals. The Data Analyst will bring an enthusiasm for information management and has the exciting opportunity to help shape the way Queen’s research award data is leveraged to meet the reporting needs and strategic goals of the university.

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.

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.
• 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.
  • in database management and/or statistics preferred.

Required Experience

• More than 3 years and up to and including 5 years of experience.
  • Experience in data, trend analysis and reporting considered an asset.
  • Experience with scripting languages considered an asset (e.g., HTML, CSS, PHP, Javascript, maxscript, mel, etc.).

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.