Data Analyst Apprentice

QA Ltd
United Kingdom
£16999 - £18000 per year
07 Oct 2017
08 Nov 2017
Contract Type
Full Time
Job Description Completing an IT Level 4 apprenticeship, you will be part of a busy team. This role will assist the Data and Architecture team in two areas - Supporting the Single Customer View (SCV) Team in the audit of processes and controls that banks and building societies have in place to deliver a Single Customer View to FSCS and to perform an assessment of the data they supply against FSCS' quality and integrity standards and in line with PRA (Prudential Regulation Authority) rules - Support the Data Team in providing management information and data analysis as required helping the business manage and improve services. Working with experienced data analysts to assist with the take-on, cleansing, analysis and preparation of current and future data sets within predefined guidelines and standards for the purposes of claims processing, tracking and analysis Duties/ Responsibilities Role Responsibilities/What you need to do : SCV - Support the analysis of SCV (Single Customer View) data provided by deposit taking firms i.e. banks, building societies and credit unions ("deposit takers") - Assist with the FSCS payout process that triggers when deposit takers fail - Perform other duties that falls within the scope of the role, as allocated by the line manager Data Analysis - Support extract, transfer and load of data - Analyse data to correctly determine its proportions and other key metrics - Reconcile related data received from 3rd parties against company data using predefined methods Data Reporting and development - Support the preparation regular management information and ad-hoc reports for the business teams using defined templates and standards to agreed timescales - Ensure reports produced are accurate and presented in a way that enables the recipient to identify key points and use the information in their own role. Any issues identified during report preparation are drawn to the attention of the appropriate managers Data Take On - Assist in bringing data from default organisation(s) into FSCS systems Skills/requirements Knowledge and Expertise/What you need to know: - Advanced Microsoft Office skills (especially Word, Excel and PowerPoint). [REQUIRED] - Strong analytical skills and the ability to work with large amounts of data. [REQUIRED] - Technical experience using SQL to perform operations on databases. [OPTIONAL] - Excellent interpersonal and communication skills with business and team members - Pro-active approach to gathering requirements and information - Great attention to detail and ability to review deliverables and follow the FSCS standards and procedures for quality assurance process Desired Qualifications Minimum of 5 GCSE Grades (C and above) including Maths and English, and A Level or equivalent qualifications, including IT related subject Other information Working week - Monday to Friday (35 hours per week) Salary - £17,000-£18,000 per year Important Information "QA's apprenticeship programmes may be funded in part by the European Union through the European Social Fund, which supports the development of employment opportunities and a skilled workforce."
This job was originally posted as