At a Glance
- Tasks: Develop MI dashboards and reports, write SQL queries, and lead system testing.
- Company: Respected financial services organisation with a focus on innovation.
- Benefits: Up to £45k salary, hybrid work, free breakfasts, and volunteering days.
- Other info: Enjoy a 35-hour work week and monthly social events.
- Why this job: Join a dynamic team during an exciting period of change and investment.
- Qualifications: Experience in MI/Reporting analysis and strong SQL skills required.
The predicted salary is between 36000 - 54000 € per year.
Overview
MI Reporting Analyst — Up to £45k + excellent benefits. Nottinghamshire - Hybrid (Mon and Tues in the office).
Our client is a highly respected and successful financial services organisation and they are recruiting for a MI Reporting Analyst. Start date is ideally in October, and you will be office based in Nottinghamshire on Mondays and Tuesdays. The purpose of the role is to replace someone in the small team of 4 and to come in during a period of change in the business and contribute to organisational readiness for cloud-based services and data platforms.
Responsibilities
- Develop and maintain MI dashboards and reports using advanced Excel (Power Query, PivotTables, VBA).
- 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
In return they offer a hybrid working model, a salary up to £45K and have a wealth of benefits incl 35 hr working week, volunteering days, car parking scheme, pension (up to 9%), free breakfasts daily, birthday holiday & monthly social events.
How to apply
This is a great opportunity to work for a highly customer focused organisation during an exciting period of investment and change. If your skills and experience align and this role appeals to you, then please apply now and we will reply promptly.
MI Reporting Analyst in Mansfield employer: Ultimate Banking Ltd
Join a highly respected financial services organisation in Nottinghamshire as a MI Reporting Analyst, where you will thrive in a supportive and dynamic work culture. With a hybrid working model, competitive salary, and an array of benefits including volunteering days and monthly social events, this role offers not just a job but a pathway for personal and professional growth during an exciting period of change. Be part of a small, dedicated team that values your contributions and fosters a collaborative environment focused on innovation and excellence.
StudySmarter Expert Advice🤫
We think this is how you could land MI Reporting Analyst in Mansfield
✨Tip Number 1
Network like a pro! Reach out to your connections in the financial services sector and let them know you're on the hunt for an MI Reporting Analyst role. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Get your hands dirty with some practical projects. Create a portfolio showcasing your advanced Excel skills, SQL queries, and any dashboards you've built. This will not only impress potential employers but also give you something tangible to discuss during interviews.
✨Tip Number 3
Prepare for those tricky interview questions! Brush up on your knowledge of UAT and system testing, and be ready to share examples of how you've used data mining to deliver insights. We want you to shine when it comes to demonstrating your expertise.
✨Tip Number 4
Don't forget to apply through our website! It's the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search. So, go ahead and hit that apply button!
We think you need these skills to ace MI Reporting Analyst in Mansfield
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the MI Reporting 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 the perfect fit for our team. Mention specific projects or experiences that relate to the responsibilities listed in the job description.
Showcase Your Technical Skills:Since this role involves a lot of technical work, be sure to showcase your expertise in Excel, SQL, and data visualisation. We love seeing examples of dashboards or reports you've created, so don’t hold back!
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep everything organised and ensures your application gets the attention it deserves. Plus, we’ll get back to you promptly!
How to prepare for a job interview at Ultimate Banking Ltd
✨Know Your MI Tools
Make sure you brush up on your advanced Excel skills, especially Power Query, PivotTables, and VBA. Be ready to discuss how you've used these tools in past roles to create impactful MI dashboards and reports.
✨SQL Savvy
Prepare to showcase your SQL expertise. Think of specific examples where you've written complex queries or performed data mining to extract actionable insights. Being able to explain your thought process will impress the interviewers.
✨Engage with Stakeholders
Since the role involves creating wireframes and mock-ups, be prepared to talk about your experience in stakeholder engagement. Share how you've collaborated with others to design solutions that meet business needs.
✨Testing Know-How
Familiarise yourself with UAT and system testing processes. Be ready to discuss any previous experiences leading testing phases, documenting outcomes, and resolving issues. This will show your proactive approach to ensuring quality in your work.
