Data Analyst, Business Intelligence (Bi)

Date Posted: 08/23/2023

Req ID: 33595

Faculty/Division: UofT Scarborough

Department: UTSC:Ofc of the Registrar

Campus: University of Toronto Scarborough (UTSC)

Position Number: 00046784

Description:

About us:

The University of Toronto Scarborough is a place of energy, enthusiasm and passion. Our commitment to inclusive excellence attracts the brightest learners, scholars and employees from around the globe. Our success has been made possible by the opportunity given to us by our Indigenous hosts to operate on their territory, and we cherish our continuing partnerships with these communities. The University of Toronto Scarborough is an exciting campus with unlimited potential. Join us on our journey.

The Office of the Registrar is responsible for student recruitment and admissions, direct and online service to current students, including registration, financial aid, scholarships, academic assessments, graduation and petitions. It also provides course scheduling, administration of tests and exams, enrolment data analysis and business intelligence.

It is the vision of the Office of the Registrar to connect every student to success by providing excellent service and support to students, faculty, staff and the broader community. Members of the Office of the Registrar team value accountability, inclusivity, community and leadership and take pride in work that is student-focused and meaningful.

This search aligns with the University’s commitment to strategically and proactively promote diversity among our community members (Statement on Equity, Diversity & Excellence). Recognizing that Black, Indigenous, and other Racialized communities have experienced inequities that have developed historically and are ongoing, we strongly welcome and encourage candidates from those communities to apply.

Your opportunity:

Working under the direction of Manager, Systems and Data Analytics, you will be responsible for creating and running queries to support data needs for staff and senior management, creating custom reports and visualization, analyzing data and presenting results to inform management decision making, developing and maintaining data visualization/dashboards using Tableau and Power BI, conducting complex statistical analysis, writing reports and making recommendations.

The role will respond to the given priorities, assist with maintaining Systems and will work collaboratively with the Data Analysts, Business Intelligence team in a challenging and dynamic environment.

Your responsibilities will include:

• Maintaining a database (ROSI, internal databases, etc.)
• Running queries to gather data
• Coordinating tasks for projects and other strategic initiatives with stakeholders
• Writing complex specifications based on system requirements and writing scripts to automate reports and processes
• Generating reports
• Entering course and/or program information in the Student Information System (ROSI) using scripts and queries
• Conducting detailed data analysis to inform management decision-making using Business Intelligence/Analytics Tools such as Power BI and Tableau
• Analyzing complex statistical reports and/or financial information for management decision-making (using SAS, R, SPSS)

Essential Qualifications:

• Advanced knowledge of Excel to manipulate data and make sense out of the data.
• Strong technical skills: understanding of relational databases, creating scripts for performing batch uploads, and experience with Business Intelligence tools such as Tableau or Power BI.
• Ability to make meaningful stories from data.
• Excellent knowledge of student information systems or other relational databases.
• Ability to work well under pressure and meet competing priorities with the highest level of accuracy.
• Ability to utilize statistical tools to conduct regression analysis, correlation studies and other statistical analysis.
• Excellent analytical and problem solving skills.
• Minimum four (4) years of relevant experience supporting data-driven decision making by conducting detailed data analysis and using large datasets, preferably in a post-secondary education or research-intensive institution.
• Applicants are also expected to show evidence of a commitment to equity, diversity, inclusion, and the promotion of a respectful and collegial learning and working environment.
• Bachelor's Degree with a background in statistics, mathematics, computer science or an acceptable equivalent combination of education and experience.
• Strong oral and written communications skills to explain complex statistical information to decision makers, probe for information to establish needs and respond to request, and communicate data query requirements to other Data Analysts.
• Ability to work independently and as part of a team.
• Advanced knowledge and experience using SQL.

Assets (Nonessential):

• Experience working with student data in higher education environment.
• Experience working with Azure Data Studio and Power BI.
• Experience developing data visualizations using Tableau dashboards for higher education.
• Working knowledge of University of Toronto systems (Student Information Systems (ROSI), Degree Explorer, eMarks, Web Scheduler, eService, Slate).

To be successful in this role you will be:

• Meticulous
• Proactive
• Problem solver
• Articulate
• Accountable
• Efficient

Additional Notes:

• Please note there are two positions available (Requisitions 33630 & 33595). Please submit two separate applications to be considered for both positions.
• A copy of the full job description is available upon request from the UTSC HR Office.

Closing Date: 09/07/2023, 11:59PM ET

Employee Group: USW

Appointment Type: Budget - Continuing

Schedule: Full-Time

Pay Scale Group & Hiring Zone:

USW Pay Band 12 -- $71,842 with an annual step progression to a maximum of $91,875. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.

Job Category: Information Technology (IT)

Lived Experience Statement

Candidates who are members of Indigenous, Black, racialized and 2SLGBTQ+ communities, persons with disabilities, and other equity deserving groups are encouraged to apply, and their lived experience shall be taken into consideration as applicable to the posted position.

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

Diversity Statement

The University of Toronto embraces Diversity and is building a culture of belonging that increases our capacity to effectively address and serve the interests of our global community. We strongly encourage applications from Indigenous Peoples, Black and racialized persons, women, persons with disabilities, and people of diverse sexual and gender identities. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences, and expertise are essential to strengthening our academic mission.

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 http://uoft.me/UP.

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].