Assistant Data Analyst Apprentice

Employer description: 
Enstar is a leading global insurance group that delivers innovative insurance solutions through our network of group companies. Assist Enstar management team to develop and generate standard operational and client data to proactively monitor and manage claims and perform data culling and analysis to support current and future business needs including migrations of new clients

Overview:
We are now looking for an eager candidate to join us as an apprentice. 

Training on the Data Analyst L4 pathway will include 20% off the job training to complete tasks related to this apprenticeship.

Salary: £24,000 per annum.

Duties: 

• Assist in monitoring and maintaining the central EU Claims Database and related Power BI dashboards and extract reporting, ensuring quality and integrity at all times



• Mining and extracting data from different internal sources / systems, e.g. Business Objects Environment, Claims data warehouse, Policy data marts and various other sources



• Analyse key performance indicators (KPI’s) to understand / monitor trends in the underlying claims data and apply to the life cycle of the claims by applying a variety of statistical techniques



• Assist with the data integration of newly acquired portfolios to ensure consistent reporting and data quality / integrity



• Assist with other aspects of data-related analysis and reporting as required, including supporting the US Claims Data & MI team

In addition to the above key responsibilities, you may be required to undertake other duties as required.

What we are looking for:
Essential skills / qualities:  

• Understanding of Microsoft Excel software including Excel Pivot Tables and Formula Functions



• Strong financial aptitude for dataset reconciliations to key financial statement reports



• General understanding of insurance and reinsurance practices / terminology preferred but not essential



• Ability to work collaboratively with a variety of individuals in a variety of functions (e.g. finance, claims, operations and actuarial) located in a variety of International and US offices



• Positive attitude in working through challenging data issues involving consistency, reliability, availability of data



• Problem-solving aptitude with results-orientation.



• Self-starter - willingness to work extended hours during key periods and invest time needed to learn on the job

Entry requirements
Standard entry:

• Level 3 qualification (apprenticeship/A-levels/BTEC, etc)



• OR equivalent work experience (typically two years in a relevant role)
  Plus:



• 5 GCSE's, including English and Maths at Grade 4 (C) or above 



• Experience with using Excel (in particular pivot tables and XLookup) and Microsoft products (or similar)

Perks: 

• 10% bonus annually



• Hybrid - 2 days in the office 

Your Benefits: 

• Dental Insurance (This is an optional taxable benefit available to employee, spouse, and dependents)



• Medical Insurance (This is an optional taxable benefit available to employee, spouse, and dependents through a private health network)



• Travel Insurance (As an employee you are automatically enrolled with business and leisure travel insurance with single, couple, family, or single parent family coverage options.)



• Eligible company funded annual 360 Health Assessment



• Voucher for free annual eye examination



• Option to loan a bicycle and safety equipment tax free



• Wellness Reimbursement program (up to 700 pounds annual reimbursement for wellness related expenses, e, gym memberships, massage, etc.)



• Tusker – Electric Vehicle (A fixed monthly amount is taken directly from your gross salary and, in return, you get the use of a brand new electric car.)



• Optional Critical Illness coverage



• Automatic coverage provided by income protection programme



• Access to Employee Assistance Programs (EAP) for health and wellbeing



• One paid annual volunteer day



• Pension (Enrolment is automatic on joining with a 10% employer contribution)

There is also an opportunity to complete a Digital & Tech Solutions (Data Analytics Pathway) Degree fully funded by Enstar through Apprenticeship Levy. 

Future prospects:
90% of QA Apprentices secure permanent employment after finishing their apprenticeship. 
Additionally, there may be opportunities to undertake further apprenticeship training as many of our programs offer on-going development tracks. 

Important information: 
Our apprenticeships are the perfect way to gain new skills, earn while you learn, and launch yourself into an exciting future. With over 30,000 successful apprenticeship graduates, we're a top 50 training provider, dedicated to helping you succeed. 
Apply now!