Data and Systems Analyst

Job description

Data and Systems Analyst

Date Posted: 10/13/2020
Req ID: 1229
Faculty/Division: Faculty of Arts & Science
Department: ARTSC: Ofc of the Dean
Campus: St. George (Downtown Toronto)


About us:
The Faculty of Arts & Science is the heart of Canada’s leading university and one of the most comprehensive and diverse academic divisions in the world. The strength of Arts & Science derives from our combined teaching and research excellence in the humanities, sciences and social sciences across 29 departments, seven colleges and 46 interdisciplinary centres, institutes and programs.

We can only realize our mission with the dedication and excellence of engaged staff and faculty. The diversity of opportunities and perspectives within the Faculty reflect the local and global landscape and the need for curiosity, innovative thinking and collaboration. At Arts & Science, we take pride in our legacy of innovation and discovery that has changed the way we think about the world.

The Planning, Budget & Finance Office provides strategic and operational advice on the financial and budget management of the Faculty, as well as internal institutional and Faculty research data and business support services to all of the Faculty’s units. The Office models, plans, and implements the Faculty’s operating budget and provides Faculty-wide support and advice on the management of research, restricted and trust funds; financial analyses and forecasting; strategic planning and budget analysis; policy compliance and develops and delivers finance and business training seminars for A&S academic administrators and administrative staff.

Your opportunity:
Under the supervision of the Manager, Planning, Data and Analysis, the incumbent will assist the team's overall mandate to support Faculty planning, policy formulation, and decision making in order to further the academic mission of the Faculty.

Your responsibilities will include:

  • Analyzing and optimizing database software
  • Processing datasets using technical tools
  • Running queries to gather data
  • Analyzing and writing program scripts to extract, reformat and analyze data
  • Disseminating data reports
  • Editing database guidelines
  • Verifying and reconciling data errors
  • Generating data quality reports

Essential Qualifications:

  • Bachelor's Degree in Finance, Accounting and/or Computer Science, or an acceptable equivalent combination of education and experience.
  • Minimum three (3) years of recent and related experience with processing datasets, analyzing data, and generating reports.
  • Experience running queries to gather data.
  • Experience analyzing and writing program scripts with Python, R and SQL to extract, reformat and analyze data.
  • Experience analyzing data using Microsoft Excel, Tableau, and SPSS.
  • Experience with text mining and/or natural language processing.
  • Familiarity with Microsoft Office products, and advanced skills in Microsoft Excel.
  • Advanced skills in Tableau and SPSS.
  • Intermediate skills and experience coding in Python, R and SQL .
  • Strong oral and written communication, interpersonal, organizational, and analytical skills.
  • Demonstrated strong client service orientation.
  • Ability to manage conflicting priorities, multi-task, and have excellent attention to detail and accuracy.
  • Ability to maintain confidentiality.

Assets (Nonessential):

  • Familiarity with Faculty ofArts and Science's Finance and Undergraduate Admissions and Recruitment datasets is an asset.

To be successful in this role you will be:

  • Adaptable
  • Diligent
  • Insightful
  • Meticulous
  • Problem solver
  • Team player

Closing Date: 10/22/2020, 11:59PM EDT
Employee Group: USW
Appointment Type: Budget - Continuing
Schedule: Full-Time
Pay Scale Group & Hiring Zone:
USW Pay Band 08 -- $54,851 with an annual step progression to a maximum of $70,146. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Administrative / Managerial

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

Diversity Statement
The University of Toronto is strongly committed to diversity within its community and especially welcomes applications from racialized persons / persons of colour, women, Indigenous / Aboriginal People of North America, persons with disabilities, LGBTQ persons, and others who may contribute to the further diversification of ideas.

As part of your application, you will be asked to complete a brief Diversity Survey. This survey is voluntary. Any information directly related to you is confidential and cannot be accessed by search committees or human resources staff. Results will be aggregated for institutional planning purposes. For more information, please see

Accessibility Statement
The University strives to be an equitable and inclusive community, and proactively seeks to increase diversity among its community members. Our values regarding equity and diversity are linked with our unwavering commitment to excellence in the pursuit of our academic mission.

The University is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities.

If you require any accommodations at any point during the application and hiring process, please contact [email protected].
All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

Job Segment: Database, Systems Analyst, Equity, Strategic Planning, Computer Science, Technology, Finance, Strategy




Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 10/14/2020
Application Due: 10/23/2020
Work Type: