Data Analyst, Business Intelligence (BI)

at  University of Toronto

Date Posted: 09/19/2024
Req ID: 39795
Faculty/Division: UofT Scarborough
Department: UTSC:Arts & Science Co-op Programs
Campus: University of Toronto Scarborough (UTSC)
Position Number: 00043017

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 University of Toronto Scarborough has been a leader in co-operative education and work integrated learning (WIL), for 50 years. Co-op and WIL give students an opportunity to apply skills learned in the classroom, and to expand their knowledge through related work experience. The Department of Arts and Science Co-op is responsible for preparing over 3000 00 undergraduate students from 58 academic areas to compete for paid co-op work term opportunities. The department is also responsible for engaging industry partners who provide these work terms. A coordinated effort among the stakeholders of student, employer, and university co-op programming contribute to the development of well qualified graduates who are prepared to assume a productive role in society. With a commitment to the equity, diversity and inclusion and the campus’ ‘Inclusive Excellence’ mission, the department works closely with academic departments and support services on campus and with employer and community partners to support students as they work to achieve their academic and co-op/integrated learning aspirations.
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.

ESSENTIAL QUALIFICATIONS:

• Bachelor’s Degree preferably in computer science, statistics or relevant area of education; or equivalent combination of education and experience.
• Minimum four years of recent and related experience in data management & analysis, including experience using Business Intelligence software to extract, translate, load and to create user friendly visual dashboards in order to facilitate data-driven decisions preferably within a higher education environment
• Data analysis skills, including: designing and generating reports; analyzing data and identifying meaningful trends and results; developing projections to support strategic planning; calculating ROI measurements for marketing and business development activities; and supporting continuous improvement activities.
• Advanced computers skills essential, including: Microsoft Office applications, in particular Excel (specifically pivot tables, formulas, relational tables, Macros) and Visio; Azure Factory and PowerBI preferred. Experience with Informatica, Tableau and other reporting tools an asset.
• Excellent organizational skills with experience in project management working with multiple projects at a time (Agile & Waterfall project management experience is an asset).
• Excellent oral and written communication skills to excel in a highly service-oriented environment
• Must possess strongi nterpersonal skills with the ability to work well in a team environment and maintain productive and respectful working relationships with all stakeholders including staff, faculty, students and external stakeholders.
• Ability to prioritize and complete many competing demands in order to meet strict deadlines with keen attention to detail.
• Ability to handle confidential information with tact and discretion; adhering to established policies and procedures.
• 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.

NOTE:

• A full job description is available upon request from the UTSC HR Office.
• This role is currently eligible for a hybrid work arrangement, pursuant to University policies and guidelines, including but not limited to the University of Toronto’s Alternative Work Arrangements Guideline.
  Closing Date: 10/03/2024, 11:59PM ET
  Employee Group: USW
  Appointment Type: Budget - Continuing
  Schedule: Full-Time

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

YOUR RESPONSIBILITIES WILL INCLUDE:

• Analyzing the effectiveness and efficiency of existing systems and developing technical solutions for systems improvements
• Providing detailed information on data analysis findings to stakeholders
• Designing and optimizing databases and data visualization dashboards
• Developing database schemas and sub-schemas and reporting infrastructure
• Analyzing and writing program scripts to extract, translate (reformat), load to maintain a clean database.
• Planning components of projects
• Maintaining information on digital platforms
• Tracking progress of student work-integrated experience applications, interviews and recruitment

TO BE SUCCESSFUL IN THIS ROLE YOU WILL BE:

• Accountable
• Communicator
• Diligent
• Problem solver
• Self-directed
• Team player