Job Summary: This position provides technical and functional expertise to support the Banner Student system and other subsystems used by Ontario Tech University’s business services, including the Registrar’s Office, School of Graduate and Postdoctoral Studies, Student Life, and Faculty. The role will be crucial in the Banner ERP transformation project, supporting the transition from an on-premise system to a cloud-based solution. Responsibilities include assessing existing customizations to ensure they align with business needs and developing new integrations to connect various modules or external systems as required. The role requires collaboration with project stakeholders and Durham College ITS to assess, plan, and execute the scope of work. Additionally, this position will play a key role in testing processes to ensure seamless data flow and interoperability. This job reports to the Manager, ERP Systems and Reporting. Responsibilities/accountabilities: Analyzing requirements and specifications, in the context of existing systems/system modules, and business procedures to identify the impact and advice. Translates business requirements into functional and non-functional system application requirements. Develop and implement plans and activities associated with business process redesign including the creation of business requirements, business process mapping documents involving both internal and external stakeholders. Identifies the interactions needed between systems and application components. Creates a detailed design document for the database (tables, primary keys and data relationships). Prepares application and system solution design, technical specifications for the application custom development and application function configuration and setup. Designs and implements test plans; compile test results and communicate with other Systems Analysts and Manager, ERP Systems and Reporting to identify necessary fixes/and or changes. Identify the sequence of application development work based on module dependencies. Collaborate with technical staff in the technical aspects of the development work. Reviews, analyzes and evaluates Banner student system upgrades. Creating queries and SQL Reports to extract data from SIS for verifying test cases. Provide production support for issues encountered by any business area that uses the Banner Student Information System.