Senior Data Analyst

AEGIS London; Greater London; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

AEGIS London is seeking a Senior Data Analyst to partner with underwriting, claims and exposure management teams. You will build analytics into day-to-day decision-making, lead governance of BI assets and mentor analysts in SQL, DAX and data modelling.

You will apply new techniques, including AI tooling within analytics workflows, and contribute to the team’s maturity with robust version control and release processes.

Qualifications

• Strong experience in data analytics or BI roles, ideally in insurance/finance.
• Advanced SQL with data stack tooling and data modelling.
• Expertise in Power BI including data modelling, DAX, and deployment pipelines.
• Proven peer review, QA, and governance practices in BI projects.
• Excellent communication and stakeholder management skills.

Responsibilities

• Act as senior analytics business partner to underwriting classes to improve pricing and exposure management.
• Translate business questions into scoped analyses and dashboards.
• Collaborate across teams to automate and accelerate analytics workflows, including AI tooling.
• Lead governance for BI assets, source control, and deployment practices.
• Deliver end-to-end analytics workstreams from scoping to post-implementation review.

Skills

SQL

Power BI

DAX

Stakeholder engagement

Communication

Tools

Azure Data Factory

Synapse

Fabric

Git-based version control

Power BI deployment pipelines

Job description

Time Type: Full time Working Pattern: Hybrid

Purpose of the Role Reporting to the Data Analytics Manager, the Senior Data Analyst is a hands‑on individual contributor who helps the team through its shift from platform delivery (post-EDP) toward value‑added analytics and commercial insight. The role contributes to building lasting data partnerships with the underwriting, claims and exposure management teams, so that analytics is embedded in day‑to‑day decision‑making rather than delivered as isolated reports. The role holder will apply and role‑model the technical standards the team works to peer review, version control, documentation, testing and release management -and will aid the Data Analytics Manager to raise the overall maturity of the function. They will contribute to the most complex analyses and help introduce new techniques, including the practical application of AI tools within the analytics workflow.

Duties and Accountabilities

Business partnering and value‑added analytics

Act as the senior analytics business partner to one or more underwriting classes, proactively identifying where analytics can improve pricing, portfolio steering, renewal decisions and exposure management. Translate open‑ended commercial questions into well‑scoped analyses and dashboard requirements. Closely collaborate with the wider business to identify areas of automation and acceleration to improve operational efficiency. Identify practical opportunities to enhance the analytics workflow with AI tooling -for example, using LLMs and agentic tools for data exploration, code generation, documentation, and surfacing insight to underwriters. Support the Data Analytics Manager in shaping external data analytical propositions -from discovery and prototyping through to packaging and delivery.

Team maturity, standards and Power BI governance

Apply and help embed the team’s development lifecycle for BI and analytics assets, including naming conventions, documentation, peer review and sign‑off before production release. Follow and help maintain robust source‑control practices for Power BI content – use of PBIP / TMDL format, Git‑backed repositories, feature branches, pull requests and meaningful commit history. Contribute to Power BI workspace governance: clear Dev / Test / Prod separation, deployment pipelines, dataset certification / endorsement, refresh monitoring and access management. Coach analysts and BI developers on SQL, DAX, data modelling, visual design and engineering hygiene; take part in code / report reviews and knowledge‑sharing sessions. Work closely with Data Engineering on changes to the semantic / curated layer and data marts, ensuring analytics and business needs are reflected in platform design. Deliver complex analytics workstreams end‑to‑end – scoping, estimation, delivery, hand‑over and post‑implementation review. Work within an Agile framework: break down requirements into epics and user stories, contribute to backlog prioritisation with the Data Analytics Manager, and provide realistic estimates.

Skills, Knowledge and Experience

Essential

• Well developed and demonstrable experience in a data analytics or BI role, preferably in an insurance or finance environment.
• Advanced SQL, including query optimisation and working with the Azure data stack (Data Factory, Synapse / Fabric, SQL‑based semantic layers).
• Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query / M, performance tuning, RLS, and deployment via pipelines.
• Understanding of Power BI engineering discipline: PBIP / TMDL source format, Git‑based version control, pull‑request review, structured release and rollback process; demonstrable experience of these practices in a team.
• Proven ability to carry out peer review and QA of analytics work – spotting model errors, DAX issues, performance problems and UX weaknesses, and giving constructive feedback.
• Excellent written and verbal communication skills, including presenting to underwriting and internal stakeholders.
• Strong stakeholder engagement, with a track record of turning ambiguous business problems into delivered analytical outcomes.

Desirable

• Well developed experience in a Lloyd’s syndicate, managing agent, London Market broker or specialty (re)insurer.
• Python for data analysis (pandas / notebooks) and an appreciation of wider data science techniques, enough to collaborate credibly with Data Scientists and Actuarial.
• Hands‑on experience applying AI / LLM tooling to analytics work (e.g. Co‑pilot for Power BI / Fabric, MCP‑style integrations, agentic assistants, code‑generation tools) with a pragmatic view on where they add value.
• Experience with Microsoft Fabric, dbt, Azure DevOps / GitHub Actions, and data‑quality tooling.

AEGIS Values

Fairness and respect

We make decisions considering the best interests of key stakeholders. We are direct and straightforward in our actions, working collaboratively to create a culture of fairness and respect.

Open and inclusive

We act with integrity, valuing diversity of thought and background. We take time to listen to the needs of our customers, stakeholders and colleagues working together to seek and share information.

Ambitious

We have a passion for success, aspiring to be recognised as best in class. We embrace new opportunities, encouraging innovation in pursuit of our goals.

Striving to be better

We strive to improve at all times, challenging complacency, being agile and adapting to change. We always seek to improve our customers’ experience with us.

Investing in people’s potential

We provide an environment where each employee can reach their personal potential. We encourage personal accountability for performance and individual ownership for growth and success.

AEGIS London is an equal opportunities employer and recognises the value of a diverse workforce in facilitating better decision making and business growth. We encourage a variety of differing views, perspectives and insights to create a collaborative working environment. Diversity and Inclusion are fundamental to our business and we encourage applications from all backgrounds recognising the diversity of society and our customers. It’s important to us that you are able to perform at your best when applying for a role with AEGIS London. If there are any adjustments we can reasonably make to ensure that the process is accessible for you please telephone us on [phone] or email [e-mail] As a business, we understand individual circumstances may differ and aim to be adaptable and to support flexible working practices. Talk to our recruitment team to understand how AEGIS London can help support you in reaching your full potential AEGIS London writes a diversified book of business through Syndicate 1225 at Lloyd’s where, year after year, we’re ranked in the top quartile for performance. In an increasingly complex and volatile world, brokers and clients are looking for risk transfer partners who are accessible, resourceful and there for the long haul. At AEGIS London, our structure and our mindset mean that our resources are an excellent match for your risks. We’re here to find solutions: Our underwriters are available and empowered to try their very hardest to find a way to say yes.