Senior Reporting Analyst

University of Cambridge; Cambridge; On-site; GBP 40,000 - 70,000; Full time

Job summary

An exciting opportunity has opened for a Senior Reporting Analyst at a prestigious institution. This role focuses on Data Engineering and involves collaborating with a dynamic team to enhance business systems and improve data integration processes. You'll work with cutting-edge tools like Microsoft Fabric and play a crucial role in supporting critical ERP systems across various departments. If you are passionate about data and eager to contribute to innovative solutions, this is the perfect chance to advance your career in a supportive environment that values diversity and inclusion.

Qualifications

• Experience in relational & star schema database design and SQL.
• Knowledge of ETL processes and Data Warehouses.

Responsibilities

• Develop and maintain business systems integrations.
• Support user testing of data integrations and reporting.

Skills

SQL

Data Engineering

ETL processes

Debugging skills

System design

Performance tuning

Data security

Communication skills

Education

Bachelor's degree in a relevant field

Tools

Microsoft Fabric

Oracle Data Integrator

Oracle Database

Microsoft SQL Server

Job description

Join to apply for the Senior Reporting Analyst role at University of Cambridge

1 week ago Be among the first 25 applicants

Join to apply for the Senior Reporting Analyst role at University of Cambridge

Get AI-powered advice on this job and more exclusive features.

An exciting opportunity has arisen at the University for an experienced technical Reporting Analyst to join the Business Systems team. This role is mainly focused on Data Engineering activities, and we are looking for someone with either experience in this area or demonstrable capability and interest in moving into Data Engineering.

We are currently implementing the Microsoft Fabric platform, and the work could involve using a mixture of this product alongside supporting existing ETL platforms, with training and support provided as required. Located within University Information Services (UIS), the Business Systems team is responsible for maintaining and developing the University's critical ERP systems for handling administrative data across HR, Finance, Student, and Teaching & Learning.

What You Will Do

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, involving collaboration with Reporting Analysts, Application Specialists, Database Administrators, Functional Analysts, Testers, and stakeholders in a dynamic environment.

• Review requirements, develop specifications, and design effective solutions as part of a multi-disciplinary team.
• Serve as a technical subject matter expert in business systems reporting platforms, including knowledge transfer.
• Review and migrate code, analyzing application and platform changes, and fixing issues related to data flows.
• Work effectively with stakeholders throughout the software development lifecycle.
• Support user testing of data integrations and reporting, including training and documentation.
• Monitor platform performance and operational aspects, resolving issues and suggesting improvements.
• Collaborate with helpdesks, investigate incidents, resolve issues, and advise users.

What You Will Have

• Knowledge and experience in relational & star schema database design, SQL, PL/SQL, system design, performance tuning, and integration.
• Experience with ETL processes and Data Warehouses.
• Ability to learn new skills proactively and independently.
• Strong debugging skills, including in new applications.
• Commitment to completing activities on time and managing priorities.
• Understanding of data and system security.
• Experience providing second/third-line operational support.
• Experience coordinating technical changes in projects and operations.
• Strong planning and communication skills.

**Preferred Skills:**
• Microsoft Fabric
• Oracle Data Integrator
• Oracle Database
• Microsoft SQL Server

We welcome applications from women and candidates from BME backgrounds.

Click the 'Apply' button below to register and apply online.

All queries should be directed to [e-mail], quoting reference VC43792.

The University supports equality, diversity, and inclusion and encourages applications from all societal sections.

The University ensures all employees are eligible to work in the UK.

• Further Particulars

Apply online

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Research, Analyst, and Information Technology

Industries

• Research Services

Referrals increase your chances of interviewing at University of Cambridge by 2x

Get notified about new Senior Reporting Analyst jobs in Cambridge, England, United Kingdom.

Cambridge, England, United Kingdom 2 weeks ago