An exciting opportunity has arisen at the University for an experienced Reporting Analyst to join the Business Systems team.
Located within University Information Services (UIS), the Business Systems team are responsible for the maintenance and development of the University's critical ERP systems for handling administrative data across HR, Finance, Student and Teaching & Learning.
Working on both operational support and project activities, you will assist with the development and maintenance of business systems integrations in support of strategic initiatives, whilst improving efficiency and reducing technical debt. You will demonstrate in-depth knowledge of systems integration approaches and associated technologies whilst providing a high level of support to our customers.
Your work will be varied and unique, and will involve working closely alongside other Reporting Analysts, Application Specialists, Database Administrators, Functional Analysts, Testers and our stakeholders in a constantly changing environment.
What you will be doing:
1. Since several of the toolsets and platforms are common for both Integration and Reporting/Analytics, work as part of a multi-disciplinary team to review requirements, develop specifications and design effective solutions.
2. To be a technical subject matter expert in our (SaaS) business systems integrations, including knowledge transfer to/from others inside and outside the team.
3. To take responsibility for the implementation, development and support of our integrations in operational and project settings.
4. To review and migrate code, including the analysis of both application and integration platform patches and upgrades in relation to their impact on integrations tracking proposed field changes in the source right through to the target, identifying and fixing any issues.
5. To work effectively with internal and external stakeholders through all stages of the software development lifecycle.
6. To contribute to our strategic aims of improving efficiency and reducing technical debt.
7. To support user testing of data integrations and reporting, e.g. through training, and the production of documentation.
8. Monitor performance and other operational aspects of the integrations working with relevant stakeholders to resolve any issues or suggest enhancements.
9. Collaborate with the relevant systems helpdesks, investigate any incidents that are reported, resolve and advise users where appropriate.
What you will bring:
10. Knowledge of, and experience in relational & star schema database design, SQL, PL/SQL, system design, performance tuning and integration.
11. Experience of ETL processes and maintaining Data Warehouses.
12. Learn new skills independently and proactively and are constantly striving to raise technical excellence.
13. Debug complex problems effectively, including in new unexplored applications.
14. Drive and commitment to see activities through to completion meeting deadlines matching pace to the urgency of the situation.
15. Knowledge of how to approach data and system security.
16. Experience of providing 2nd/3rd line support as part of an operational support team.
17. Experience of coordinating technical change in operational and project settings.
18. Strong planning and communication skills.
It would be great if you had knowledge of:
19. HR and Payroll systems and processes
20. Oracle Data Integrator version 12.2.1.3
21. Oracle Database
22. Microsoft SQL Server
We welcome applications from individuals who wish to be considered for part-time working or other flexible working arrangements.
We particularly welcome applications from women and /or candidates from a BME background for this vacancy as they are currently under-represented at this level in our department/institution/Faculty/School/University.
The University actively supports equality, diversity and inclusion and encourages applications from all sections of society.
The University has a responsibility to ensure that all employees are eligible to live and work in the UK.