Senior Reporting Analyst

TN United Kingdom; Cambridge; On-site; GBP 40,000 - 60,000; Full time

Job summary

An exciting opportunity at a prestigious university awaits an experienced Reporting Analyst to join the Business Systems team. This role involves maintaining and developing critical ERP systems while enhancing efficiency and reducing technical debt. You will collaborate with various stakeholders, contributing to strategic initiatives and providing high-level support. If you are passionate about data integration and thrive in a dynamic environment, this position offers a unique chance to make a significant impact in an educational institution committed to equality and diversity.

Qualifications

• Experience in relational & star schema database design and SQL.
• Knowledge of ETL processes and maintaining Data Warehouses.
• Ability to debug complex problems effectively.

Responsibilities

• Develop and support integrations in operational and project settings.
• Review and migrate code, analyzing patches and upgrades.
• Support user testing of data integrations and reporting.

Skills

SQL

PL/SQL

Data Warehousing

ETL Processes

System Design

Performance Tuning

Data Security

Communication Skills

Debugging

Planning

Tools

Oracle Data Integrator

Oracle Database

Microsoft SQL Server

Job description

Social network you want to login/join with:

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:

• 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.
• To be a technical subject matter expert in our (SaaS) business systems integrations, including knowledge transfer to/from others inside and outside the team.
• To take responsibility for the implementation, development and support of our integrations in operational and project settings.
• 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.
• To work effectively with internal and external stakeholders through all stages of the software development lifecycle.
• To contribute to our strategic aims of improving efficiency and reducing technical debt.
• To support user testing of data integrations and reporting, e.g. through training, and the production of documentation.
• Monitor performance and other operational aspects of the integrations working with relevant stakeholders to resolve any issues or suggest enhancements.
• Collaborate with the relevant systems helpdesks, investigate any incidents that are reported, resolve and advise users where appropriate.

What you will bring:

• Knowledge of, and experience in relational & star schema database design, SQL, PL/SQL, system design, performance tuning and integration.
• Experience of ETL processes and maintaining Data Warehouses.
• Learn new skills independently and proactively and are constantly striving to raise technical excellence.
• Debug complex problems effectively, including in new unexplored applications.
• Drive and commitment to see activities through to completion meeting deadlines matching pace to the urgency of the situation.
• Knowledge of how to approach data and system security.
• Experience of providing 2nd/3rd line support as part of an operational support team.
• Experience of coordinating technical change in operational and project settings.
• Strong planning and communication skills.

It would be great if you had knowledge of:

• HR and Payroll systems and processes
• Oracle Data Integrator version 12.2.1.3
• Oracle Database
• 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.