Apprentice Data Analyst

  • Withheld
  • Guiseley, Leeds
  • £8.65 per hour

Recommend this opportunity to a Friend
Vacancy provider logo for QA

  • GMFJ Reference
    128165
  • Wages
    £8.65 p/h
  • Hours
    37.50 per week
  • Date Posted
    31/03/2021
  • Start Date
    31/03/2021
  • Duration
    Not Specified

  • Location
    Guiseley
  • Status
    Now Taking Applications
  • Sector
    Data analysts
  • Opportunity Type
    Higher Level 4
  • Employer
    Withheld

Description

Employer description:

This is a national, independent marketing agency that offers clients a simple, tangible promise: we build sales overnight and brands over time and change behaviours in society.

In practice, we are a deep and diverse pool of professionals that are purposefully configured to serve our clients by their industry sector.

Overview:

We are looking for a talented Junior SQL developer/data analyst with a growing SQL skill set and database skills. The position is based in Guiseley, Leeds with a market leading and growing company within the Marketing industry.

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.

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

Personal development is a big part of the company culture.

Title - Apprentice Data Analyst 

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 

Desired skills and experience:

  • 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#

Desired personal qualities:

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

Desired qualifications:

  • 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

[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 hands on 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

Salary / Work hours:

  • £15,000 - £18,000 a year.
  • 37.5 hours per week

Future prospects:

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

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.

For more information about this vacancy please contact QA on 01793696141 (Ref ID: 128165)

Based on this opportunity you might also be interested in.

Opportunities with QA

At QA, we believe that everything starts with our learners. Transforming their careers, and in turn their lives, is what motivates us. Every day we get to empower people to fulfil their potential – creating capability, building confidence and breaking down barriers to opportunity.

 Find Out More
Cyber Essentials
© 2021 GetMyFirstJob Ltd.

Your first steps into the world of work for Apprenticeships, Degree Apprenticeships, Work Experience & Graduate Jobs