Data Analyst - Specialty

Role Overview

Role Overview

The role is dedicated to the Aviation team. Its primary focus is to support our Senior Data Analyst, Aviation and ultimately the wider Aviation team with data analysis, reporting and analytics; all of the role's deliverables relate to the aviation portfolio.

For the first year, you will spend dedicated time each week embedded with the central Data & Analytics team. That team provides the formal training, tooling and access to the "back end" - the data lake, SQL and detailed data-analytical environment - that sits behind the Aviation team's reporting, and the role applies that capability directly to Aviation work.

The Aviation team's data function is currently led by deep domain knowledge - over 20 years of aviation insurance experience across claims, finance, broking and account management - together with a clear understanding of the data and the outputs the team needs. This role complements that domain expertise with formal analytical and technical depth (data-lake access, SQL and structured data analysis), developed and supported through the Data & Analytics team.

In summary:

• Focus: dedicated to Aviation team data, reporting and analytics.
• Working pattern: approximately 25% of each week embedded with the Data & Analytics team.

• Development model: technical training, tooling and back-end (data lake / SQL) access provided by the Data & Analytics team and applied directly to Aviation work.

What You'll Do

• Work with brokers and business stakeholders to understand real-world problems and translate them into data and AI questions.

• Explore and prototype data ideas, helping to shape user stories and analytical approaches.

• Clean, analyse and validate data from multiple sources - including premium and placement data, claims experience and underwriter / portfolio performance - to ensure accuracy and reliability.

• Spot patterns, trends and anomalies, and help explain what they mean in practice.

• Use modern data and analytics tools to turn raw data into clear, actionable outputs - reports, dashboards and analytics that support broker lineslips / facilities and senior management, both regular and ad-hoc.

• Support the use of AI-enabled tools to automate repetitive data entry, cleansing and reconciliation, and to accelerate the production of reports and analytics.

• Collaborate with data, technology and analytics teams across the wider group.

• Apply appropriate human review, document your work and follow best-practice data and AI standards. Break problems into steps an agent can execute, and use good judgement about when to lean on AI and when to do the work yourself.

What You'll Grow Into

As you build aviation domain knowledge and technical depth, the role broadens to include:

• Acting as a data and analytics point of contact for the team's lineslip portfolio - building and maintaining reporting suites covering bordereaux, income, claims and utilisation.

• Producing consolidated, portfolio-level analytics to support renewal strategy and market presentations.

• Identifying data-quality issues in lineslip records and working with brokers to resolve them at source.

• Acting as a business-analyst liaison between the broking team and IT / AI development resources - defining requirements, mapping workflows and setting data-capture standards.

• Participating in testing (UAT) and supporting brokers using AI-enabled tools: troubleshooting, onboarding users and maintaining guides and training materials.

What We're Looking For

Essential

• A degree (or equivalent) in a numerate or analytical subject - e.g. maths, statistics, data science, economics, engineering or sciences.

• Strong attention to detail and logical thinking.

• A genuine interest in how data can influence business decisions.

• Confidence explaining ideas to both technical and non-technical audiences.

• An inquisitive, problem-solving mindset - comfortable with modern AI tooling and keen to keep pace with a fast-moving landscape.

Technical skills (you don't need all of these on day one)

• Experience using Excel for analysis.

• Exposure to Python, SQL and/or R through study, projects or internships.

• Familiarity with data-visualisation tools such as Power BI (or similar).

• Interest in learning modern data platforms (e.g. Databricks).

• Experience using GenAI / LLMs to support operational workflows and analytics.

• Any exposure to automation tools (e.g. Power Automate) and to producing presentation materials is an advantage.

Nice to have (but not required)

• University or personal projects involving real datasets.

• A basic understanding of data modelling or data pipelines.

• An interest in - or willingness to learn - insurance and aviation. Domain knowledge can be developed on the job.

Key Stakeholders

• The wider Aviation team.

• Aviation brokers and client executives.

• Markets / insurers (indirectly, through placement data and reporting).

• Central Data & Analytics team; IT / AI development teams.

• Operations teams.

How Success Will Be Measured

• Accuracy and timeliness of reporting.

• Quality and usefulness of data insights.

• Data quality and completeness across the aviation portfolio.

• Growing confidence and independence with the data platform and analytical tooling.

• Adoption and effectiveness of AI-enabled tools in day-to-day work.

• Progress against agreed learning and development goals.

Tools & Systems (Typical)

• Microsoft Excel.

• Power BI.

• SQL / data lake (e.g. Databricks).

• Power Automate / Power Platform.

• SharePoint / Dataverse

• GenAI tools (e.g. Copilot / Claude) for reporting and process support.

What You'll Get

• A structured early-career role with on-the-job learning and mentoring.

• Exposure to client and operations work across a specialist line of business.

• Training and professional qualifications (e.g. Chartered Insurance Institute).

• Competitive salary, generous pension and private medical cover.