Apprentice Data Analyst - Higher (Level 4)

Golley Slater (Employer)

QA Apprenticeships (Training Provider)

Annual wage £15,000.00 to £18,000.00
37.5 hours per week TBC upon interview.
18 months (duration)
24 May 2021(start date)
Data analyst (apprenticeship standard)
Digital (route)
5 May 2021 (application closing date)
Register interest

Job Description

We are looking for a talented Apprentice SQL developer/data analyst with a growing SQL skill set and database skills. The apprentice will join a small team in supporting the company SQL environment but also play a key role in the future development of the tools used for both client and internal planning and management reporting.

Responsibilities

Main responsibilities:

  • In respect of the CRM system, maintain and develop robust and effective system and processes to improve agent productivity, client deliverables and insights
  • Manage and maintain the SQL environment in a manner to ensure maximum business systems uptime is achieved
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
  • Establish and document a continuous improvement and monitoring program in relation to the SQL and database environment
  • Establish a pro-active management approach to the SQL Environment
  • Participate in code reviews with your line manager and provide feedback and guidance to the business to identify if efficiencies can be gained from analysing our current scripts and stored procedures
  • Analyse, solve, and correct issues in real time, providing problem resolution
  • Perform scheduled maintenance and support release deployment activities after hours 

Future Prospects

There is plenty of potential for progression from both a technical and career viewpoint.

Personal development is a big part of the company culture. 

There is potential to continue in the business and progress into a Data Analyst/SQL Developer. 

Reality Check

Important Information:

QA’s apprenticeships are funded by the Education & Skills Funding Agency (ESFA), an executive agency of the Department for Education.

To be eligible for a Government funded apprenticeship you must have lived in the UK or European Economic Area (EEA) for the last 3 consecutive years.

Skills Required

[Having the following will be highly beneficial to the role]

Essential skills and experience:

  • Proficient with Microsoft SQL Server 2014 - 2016
  • Understanding and experience in creating and modifying various database objects; Tables, Views, Procedures and Functions etc.
  • Understanding and practical experience of SQL Server administration
  • Proficient in T-SQL and advanced T-SQL functions
  • Working knowledge of SQL monitoring and management programs
  • Refine & automate regular processes, track issues, and document changes
  • Experience with backups, restores and recovery models
  • The right candidate should have commercial experience within an IT SQL support environment and / or has gained industry recognized IT support qualifications
  • Experience in using the MS office Suite, in particular MS Excel
  • Experience of the full SQL BI Stack SSRS, SSIS and SSAS
  • Experience of the MS PowerBI suite
  • Experience and practical applications of implementing reporting dashboards and other reports either via SSRS or Excel
  • Experience in developing web or forms applications using C#

Qualities Required

  • Team player
  • Passionate about IT
  • Comfortable working in a friendly environment as part of team

Qualifications Required

  • A-Levels in ICT/Business/Computing
  • Or an Apprenticeship in a similar subject (this must be at least the level below the planned programme)
  • Or an International Baccalaureate at level 3 in ICT
  • Or equivalents

Training Provided

As well as on the job learning, the apprentices will also study towards their Level 4 (Higher) Data Analytics Apprenticeship.

Covering modules such as Data Analyst Tools and Data Analyst Concepts.

Functional Skills in maths and English if required.

Register interest

Related