Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform complex data into actionable insights and enhance analytics workflows with AI.
- Company: Join a leading Lloyd’s Insurer with a focus on innovation and collaboration.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic Agile environment with mentorship opportunities and career advancement.
- Why this job: Make a real impact by embedding analytics in decision-making processes.
- Qualifications: 5-10 years in data analytics, strong SQL skills, and advanced Power BI experience.
The predicted salary is between 60000 - 75000 £ per year.
We are currently partnering with a market-leading Lloyd’s Insurer to recruit a Senior Data Analyst. Reporting into the Data Analytics Manager, the successful candidate will play a key part in building long-term data partnerships with underwriting, claims, and exposure management teams, ensuring analytics becomes embedded in everyday decision-making rather than delivered as standalone reports.
Key responsibilities include:
- Translating broad commercial questions into clear, actionable analyses and dashboard requirements.
- Exploring and implementing AI-driven enhancements to analytics workflows, including the use of LLMs and agentic tools for data exploration, code generation, documentation, and insight generation.
- Supporting the Data Analytics Manager in developing external data and analytics propositions, from discovery and prototyping through to delivery.
- Embedding and upholding the team’s BI and analytics development lifecycle, including documentation, peer review, naming conventions, and production sign-off processes.
- Maintaining robust source-control practices for Power BI assets, including PBIP/TMDL formats, Git repositories, feature branches, pull requests, and structured commit histories.
- Contributing to Power BI governance, including Dev/Test/Prod environments, deployment pipelines, dataset certification, refresh monitoring, and access controls.
- Coaching and mentoring analysts and BI developers on SQL, DAX, data modelling, visualisation best practices, and engineering standards.
- Collaborating with Data Engineering teams to shape semantic layers and data marts that align with analytics and business requirements.
- Delivering complex analytics initiatives end-to-end, including scoping, estimation, implementation, handover, and post-delivery review.
- Operating within an Agile framework, contributing to backlog prioritisation, breaking down work into epics and user stories, and providing realistic delivery estimates.
Requirements:
- 5–10 years’ experience in data analytics or BI, including experience within a Lloyd’s syndicate, managing agent, London Market broker, or specialty (re)insurer.
- Strong SQL skills, including query optimisation and experience with the Azure data stack (e.g. Data Factory, Synapse, or Fabric).
- Advanced Power BI capabilities, including data modelling, DAX, Power Query/M, performance optimisation, and deployment pipelines.
Senior Data Analyst (SQL, Power BI) in City of London employer: Edenbrook
Contact Detail:
Edenbrook Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Analyst (SQL, Power BI) in City of London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at Lloyd’s or similar firms. A friendly chat can lead to insider info about job openings and even referrals.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL and Power BI projects. Use real-world examples that demonstrate how you've turned data into actionable insights. This will make you stand out during interviews.
✨Tip Number 3
Prepare for the interview by brushing up on Agile methodologies and data governance practices. Be ready to discuss how you've implemented these in past roles, as it shows you're not just a tech whiz but also a team player.
✨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.
We think you need these skills to ace Senior Data Analyst (SQL, Power BI) in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the job description. Highlight your experience with SQL, Power BI, and any relevant projects that showcase your skills in data analytics. We want to see how you can translate broad commercial questions into actionable insights!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for the Senior Data Analyst role. Mention your experience in the Lloyd’s market and how you’ve successfully collaborated with teams to embed analytics in decision-making.
Showcase Your Technical Skills: Don’t hold back on your technical prowess! Be specific about your SQL skills, Power BI capabilities, and any experience with AI-driven enhancements. We love seeing candidates who can demonstrate their knowledge of data modelling and visualisation best practices.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it shows you’re keen to join our team!
How to prepare for a job interview at Edenbrook
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss query optimisation and share examples of how you've used SQL in past projects. This role requires strong technical expertise, so demonstrating your proficiency will definitely impress.
✨Showcase Your Power BI Mastery
Since this position heavily relies on Power BI, come ready to talk about your experience with data modelling, DAX, and performance optimisation. If possible, bring along a portfolio of dashboards you've created to visually demonstrate your capabilities.
✨Understand the Business Context
Familiarise yourself with the Lloyd’s insurance market and the specific challenges it faces. Being able to translate commercial questions into actionable analyses will show that you understand the bigger picture and can contribute meaningfully to the team.
✨Emphasise Collaboration and Mentorship
This role involves coaching and mentoring others, so be prepared to discuss your experience in leading teams or sharing knowledge. Highlight any instances where you've collaborated with data engineering teams or contributed to Agile processes, as this will showcase your teamwork skills.