At a Glance
- Tasks: Analyse complex datasets and drive automation initiatives to enhance business processes.
- Company: Join a market-leading financial services organisation in London.
- Benefits: Competitive salary, diverse work environment, and opportunities for professional growth.
- Why this job: Make a real impact by improving operations and reporting in a dynamic industry.
- Qualifications: Strong SQL and Python skills, with experience in financial services and data analysis.
- Other info: Collaborate with various teams and contribute to innovative data-driven solutions.
The predicted salary is between 28800 - 48000 £ per year.
Robert Half Technology are assisting a market leading financial services organisation to recruit a Business Data Analyst on a 6 month contract to perm basis. Onsite required - London based.
This role sits at the intersection of data, operations, and business strategy, with a strong focus on improving middle office processes, enhancing reporting capabilities, and driving automation initiatives. You will work closely with Operations, Finance, Technology, and Front Office stakeholders to analyse business processes, identify efficiency opportunities, and deliver scalable data-driven solutions.
Role
- The Business Data Analyst will analyse complex datasets to support operational, financial, and regulatory reporting.
- Develop and maintain SQL queries and data models to support business intelligence and reporting needs.
- Use Python to automate workflows, improve data quality checks, and streamline recurring processes.
- Build and maintain advanced Excel models and reporting tools (including Power Query, Power Pivot, VBA where applicable).
- Review and optimise middle office processes, identifying control gaps and automation opportunities.
- Partner with stakeholders to gather business requirements and translate them into technical solutions.
- Drive process automation initiatives to improve accuracy, reduce manual intervention, and increase scalability.
- Support reconciliation, valuation, and trade lifecycle analysis where required.
- Contribute to data governance, documentation, and control frameworks.
- Assist with system enhancements and implementation projects.
Profile
- The Business Data Analyst will have strong SQL skills (query writing, joins, performance optimisation, data manipulation).
- Proficiency in Python for data analysis and automation (e.g., pandas, scripting, APIs).
- Advanced Excel skills (complex formulas, pivot tables, data modelling).
- Proven experience working in a Middle Office role within a financial services environment.
- Strong understanding of trade lifecycle, reconciliations, valuations, and operational controls.
- Experience reviewing and improving operational processes.
- Demonstrated ability to drive automation and efficiency initiatives.
- Strong analytical thinking and problem-solving skills.
- Excellent communication skills with the ability to work across technical and non-technical teams.
- Experience with Advent Geneva.
- Exposure to data visualisation tools (e.g., Power BI, Tableau).
- Experience with financial instruments (equities, fixed income, derivatives, alternatives).
Company
Market leading financial services organisation with offices in London. Onsite required - London based.
Salary & Benefits
The salary range/rates of pay is dependent upon your experience, qualifications or training.
Business Data Analyst employer: Robert Half
Contact Detail:
Robert Half Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Data Analyst
✨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 lookout for a Business Data 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 real-world projects. Whether it's automating a process using Python or building a complex Excel model, showcase your skills through personal projects or freelance gigs. This not only boosts your portfolio but also gives you something tangible to discuss in interviews.
✨Tip Number 3
Prepare for those interviews by brushing up on your SQL and Python skills. Be ready to tackle technical questions and even live coding challenges. Practising common data analysis scenarios can help you feel more confident when it’s your turn to shine.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit for you. Plus, applying directly can sometimes give you an edge over other candidates. So, what are you waiting for? Get clicking!
We think you need these skills to ace Business Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Business Data Analyst role. Highlight your SQL, Python, and Excel skills, and showcase any relevant experience in financial services. We want to see how your background aligns with 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 you can contribute to our team. Be sure to mention specific projects or experiences that relate to the job description.
Showcase Your Analytical Skills: In your application, don’t forget to highlight your analytical thinking and problem-solving abilities. Share examples of how you've used data to drive decisions or improve processes in previous roles. We love seeing those real-world applications!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you're serious about joining our team at StudySmarter!
How to prepare for a job interview at Robert Half
✨Know Your Data Inside Out
Make sure you’re well-versed in SQL and Python, as these are crucial for the role. Brush up on your query writing and data manipulation skills, and be ready to discuss how you've used these tools in past projects.
✨Understand the Business Context
Familiarise yourself with middle office processes and the financial services landscape. Be prepared to talk about how your analytical skills can improve operational efficiency and support business strategy.
✨Showcase Your Problem-Solving Skills
Think of specific examples where you've identified inefficiencies and implemented solutions. Highlight any automation initiatives you've led, especially those that improved accuracy or reduced manual work.
✨Communicate Effectively
Since you'll be working with both technical and non-technical teams, practice explaining complex concepts in simple terms. Good communication can set you apart, so be ready to demonstrate your ability to bridge the gap between different stakeholders.