Data Analyst, Business Intelligence (BI)

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

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

Your opportunity:

Under general supervision of the Assistant Director, the incumbent will be responsible for enhancing quality data, analytical support and reports which support the ongoing operations of the department. With a focus on continuous improvement, the incumbent will assist in the development of models and projections to ensure that various strategic issues and priorities are critically examined and that the planning activities are grounded in sound and reliable evidence.

Reporting to the Assistant Director, the incumbent will be responsible for optimizing, maintaining and updating a clean data warehouse for consistent, reliable, accurate and high integrity data reporting (Utilizing Azure Factory ETL software). This incumbent will be responsible for data designing and optimizing data visualization dashboards (in PowerBI), analysis, developing reports data monitoring, report writing and resulting recommendations related to department’s specific business requirements, including but not limited to key conversion metrics such as unique postings, seekers (by type: eligible, active and engaged), applications, interviews and hires. They will be responsible for developing, optimizing and maintaining dashboards as required to measure and monitor enrollment, retention and persistence to graduation within Co-op programs.

The incumbent will be responsible for translating business needs and complex data inquiries into easily understood business requirements, responses and reports, and gathering and analyzing the required data to support decision making by the management team. The incumbent is also responsible for developing and documenting current and proposing improved work flow and business processes as needed. This role will support the team with business intelligence through regular and ongoing communication with the Leadership and other members of the team on key performance metrics (such as the work term hiring conversion and retention metrics).

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

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.

Assets (Nonessential):

• Microsoft Office: Azure Factory and PowerBI reporting tools preferred.
• Experience with Symplicity (CSM), Informatica, Tableau and other reporting tools an asset.

To be successful in this role you will be:

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

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
Pay Scale Group & Hiring Zone:  
USW Pay Band 12 — $79,874. with an annual step progression to a maximum of $102,147. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol. 
Job Category: Administrative / Managerial

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.