MIS Apprentice Developer (Southport Education Group)

Summary

The post holder will assist in the maintenance/housekeeping of the College Management Information Systems and designing/producing reports from them. There will also be an element of testing, validation and problem-solving data issues where appropriate.

Annual wage: £12,348 a year
Minimum wage rates (opens in new tab)
Training course: Data technician (level 3)
Hours: Monday to Friday. Shifts to be confirmed.
37 hours a week
Possible start date: Thursday 16 January
Duration: 1 year 6 months
Positions available: 1

Work

As an apprentice, you’ll work at a company and get hands-on experience. You’ll gain new skills and work alongside experienced staff.

What you’ll do at work

To assist and support in the preparation of SQL reports for management, staff and external agencies utilising relevant reporting software and output in an appropriate format
To be 1st line support for the MIS developer team for users of the Student Records database and others relevant systems
To assist in the administration and support of Reports and Dashboards used by all stakeholders across the organisation
To assist with the daily ad-hoc data requests from college database systems
To assist with relevant validation checks of the Student Records database
To assist with the development and maintenance of the Student Records database and other systems as appropriate
To implement basic system administration/housekeeping of the Management Information Systems
To work with college staff to enable them to clarify and define their information needs, ensuring that specifications for development provide the required solution
Process amendments to update the student database
Any other duties commensurate with the post

Where you’ll work

Mornington Road

Southport

Merseyside

PR9 0TT

Training

An apprenticeship includes regular training with a college or other training organisation. At least 20% of your working hours will be spent training or studying.

College or training organisation

FIREBRAND TRAINING LIMITED

Your training course

Data technician (level 3)

Equal to A level

Course contents

Source and migrate data from already identified different sources.
Collect, format and save datasets.
Summarise and explain gathered data.
Blend data sets from multiple sources and present in format appropriate to the task.
Manipulate and link different data sets as required.
Use tools and techniques to identify trends and patterns in data.
Apply basic statistical methods and algorithms to identify trends and patterns in data.
Apply cross checking techniques for identifying faults and data results for data project requirements.
Audit data results.
Demonstrate the different ways of communicating meaning from data in line with audience requirements.
Produce clear and consistent technical documentation using standard organisational templates.
Store, manage and distribute in compliance with data security standards and legislation.
Explain data and results to different audiences in a way that aids understanding.
Review own development needs.
Keep up to date with developments in technologies, trends and innovation using a range of sources.
Clean data i.e. remove duplicates, typos, duplicate entries, out of date data, parse data (e.g. format telephone numbers according to a national standard) and test and assess confidence in the data and its integrity.
Operate as part of a multi-functional team.
Prioritise within the context of a project.
Source and migrate data from already identified different sources.
Collect, format and save datasets.
Summarise and explain gathered data.
Blend data sets from multiple sources and present in format appropriate to the task.
Manipulate and link different data sets as required.
Use tools and techniques to identify trends and patterns in data.
Apply basic statistical methods and algorithms to identify trends and patterns in data.
Apply cross checking techniques for identifying faults and data results for data project requirements.
Audit data results.
Demonstrate the different ways of communicating meaning from data in line with audience requirements.
Produce clear and consistent technical documentation using standard organisational templates.
Store, manage and distribute in compliance with data security standards and legislation.
Explain data and results to different audiences in a way that aids understanding.
Review own development needs.
Keep up to date with developments in technologies, trends and innovation using a range of sources.
Clean data i.e. remove duplicates, typos, duplicate entries, out of date data, parse data (e.g. format telephone numbers according to a national standard) and test and assess confidence in the data and its integrity.
Operate as part of a multi-functional team.
Prioritise within the context of a project.

Your training plan

This training plan has not been finalised. Check with this employer if you’ll need to travel to a college or training location for this apprenticeship.

More training information

Firebrand’s sector leading Level 3 Data Technician (L3DT) Apprenticeship Programme trains apprentices to be able source, format and present data securely in a relevant way for analysis using basic methods. Our programme will enable apprentices to:

Communicate outcomes appropriate to varying audiences
Analyse structured and unstructured data to support business outcomes
Blend data from multiple sources as directed
Apply legal and ethical principles when manipulating data

Firebrands course is delivered either Online (online live instructor-led), or face-to-face in the classroom environment (your choice). Our Subject Matter Experts (SMEs), Learning Mentors (LMs) and world-leading trainers prepare apprentices to work across multiple sectors.

Completion of this apprenticeship will provide learners with the following world class vendor certifications in addition to the Data Technician apprenticeship:

Data Analysis and Visualisation in Excel

Key areas covered are:

Role of the Data Technician
Introduction to Excel
Fundamentals of visualisation
Open-source resources
Types formats and structures of data
Identification of data quality issues
Database and data warehouse fundamentals
Dashboarding
Analysis of data in Excel including power query and power pivot

Requirements

Essential qualifications

GCSE in:

English and Maths (grade Level 2 Qualification)

Let the company know about other relevant qualifications and industry experience you have. They can adjust the apprenticeship to reflect what you already know.

Skills

Communication skills
Attention to detail
Problem solving skills
Team working
Initiative
Interpersonal skills
Ability to work under pressure
Able to prioritise workload
Willingness to work Flexibly
Knowledge in SQL Server
Knowledge in System Design
Passion for data
Positive attitude

About this company

Southport Education Group is a group of colleges providing further education to Southport and surrounding areas. There are 2 campuses which serve the area, one primarily focused around A level provision and the other for technical qualifications but some cross over does happen.

After this apprenticeship

Employment will be on a fixed term basis for the duration of the apprenticeship. There may be an opportunity for permanent employment following the end of the fixed term period and successful completion of the apprenticeship.

Ask a question

The contact for this apprenticeship is:

FIREBRAND TRAINING LIMITED

Sean Hove

Sean.Hove@estio.co.uk

0113 3500 333

The reference code for this apprenticeship is VAC1000287923.

Apply now

Closes on Wednesday 1 January

When you apply, you’ll be asked to sign in with a GOV.UK One Login. You can create one at the same time as applying for this apprenticeship.

Cookies on Find an apprenticeship

Contents