Management Information Analyst

Ultimate Banking; East Midlands; Hybrid; GBP 40,500 - 49,500; Full time

Benefits offered by this job

Volunteering days

Car parking scheme

Pension (up to 9%)

Free breakfasts daily

Birthday holiday

Monthly social events

Job summary

A financial services firm in Nottinghamshire seeks a Recruitment Expert for a MI Reporting Analyst role. This position involves developing MI dashboards, leveraging advanced SQL queries, and overseeing UAT for third-party systems. Offering a hybrid working model, the annual salary is up to £45k along with benefits such as pension contributions, volunteer days, and social events.

Qualifications

• Experience as a Business Analyst or MI/Reporting Analyst from within the financial services sector.
• Strong understanding of UAT and system testing.
• Skilled in complex SQL for data extraction, transformation, and analysis.

Responsibilities

• Develop and maintain MI dashboards and reports using advanced Excel.
• Write advanced SQL queries and apply data mining to deliver actionable insights from complex datasets.
• Lead testing of third-party systems, documenting outcomes and resolving issues ahead of business UAT.

Skills

Business Analysis

Advanced SQL

Excel

Data Mining

UAT

Data Visualization

Tools

CXAIR

Power Query

VBA

Job description

Overview

Recruitment Expert – Mortgages, Savings and Lending / MI Reporting Analyst role in Nottinghamshire. Hybrid (Mon and Tues in the office). Up to £45k + benefits. Start ideally in October.

Responsibilities

• Develop and maintain MI dashboards and reports using advanced Excel (Power Query,
• Write advanced SQL queries and apply data mining to deliver actionable insights from complex datasets.
• Create wireframes and mock-ups to support stakeholder engagement and solution design.
• Lead testing of third-party systems, documenting outcomes and resolving issues ahead of business UAT.
• Manage BAU changes, including rate updates, data provision, and third-party service requests.

Requirements

• Experience as a Business Analyst or MI/Reporting Analyst from within the financial services sector.
• Strong understanding of UAT and system testing.
• Skilled in complex SQL for data extraction, transformation, and analysis.
• Experienced in data mining to identify trends and actionable insights.
• Advanced Excel and VBA expertise; proficiency in CXAIR would be ideal.
• Skilled in data visualisation and dashboard development.

Benefits

Hybrid working model; 35 hour working week; salary up to £45K; benefits incl volunteering days, car parking scheme, pension (up to 9%), free breakfasts daily, birthday holiday & monthly social events.

Location

Nottinghamshire, England, United Kingdom