Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform commercial questions into actionable analyses and enhance workflows with AI-driven tools.
- Company: Join a leading Lloyd’s Insurer with a focus on data-driven decision-making.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative Agile environment with mentorship opportunities and career advancement.
- Why this job: Make a real impact by embedding analytics in everyday business decisions.
- Qualifications: 5-10 years in data analytics, strong SQL skills, and advanced Power BI experience.
The predicted salary is between 60000 - 80000 £ 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:
- Translate broad commercial questions into clear, actionable analyses and dashboard requirements.
- Explore and implement AI-driven enhancements to analytics workflows, including the use of LLMs and agentic tools for data exploration, code generation, documentation, and insight generation.
- Support the Data Analytics Manager in developing external data and analytics propositions, from discovery and prototyping through to delivery.
- Embed and uphold the team’s BI and analytics development lifecycle, including documentation, peer review, naming conventions, and production sign-off processes.
- Maintain robust source-control practices for Power BI assets, including PBIP/TMDL formats, Git repositories, feature branches, pull requests, and structured commit histories.
- Contribute to Power BI governance, including Dev/Test/Prod environments, deployment pipelines, dataset certification, refresh monitoring, and access controls.
- Coach and mentor analysts and BI developers on SQL, DAX, data modelling, visualisation best practices, and engineering standards.
- Collaborate with Data Engineering teams to shape semantic layers and data marts that align with analytics and business requirements.
- Deliver complex analytics initiatives end-to-end, including scoping, estimation, implementation, handover, and post-delivery review.
- Operate 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 SQL Data Analyst in City of London employer: Edenbrook
Contact Detail:
Edenbrook Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior SQL Data Analyst 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. This is your chance to demonstrate how you translate complex data into actionable insights, just like the role requires.
✨Tip Number 3
Prepare for interviews by brushing up on Agile methodologies and data governance practices. Be ready to discuss how you've contributed to analytics initiatives and collaborated with teams in the past.
✨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 SQL Data Analyst in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the job description. Highlight your SQL skills, Power BI experience, and any relevant work in the Lloyd’s market. 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 the perfect fit for the Senior Data Analyst role. Share specific examples of how you've tackled complex analytics initiatives and collaborated with teams.
Showcase Your Technical Skills: Don’t hold back on your technical prowess! Detail your experience with SQL, DAX, and the Azure data stack. We love seeing candidates who can demonstrate their ability to optimise queries and manage data effectively.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
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 ready to discuss query optimisation techniques and share examples of how you've used SQL in past projects. This role requires strong SQL capabilities, so demonstrating your expertise will definitely impress.
✨Showcase Your Power BI Mastery
Prepare to talk about your experience with Power BI, especially around data modelling and DAX. Bring along examples of dashboards you've created or enhanced, and be ready to explain your thought process behind them. This will show that you can translate complex data into actionable insights.
✨Understand the Business Context
Familiarise yourself with the Lloyd’s insurance market and the specific challenges it faces. Being able to relate your analytical skills to real-world business problems will demonstrate your ability to embed analytics into decision-making processes, which is key for this role.
✨Emphasise Collaboration and Mentorship
This position 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 a project within an Agile framework to show you're a team player.