The Opportunity The Data Analytics & Integration Developer will play a key role in uncovering actionable insights from a high volume and varied sources of data to help improve the overall student experience, streamline operational processes, and facilitate informed decision-making by:
- Collaborating with various Chang School teams (Data & Business Analytics, IT Operations, Applications, Finance, Marketing, etc.), using industry best practices and current technologies, to extract data from various sources and develop meaningful reports, data visualizations, and processes.
- Developing, maintaining, and enhancing systems including databases, reporting solutions, and Data Integration / Extract-Transform-Load (ETL) processes.
- Providing training and user support on dashboards/reports and other business analytics solutions.
The successful candidate will work in a hybrid work environment (combining in-person/on-campus and remote work).
Responsibilities- Supporting business analytics reporting and analysis within The Chang School by:
- Soliciting requirements from end users for data analysis requests, new reports, and new dashboards.
- Creating complex queries, dashboards, and datasets for use by internal customers.
- Analyzing and assessing trends from data to provide insights and recommendations.
- Support end users within The Chang School by:
- Providing guidance and technical support on dashboards, self-serve reporting, and other business analytics solutions.
- Developing technical artifacts describing the functionality of business analytics platforms, data flow between systems, and explaining technical concepts in simple terms (e.g. with analogies) for business to easily grasp them.
- Following best practices for standard presentation formats, documentation, and reports.
- Support data integration functions with the department by
- Loading OLAP cube structures with data extracts from internal systems.
- Designing, developing, and scheduling data integration processes to transfer information needed for business analytics and reporting.
- Troubleshooting data integration procedures in the event of a job failure or other technical issue.
- Creating technical artifacts to help business grapes technical concepts with ease and provide analogies, etc.
- Provides backup and assistance to other members of the department.
QualificationsTo help us learn more about you, please provide a one-page cover letter and resume describing how you meet the following required qualifications:
- Successful completion of a post-secondary degree program in Computer Science, Information Technology, Data Analytics or a related field and a minimum of 3 years of work experience in:
- Data Integration/ETL, Querying Data, Data Visualization and Report/Dashboard Development
- Collaborating with business users to gather requirements, impart training and explain technical concepts in business-friendly language
- Strong knowledge of the following skills:
- Microsoft Data/business intelligence suite - SQL Server, SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services).
- Experience using similar database systems/stacks from major vendors (e.g. Oracle, IBM, Microsoft Azure Analysis Services, Teradata, etc.) would be considered.
- Data Query languages - SQL, Multi-Dimensional Expression (MDX).
- Experience using Data Analysis Expression (DAX) / PowerQuery M for Tabular SSAS models / Power BI would be considered.
- Reporting/Data Visualization tool(s) - Tableau preferred.
- Experience in Power BI, Qlikview, and/or another leading reporting tool would be considered.
- Nice-to-have skills:
- Some programming skills - Python, Excel VBA (Visual Basic for Applications).
- Experience dealing with data from complex enterprise systems, such as financial systems, customer relationship management (CRM) systems, student information systems (SIS), enterprise resource planning systems (ERP), etc.
- Strong analytical skills and logical thinking to assess trends from data to provide insights and proactively share findings with stakeholders and other areas.
- Solid oral and written communication skills, especially technical writing experience for diverse non-technical audiences
- Highly organized with the ability to coordinate multiple initiatives/projects concurrently, and meet changing requirements/priorities to accomplish objectives.
- Build and maintain strong working relationships with internal and external partners; collaborate across organizational boundaries with various functions and coordinate with vendors.
Additional Information (OPSEU) Position Number(s) 20003942
Reports To Data & Business Analytics Manager
Department Chang School
Employee Group OPSEU
Vacancy Type Term - this is a current vacancy
Work Location Hybrid (2 to 3 days in-person/onsite and the remaining days working remotely) based on operational requirements and subject to change
Start Date July 2026
End Date May 2027
Hours of Work 36.25
Grade 12
Salary Scale 78,272.15 - 99,152.84
Hiring Salary Range 78,272.15 - 85,530.11
TA Specialist Laurie Shemavonian
Posting Date June 24, 2026
Application Close Date July 8, 2026
- Equivalent experience or a combination of equivalent experience and education may be accepted in place of education.
- As part of the selection process, candidates may be required to complete an occupational assessment.
- Applications will only be accepted online through Toronto Metropolitan University's career site.
- We will provide an accessible experience for applicants, students, employees, and members of the Toronto Metropolitan University community. We are committed to providing an inclusive and barrier-free work environment, starting with the recruitment process. If you have restrictions that need to be accommodated to fully participate in any phase of the recruitment process, please submit your request through the AskHR webform . All information received in relation to accommodation will be kept confidential.
