Institutional Research Technical Analyst - Limited Term

ontariotechu • Oshawa, ON

5d • Onsite

About The Position

This role involves working with Ontario Tech faculties and departments to understand and fulfill their data needs for new projects and ad-hoc requests. The analyst will leverage their knowledge of data and systems to contribute to framework and report design, suggest methodological changes, and gather data. A thorough understanding of Banner Student, HR, and Finance data sources, along with reporting tools, is essential to ensure the quality and transparency of the process.

Requirements

• Expert knowledge of Ellucian Insights reporting and Power BI.
• Expert knowledge of Banner Student data, including data details, table join definitions, and Framework model setup.
• Ability to write and recommend data reports for Human Resources data.
• Attention to detail.
• Data analysis skills.
• Communication skills with both internal and external stakeholders.
• Knowledge of database terminology and concepts.
• Knowledge of reporting tools.
• Knowledge of data validation.
• Completion of a University Program consisting of Four Academic Years.
• Over 5 years and including 7 years of experience.

Nice To Haves

• An equivalent combination of education and related experience may be considered.
• 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.

Responsibilities

• Support the university in delivering efficient Enterprise suite applications and reporting solutions using expert knowledge of Ellucian Insights reporting and Power BI.
• Coordinate with the data architecture and modeling team to design databases.
• Assist with the design, development, implementation, and support of 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 databases.
• Develop SQL queries and external data sources for data not provided by I.T.
• Provide proposals to I.T. regarding Framework model administration.
• Identify and pursue opportunities to automate regular reporting.
• Prepare designs and code for various reporting objects, ensuring compliance with best business practices.
• Approve reports developed by others before publishing to production.
• Maintain security access lists for users.
• 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, analyze business requirements, and perform interviews with stakeholders.
• Report incorrect join definitions between tables to I.T. and propose changes for better performance.
• Respond to data requests from internal and external stakeholders and compile reports.
• Provide support for updates to the University Fact Book, Common University Data Ontario, and other institutional key performance indicators.
• Work in collaboration with faculties/departments to maintain and enhance the standard Banner Student reporting package and support ongoing ad-hoc reporting needs.
• Work with customers to determine desired goals and data needs of new projects and ad-hoc requests.
• Clarify and document requirements, and obtain acceptance of deliverables from 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.
• Recommend, support, and adapt to improvements in quality, efficiency, and work processes.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level