Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data and create insightful reports using Excel and Power BI.
- Company: Leading London Market insurer undergoing a major data transformation.
- Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
- Why this job: Join a dynamic team and make a real impact during an exciting data transition.
- Qualifications: Experience in data analysis within the London Market and strong Excel skills.
- Other info: Collaborate with various departments and enhance your analytical skills.
The predicted salary is between 36000 - 60000 £ per year.
A leading London Market insurer is undergoing a major data platform transformation, migrating from a legacy third-party data solution to a new enterprise data platform. During this transition period, the business requires an experienced Data Analyst to ensure continuity of business‑critical reporting and data integrity.
This role will play a key part in maintaining and delivering MI using advanced Excel and Power BI, while performing detailed data reconciliation between legacy and new platforms. The successful contractor will bring strong Speciality Insurance experience and be confident engaging with multiple departments across the business.
Responsibilities:- Maintain and enhance MI, regulatory, and operational reporting using Excel and Power BI during the data platform migration.
- Perform detailed data reconciliation and validation across legacy systems and the new data platform.
- Work closely with Underwriting, Claims, Finance, and Actuarial teams to gather requirements and support reporting needs.
- Build and maintain dashboards, reports, and ad-hoc analysis to support day‑to‑day decision‑making.
- Support the wider transformation programme by identifying data quality issues, inconsistencies, and remediation actions.
- Proven Data Analyst experience within the London Market, with strong Speciality Insurance knowledge.
- Advanced Excel skills, including complex formulas, pivot tables, and data analysis.
- Strong hands‑on experience developing dashboards and reports in Power BI.
- Demonstrable experience with data reconciliation, data quality assurance, and working across multiple data sources.
- Excellent stakeholder engagement skills, with the ability to communicate effectively across technical and non‑technical teams.
Data Analyst in City of London employer: Pioneer Search
Contact Detail:
Pioneer Search Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst in City of London
✨Tip Number 1
Network like a pro! Reach out to your connections in the insurance and data analysis sectors. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best work with Power BI and Excel. Include dashboards, reports, and any data reconciliation projects you've tackled. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on your knowledge of the London Market and Speciality Insurance. Be ready to discuss how your experience aligns with their needs, especially around data integrity and reporting. Confidence is key!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be perfect for you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Data Analyst in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with data analysis, especially in the London Market and Speciality Insurance. We want to see how your skills in Excel and Power BI shine through, so don’t hold back!
Showcase Your Projects: Include specific examples of projects where you've maintained MI or performed data reconciliation. We love seeing real-world applications of your skills, so share those success stories with us!
Engage with Stakeholders: Since this role involves working closely with various teams, mention any experience you have in stakeholder engagement. We’re looking for someone who can communicate effectively across different departments, so let us know how you’ve done this before.
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. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Pioneer Search
✨Know Your Tools Inside Out
Make sure you’re well-versed in Excel and Power BI. Brush up on advanced functions, pivot tables, and how to create impactful dashboards. Being able to demonstrate your skills with real examples during the interview will show that you’re not just familiar with these tools, but that you can use them effectively.
✨Understand the Business Context
Familiarise yourself with the London Market and Speciality Insurance. Research the company’s recent projects or challenges related to data migration. This knowledge will help you engage meaningfully with interviewers and show that you’re genuinely interested in their business.
✨Prepare for Stakeholder Engagement Scenarios
Since this role involves working with various departments, think of examples where you’ve successfully communicated complex data insights to non-technical teams. Be ready to discuss how you’ve gathered requirements and supported reporting needs in past roles.
✨Showcase Your Problem-Solving Skills
Data reconciliation and quality assurance are key parts of this job. Prepare to discuss specific instances where you identified data quality issues and the steps you took to resolve them. Highlighting your analytical thinking will demonstrate your value as a Data Analyst.
