Corporate Reporting Analyst - Special Project (August 2025 - December 2027)
Status: Special Project (August 2025 - December 2027)
Hours: Monday - Friday, 35 hours/week
Home Campus: Fennell (hybrid work arrangements available)
Rate of Pay: Payband 10 ($87,239 - $109,049 per year, plus 4% in lieu of vacation)
**As of September 1, 2025 employees will receive 22 vacation days per year.
Posting Date: July 25th, 2025
Closing Date: August 8th, 2025 at 7:00 pm EST
We believe the rich diversity among our students and the communities we serve should be reflected within our workforce. As educators, we believe it is important to act and show leadership in advancing the principles of reconciliation, equity, diversity, and inclusion in our community.
Job Summary
Mohawk College is undertaking a major digital transformation through the Banner Business Transformation Project, reimagining our Enterprise Resource Planning (ERP) system, Banner and related processes, to enhance the student, faculty, and staff experience.
Reporting to the Director, Corporate Reporting BBT and Stream Lead Reporting, and working closely with Human Resources, Finance, Budget and Planning, Student Services and Academic management, the Corporate Reporting Analyst will serve as a key resource on the Banner Business Transformation project and develop processes/reports, methodologies, and analytical tools to support and develop each of these areas from a Business Intelligence (BI) standpoint.
Business Intelligence (BI) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information to enable more effective strategic, tactical, and operational insights and decision-making. Therefore, the BI portion of the role is to strategically implement BI software and systems, including integration with databases and data warehouses.
Data mining and analytics differs from BI in that it is a technique that attempts to show statistical correlation and cause between disparate sources of information or look at data in new and unexpected ways.
This position requires a thorough understanding of the requests of all the Divisions/areas of the College, so that appropriate solutions are developed and deployed. These solutions require providing reports and analytical guidance on sensitive matters related to employee, student and financial matters so it is incumbent on these individuals to adhere to corporate privacy and security policies.
What you'll be doing:
Operational Management
Directs, organizes and leads sub-projects in the implementation and use of new analytics and reporting software tools and systems.
Assists in the integration efforts for merging analytics and reporting platforms and services with enterprise systems and applications.
Designs, codes, tests, and documents all new or modified analytics and reporting systems, applications and programs.
Assists in development of the semantic layer, metadata, reports and report definitions.
Develops dashboards, scorecards, reports, graphs and analytical models that support client's needs.
Assists in the design of databases and data warehouses to ensure interoperability with analytics and reporting solutions.
Analyses user requirements and based on findings, design functional specifications for analytics and reporting front-end applications.
Works with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
Designs and delivers end-user training and training materials; provides technical and analytical support.
Troubleshoots analytics and reporting tools, systems and software; performance-tune these applications as necessary.
Promotes analytics and reporting benefits across the organization.
Strategy and Planning
Assists in assessing and cultivates long-term strategic goals for analytics and reporting development in conjunction with end users, managers, clients, and other stakeholders.
Creates data architectures, coding standards, statistical reporting, and data analysis methodologies.
Deployment
Conducts research and makes recommendations on analytics and reporting products, services, and standards in support of procurement and development efforts.
Evaluates and selects database/data warehouse components, including hardware, relational database management systems, Extract-Transform-Load (ETL) software, metadata management tools and database design solutions. This includes blueprinting, gathering requirements, designing, and rolling out analytics and reporting solutions to end users.
The incumbent is also responsible for ensuring high levels of analytics and reporting availability and will support adoption and deployment with sound technical skills and thorough understanding of business needs.
Other related duties as assigned
Includes the continued support for applications and processes that support the Information Systems mandate and deliverables.
What you'll bring to the role:
A three (3) year Diploma or Degree in such disciplines as Computer Science, Math and Statistics, or a related field is required at the point of hire into this position.
A minimum of five (5) years of experience in a similar capacity.
Experience with tier-one applications, databases, data processing, and data warehouses flowcharting techniques.
Able to prioritize and execute tasks in a high-pressure environment.
Experience working in a team-oriented, collaborative environment.
Expertise in analytics and reporting tools.
Strong ability to analyze user requirements and build front-end analytics and reporting applications according to specifications.
Strong understanding of data mining models, structures, theories, principles, and practices.
Strong familiarity with data preparation, processing, classification, and forecasting.
Strong understanding of relational database structures, theories, principles and practices.
Good knowledge of applicable data privacy practices and laws.
Strong written and oral communication skills.
Good interpersonal skills.
Exceptional analytical, conceptual, and problem-solving abilities.
Strong understanding of SQL.
Working Knowledge of PL/SQL.
Familiarity with Business Intelligence Software (eg. Metabase, Tableau, Cognos, Power BI) would be considered an asset.
Demonstrated commitment and understanding of human rights, equity, diversity, inclusion, and accessibility.
The ability to communicate and work effectively with diverse students, employees, and communities.
What we offer:
Effective September 1, 2025, employees will receive 22 paid vacation days.
Opportunity to gain experience and build relationships at a Hamilton/Niagara Top Employer.
Access to professional development opportunities.
Option to enroll in Defined Benefit pension plan (CAAT) with contributions matched by Mohawk College.
Discounted rate for full-service athletic facility and instructor-led classes.
Opportunities to engage in wellness events and activities.
To find out more about working at Mohawk College, please visit https://www.mohawkcollege.ca/about-mohawk/careers-at-mohawk
We are committed to reconciliation and nurturing an inclusive, diverse, equitable, and accessible (IDEA) environment for everyone who learns and works at Mohawk College. We welcome applications from racialized persons, women, Indigenous people, persons with disabilities, 2SLGBTQIA+ persons, and others who may contribute to the further diversification of ideas.
The College is committed to fostering inclusive and barrier-free recruitment and selection processes. If you require accommodation during any stage of the recruitment process, please contact Human Resources.
To learn more about Mohawk College's commitments, please visit the Mohawk College strategic plan webpage: https://www.strategicplan.mohawkcollege.ca/
