Data Engineer (remote)

Acrisure; Remote; GBP 30,000 - 50,000; Full time

Job summary

A financial services company is seeking a Data Analyst to oversee and maintain the company’s data warehouse. The role involves supplying data for stakeholders, providing reporting on MI and KPIs, and ensuring data is cleansed and validated. The ideal candidate should have proficiency in Excel, SQL, and an understanding of data import/export techniques. This position offers opportunities for continuous improvement and development in data analytics processes.

Responsibilities

• Maintain and update the company data warehouse.
• Validate, cleanse, and process datasets.
• Support GWP, income, and profit targets.
• Build and maintain reporting dashboards.
• Identify areas for continuous improvement.

Skills

Proficiency in Excel

Experience in SQL

Data import/export techniques

Logical thinking

Attention to detail

Adaptability

Understanding of mathematical principles

Tools

MS Excel

MS SQL Server

Qlik Cloud Analytics

.NET with C#

Job description

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.