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
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Ultimate Banking Ltd. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace MI Reporting Analyst in Mansfield
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Ultimate Banking Ltd.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Ultimate Banking Ltd's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Ultimate Banking Ltd
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Ultimate Banking Ltd.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Ultimate Banking Ltd will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Ultimate Banking Ltd employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
