Data Analyst - Commercial Lines

An exciting opportunity has arisen for a Data Analyst to cover our comercial lines portfolio team, in particular working in the MidCorp Portfolio Steering Team to focus on data development within the Engineering, Construction and Power (ECP) account and other MidCorp lines. You will contribute to the development, production and analysis of data, using appropriate data feeds to create actionable business insight to the ECP Team whilst leading the provision of important data items across all of the MidCorp accounts to provide the greatest depth of analysis and insight in reporting. You will provide recommendations and decisions to support the profitable management of the MidCorp lines of business.

The key responsibilities of the role include:

Analysing data from multiple sources , applying data transformation techniques and data modelling concepts to structure data in a format required for BI tools.

Working within a team of technical experts to support dashboard deliveries in an agile environment

Taking proactive ownership of the analysis of data and provision of insight on current and emerging trends, both internal and external, that effect our insurance lines of business and results

Owning the reporting and data analysis of the ECP Account and use this data to create actionable insight to the account team to consider implementing into the account strategy

Provide appropriate data production and reporting, ensuring the portfolio mix is aligned with strategy and ensuring appropriate balance of growth and ultimate profitability is realised, resulting in achievement of Corporate Plan objectives

Interpret and prepare data and information for the completion of the monthly results meetings identifying key areas of interest to highlight, reviewing account team feedback and creating proposals

Support data production and quality assurance to ensure the core data sets are accurate and complete as appropriate including liaising with the regions to understand anomalies or key influences in results

Grow an understanding of multiple commercial lines of business to be able to simplify reporting and cross pollinate ideas between account teams

Create, develop and produce new reports, identifying emerging data needs as new pricing methodologies are embedded into the account

Form a key part of project teams focussed on changes which affect our data assets and the technology and solutions which are deployed 

Skills and Experience:

Strong analytical and data interpretation and manipulation skills, with the ability to communicate findings to technical and non-technical audiences and comment on the drivers of financial results

Ability to prepare reports with a high attention to detail

Strong interpersonal skills including excellent written and verbal communication skills

Excellent Microsoft Office skills, particularly Excel

Expert knowledge of SQL and enterprise database tools and ecosystems

Strong understanding of data architecture, with demonstrated experience in bridging business requirement and technical design & development

Knowledge of ETL tools such as Alteryx

Good knowledge of data modelling techniques

Knowledge of BI tools such as MicroStrategy, Qlik or similar will be beneficial.

Ability to learn new tools and technologies in the growing data space

Able to use initiative and approach challenges innovatively