Senior Data Analyst

Overview

We are looking for a senior data analyst with strong experience in insurance claims and claims related analysis. The role requires expert SQL skills, solid Power BI capability and the ability to produce clear visual analytical outputs. The analyst will work across internal product analytics and external client facing insights that support business decisions, claims strategy and offer strategy.

Kennedys IT team is responsible for delivery of a responsive, effective and timely IT support service to the firm's employees and clients. They devise and implement operational processes and procedures in order to provide reliable and available IT systems to the firm.

• Serve as a project resource on Kennedys IT projects as required, contributing technical expertise and ensuring alignment with project goals.
• Deliver internal analytics that help the business understand software usage, product performance and adoption patterns.
• Build external client facing dashboards and reports that explain claims trends, operational performance, outcomes and strategic opportunities.
• Work closely with product, engineering and client teams to translate analytical findings into clear recommendations.
• Support the development of analytical frameworks and enable actionable metrics that help clients evaluate claims strategy and operational effectiveness.
• Clean, prepare and validate large datasets drawn from claims systems, product telemetry and operational sources.
• Create Power BI dashboards that present complex information in a clear and actionable format.
• Carry out deep dive analysis to understand drivers of claim cost, duration, liability and settlement patterns.
• Develop SQL queries and data models that ensure reliable and repeatable analytical outputs.
• Present findings to senior internal stakeholders and client decision makers using strong narrative and visual storytelling.
• Contribute to ongoing improvement of data quality, definitions and governance.

• Advanced SQL skills with the ability to work with complex relational datasets.
• Strong Power BI experience including DAX, modelling and report design.
• Proven ability to create visually clear, user centric, analytical and understandable presentations.
• Background in insurance claims, financial services analytics or related decision support fields.
• Experience working with senior stakeholders and non technical audiences.
• Strong problem solving and analytical thinking.
• Ability to work independently, specify requirements for junior colleagues and manage multiple analysis streams.
• Demonstrable experience with Tableau is an advantage.
• Experience of enabling best data quality management practices, and introduction of data governance processes is an advantage.
• Curiosity and a desire to understand how claims processes and claim outcomes work.
• Ability to communicate complex ideas simply.
• High attention to detail and accuracy.
• Comfortable collaborating across technical and non technical teams.

* where a level of experience is indicated, this is a guideline only and represents the amount of time we would usually expect a candidate to accumulate the requisite level of experience. This does not preclude applications from candidates with more or less experience.