Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Create and maintain MI dashboards, write SQL queries, and lead system testing.
- Company: Join a dynamic financial services team in Nottinghamshire with a hybrid work model.
- Benefits: Up to £45k salary, volunteering days, free breakfasts, and monthly social events.
- Why this job: Make an impact by delivering actionable insights and enhancing stakeholder engagement.
- Qualifications: Experience in MI/Reporting analysis and strong SQL skills required.
- Other info: Enjoy a 35-hour work week with excellent career growth opportunities.
The predicted salary is between 36000 - 54000 £ per year.
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
#J-18808-Ljbffr
Management Information Analyst employer: Ultimate Banking
Contact Detail:
Ultimate Banking Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Management Information Analyst
✨Tip Number 1
Network like a pro! Reach out to folks in the financial services sector, especially those who work with MI reporting. A casual chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! When you get the chance to meet potential employers, bring along examples of your dashboards or reports. Nothing beats a visual representation of what you can do, especially with advanced Excel and SQL.
✨Tip Number 3
Prepare for the UAT talk! Since this role involves system testing, brush up on your understanding of UAT processes. Be ready to discuss how you've handled testing in the past and any challenges you've overcome.
✨Tip Number 4
Apply through our website! We love seeing applications directly from candidates who are keen on joining us. It shows initiative and gives you a better chance to stand out in the crowd.
We think you need these skills to ace Management Information Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Management Information Analyst role. Highlight your experience with advanced Excel, SQL, and any relevant financial services background. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your previous experiences have prepared you for it. We love seeing genuine enthusiasm for the position.
Showcase Your Technical Skills: Since this role involves complex SQL and data visualisation, make sure to showcase these skills in your application. If you've created dashboards or reports before, mention them! We’re keen on seeing your technical prowess.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts!
How to prepare for a job interview at Ultimate Banking
✨Know Your Data Tools
Make sure you brush up on your advanced Excel skills, especially Power Query, and be ready to discuss how you've used them in past roles. Familiarise yourself with SQL queries too, as you'll likely be asked to demonstrate your ability to extract and analyse data.
✨Showcase Your Reporting Skills
Prepare examples of MI dashboards and reports you've developed. Be ready to explain the process you followed, the challenges you faced, and how your insights led to actionable outcomes. This will show your potential employer that you can deliver results.
✨Understand UAT and Testing
Since the role involves leading testing of third-party systems, make sure you can articulate your experience with UAT and system testing. Think of specific instances where you documented outcomes and resolved issues, as this will highlight your problem-solving skills.
✨Engage Stakeholders Effectively
Be prepared to discuss how you've created wireframes and mock-ups for stakeholder engagement. Highlight your communication skills and how you ensure that all parties are aligned during the solution design process. This is crucial for a role that requires collaboration.