Oversee the company data warehouse: update data in line with relevant timescales, maintaining and refining procedures to process and validate the data, and ensure fit-for-purpose datasets are available to support MI and general reporting.
Supply data in a suitable format for relevant internal and external stakeholders.
Provide and evolve general MI and KPI reporting for relevant internal and external stakeholders.
Support pricing decisions through the availability of suitable performance reporting.
Provide insight into areas of the business that are performing remarkably throughout the full sales and underwriting cycle.
Main technologies used:
- MS Excel
- MS SQL Server
- Qlik Cloud Analytics
- .NET with C# (local and web applications)
Role Purpose
To maintain and update the company data warehouse, supply data in a suitable format for relevant internal and external stakeholders, and provide and evolve general MI and KPI reporting for relevant internal and external stakeholders.
Main Role Tasks
- Validate, cleanse and process monthly written policy transaction datasets into the policy management system in line with agreed timescales.
- Validate, cleanse and unify internal and external data sources, helping to maintain the company’s data warehouse.
- Support the business in delivering its GWP, income, profit and underwriting performance targets through the delivery of MI and data analysis.
- Build and maintain standardised daily/weekly/monthly reporting to all levels of the business.
- Build and maintain standardised management information (MI) and key performance indicator (KPI) dashboards.
- Identify areas of continuous improvement, in terms of data processing, MI production and analytics, and work with the Head of Analytics and Insight to explore how these might be developed and embedded into the business.
Personal Characteristics and Experience
- Proficiency in Excel
- Experience in SQL, and data import/export techniques is desirable
- Logical and detail-oriented.
- Adaptable with a desire to learn.
- Good understanding of mathematical principles.
