Institutional Research Technical Analyst - Limited Term
Tracking Code: req2062
Faculty/Department: Office of Planning and Analysis
Number of Positions: 1
Appointment Type: Limited Term (18-month contract)
Hours of Work: 35 hours per week
Salary Range: Level 9 - Starting Salary, Step 1 $87,889
Posting Date: June 16, 2026
Closing Date: June 30, 2026 (7:00 pm EST)
Job Summary:
Work with Ontario Tech faculties/departments to determine desired goal(s) and data needs of new projects and ad-hoc requests. Use knowledge of data and systems to proactively contribute to framework/report design process and suggest changes in methodology/design. Gather data for new projects and ad-hoc requests, using a thorough knowledge of Banner Student, HR and Finance data sources and reporting tools to determine the method(s) that maximizes quality and transparency of process.
Responsibilities/accountabilities:
Cognos Business Intelligence
-
Expert knowledge of Ellucian Insights reporting and Power BI. Support the university to deliver efficient Enterprise suite applications and reporting solutions.
-
Coordinate with data architecture and modeling team to design databases
-
Assist with design, development, implementation and support all Cognos reporting solutions
-
Develop and perform tests on various enterprises using reporting software and assist all end users
-
Convert Cognos reports to Insights/Power BI
-
Develop complex dashboard reports using relational and multidimensional database
-
Develop SQL queries and external data sources for data not provided by I.T.
-
Provide proposal to I.T. in regards to Framework model administration
-
Identify and pursue opportunities to automate regular reporting
-
Prepare all designs and code for various reporting objects and ensure compliance to all best business practices
-
Approve reports developed by others before publishing to production
-
Maintain security access lists for users
Data: Reporting and Analysis
- Expert knowledge of Banner Student data, in particular to data details, table join definitions and Framework model setup. Able to write and recommend data reports for Human Resources data as well.
-
Define data requirements and use appropriate methodologies to develop report design
-
Provide written and graphical reports with accompanying documentation on findings
-
Lead meetings with users to gather user requirements
-
Investigate and resolve all data issues and analyze all business requirements and perform interview with all stakeholders
-
Report to I.T. incorrect join definitions between tables and propose changes to maximize better performance
-
Respond to data requests from internal and external stakeholders and compiling reports
-
Providing support for updates to the University Fact Book, Common University Data Ontario, and other institutional key performance indicators
Interdepartmental collaboration
-
Work in collaboration with faculties/departments to maintain and enhance standard Banner Student reporting package and support ongoing ad-hoc reporting needs.
-
Works with customers to determine desired goals and data needs of new projects and ad-hoc requests.
-
Clarifies and document requirements, and obtain acceptance of deliverables from the customers
-
Work with customers to plan and execute reporting needs for upcoming cycles
-
Identify trends and propose the creation and adjustments of reports and analyses
Adapts to changing environment/innovation
-
Recommends, supports and adapts to improvements in quality, efficiency and work processes
-
Examples:
-
Created a dashboard report for Career Center that use to take a couple of days to generate
-
Use Cognos to generate letter documents for student. Old process, run report and export to Excel, create document in Word and generate letter documents using mail merge
Customer Service
-
Establishes and maintains effective external and internal customer relations. Models and conveys a favourable image of the department and the university
-
Treats colleagues and customers with courtesy, sensitivity, fairness and honesty
-
Keeps promises and commitments
-
Communicates effectively and appropriately
Required Skills:
-
Attention to detail
-
Data analysis
-
Communication with both internal and external stakeholders
Required Knowledge:
-
Data reporting and analysis (Ellucian Insights and Power BI)
-
Database terminology and concepts
- Reporting tools
-
Data validation
Required Education:
-
Completion of a University Program consisting of Four Academic Years
- An equivalent combination of education and related experience may be considered
- Verification of Academic credentials may be required
Required Experience:
-
Over 5 years and including 7 years
How to Apply:
Interested candidates should submit in electronic format a covering letter and their resume. Applications will be accepted until June 30, 2026 or until a suitable candidate is found. We appreciate all applications received; however, only those candidates selected for an interview will be contacted.
This position falls within the bargaining unit represented by the Ontario Public Service Employees Union (OPSEU) and will be subject to the terms and conditions of the collective agreement between the university and the OPSEU. To the extent that policies are not included in the collective agreement, employment will also be governed by the university’s policies which may also be found on our website https://ontariotechu.ca and which may be amended from time-to-time.
Ontario Tech University is actively committed to equity, diversity, inclusion, indigenization and decolonization (EDIID), and welcomes applications from all qualified candidates, while especially encouraging applications from First Nations, Metis, Inuit peoples, Indigenous peoples of North America, racialized persons, persons with disabilities, and those who identify as women and/or 2SLGBTQ+. All qualified candidates are encouraged to apply; however, Canadian citizens, permanent residents, Indigenous Peoples in Canada, and those eligible to work in Canada, will be given priority.
Ontario Tech University respects people's different needs and therefore will take all reasonable steps to ensure accommodation for applicants where appropriate. The University is also committed to ensuring that confidentiality is maintained throughout all aspects of the recruitment cycle.
If you require accommodation, please contact Julie Day, Health and Disability Management Specialist. For more information about the universities policies for accommodating employees with disabilities please review the university’s Accessibility Policy
The university acknowledges the lands and people of the Mississaugas of Scugog Island First Nation which is covered under the Williams Treaties. We are situated on the Traditional Territory of the Mississaugas, a branch of the greater Anishinaabeg Nation which includes Algonquin, Ojibway, Odawa and Pottawatomi.
Job Location: Oshawa, Ontario, Canada
Expected Start Date: 7/1/2026
Expected End Date: 12/17/2027
