At a Glance
- Tasks: Own regulatory reporting processes and manage data pipelines in the Lloyd's market.
- Company: Dynamic insurance firm with a focus on innovation and collaboration.
- Benefits: Competitive salary, hybrid work model, and opportunities for professional growth.
- Why this job: Make a real impact in regulatory reporting while working with top industry professionals.
- Qualifications: Experience in data or regulatory reporting within the Lloyd's or London Market.
- Other info: Join a fast-paced environment with excellent career advancement potential.
The predicted salary is between 80000 - 80000 £ per year.
Location: London Market (Hybrid)
Team: Business Intelligence
Reporting to: BI Manager
Salary: £80,000
Working Pattern: 4 days per week in office
The Opportunity
We are seeking a highly capable Business Intelligence & Regulatory Reporting Analyst to play a central role in our data, reserving, and regulatory reporting operations within the Lloyd's market. This is a hands-on, high-responsibility position offering end-to-end ownership of Lloyd's and regulatory reporting processes, alongside stewardship of reserving data pipelines and technical provisions. You will operate with a high degree of autonomy, working closely with actuarial, finance, and audit stakeholders while ensuring accuracy, completeness, and regulatory compliance.
Key Responsibilities
- Regulatory & Lloyd's Reporting (Core Focus)
- Take full ownership of Lloyd's and regulatory returns, including submissions such as SUK (Solvency UK), RRQ, RRA, PMD, QMB, QMR, NAIC and TRIAManage the end-to-end reporting lifecycle: from SQL data extraction and validation through to template population and submission
- Act as the primary contact for Lloyd's data validation queries, providing robust justification and supporting evidence for submitted data
- Ensure all outputs meet Lloyd's market standards, deadlines, and governance requirements
- Reserving & Technical Provisions
- Own and manage reserving data processes, including regular extract runs and data validation
- Maintain and enhance the technical provisions process, working closely with actuarial and finance teams
- Support the production of Reserving Committee reporting, ensuring accuracy and consistency
- Develop and manage tools (including Excel/VBA-based applications) used in reserving workflows
- Audit, Controls & Governance
- Lead responses to external audit and SOX requests, often within tight timelines
- Prepare clear documentation, respond to queries, and implement process improvements arising from audit findings
- Maintain robust audit trails and documentation to support regulatory scrutiny
- Process Improvement & Documentation
- Develop and maintain comprehensive process documentation
- Continuously improve data quality, efficiency, and control across reporting and reserving processes
Skills & Experience
Essential Experience
- Proven experience in a data, BI, or regulatory reporting role within the Lloyd's or London Market insurance environment
- Strong, hands-on experience with Lloyd's regulatory returns (e.g. RRA, RRQ, Solvency II / Solvency UK, PMD, QMB)
- Solid understanding of reserving concepts and technical provisions within an insurance context
- Experience managing end-to-end reporting processes independently
Technical Expertise
- Advanced SQL Server skills (complex queries, stored procedures, performance optimisation)
- Advanced Excel skills, including VBA and automation
- Familiarity with Power BI / Power Query and broader Microsoft toolset
Regulatory Reporting Analyst in City of London employer: I3 Resourcing Limited
Contact Detail:
I3 Resourcing Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Regulatory Reporting Analyst in City of London
✨Tip Number 1
Network like a pro! Reach out to folks in the Lloyd's market on LinkedIn or at industry events. A friendly chat can open doors that a CV just can't.
✨Tip Number 2
Show off your skills! If you’ve got experience with SQL or Excel, consider creating a mini-project or dashboard to demonstrate your abilities. Share it during interviews to stand out!
✨Tip Number 3
Prepare for those tricky questions! Brush up on your knowledge of regulatory returns and be ready to discuss how you've handled data validation in the past. Confidence is key!
✨Tip Number 4
Don’t forget to apply through our website! We love seeing candidates who are genuinely interested in joining us. Plus, it’s a great way to ensure your application gets noticed.
We think you need these skills to ace Regulatory Reporting Analyst in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Regulatory Reporting Analyst role. Highlight your experience with Lloyd's regulatory returns and any relevant BI skills. We want to see how your background fits perfectly with what we're looking for!
Showcase Your Skills: Don’t just list your skills; demonstrate them! Use specific examples from your past roles that showcase your SQL, Excel, and reporting expertise. We love seeing how you’ve tackled challenges in the past.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Explain why you're passionate about the role and how your experience aligns with our needs. We appreciate a personal touch that shows us you’re genuinely interested in joining our team.
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. Let’s make this happen!
How to prepare for a job interview at I3 Resourcing Limited
✨Know Your Regulatory Returns
Make sure you’re well-versed in the specific regulatory returns mentioned in the job description, like SUK, RRQ, and RRA. Brush up on the requirements and processes for each, as being able to discuss them confidently will show your expertise and readiness for the role.
✨Showcase Your SQL Skills
Since advanced SQL skills are crucial for this position, prepare to demonstrate your knowledge. Consider bringing examples of complex queries you've written or optimised in previous roles. If possible, practice explaining your thought process behind these queries to highlight your problem-solving abilities.
✨Understand the Lloyd's Market
Familiarise yourself with the Lloyd's market and its unique regulatory environment. Being able to discuss current trends or challenges in the market will not only impress your interviewers but also show that you’re genuinely interested in the industry.
✨Prepare for Process Improvement Questions
Expect questions about how you’ve improved processes in past roles. Think of specific examples where you enhanced data quality or efficiency, especially in reporting or reserving processes. This will demonstrate your proactive approach and ability to add value to their operations.