Programme overview
Transform complex organisational data into strategic intelligence using SQL, Python or R, statistical modelling and executive data visualisation.
How it is delivered
Every apprentice is paired with a dedicated, industry-experienced tutor for 1:1 coaching scheduled around your workplace, with Off-The-Job training built into real projects and Functional Skills support where needed.
What you will learn
Every apprenticeship follows a national occupational standard. These are the knowledge, skills and behaviours the apprentice will build and be assessed on.
The role in one sentence
Collect, organise and study data to provide business insight.
Knowledge (15)
What the apprentice will know
-
K1:
current relevant legislation and its application to the safe use of data
-
K2:
organisational data and information security standards, policies and procedures relevant to data management activities
-
K3:
principles of the data life cycle and the steps involved in carrying out routine data analysis tasks
-
K4:
principles of data, including open and public data, administrative data, and research data
-
K5:
the differences between structured and unstructured data
-
K6:
the fundamentals of data structures, database system design, implementation and maintenance
-
K7:
principles of user experience and domain context for data analytics
-
K8:
quality risks inherent in data and how to mitigate or resolve these
-
K9:
principal approaches to defining customer requirements for data analysis
-
K10:
approaches to combining data from different sources
-
K11:
approaches to organisational tools and methods for data analysis
-
K12:
organisational data architecture
-
K13:
principles of statistics for analysing datasets
-
K14:
the principles of descriptive, predictive and prescriptive analytics
-
K15:
the ethical aspects associated with the use and collation of data
Skills (15)
What the apprentice will be able to do
-
S1:
Use data systems securely to meet requirements and in line with organisational procedures and legislation including principles of Privacy by Design
-
S2:
implement the stages of the data analysis lifecycle
-
S3:
apply principles of data classification within data analysis activity
-
S4:
analyse data sets taking account of different data structures and database designs
-
S5:
assess the impact on user experience and domain context on data analysis activity
-
S6:
identify and escalate quality risks in data analysis with suggested mitigation or resolutions as appropriate
-
S7:
undertake customer requirements analysis and implement findings in data analytics planning and outputs
-
S8:
identify data sources and the risks and challenges to combination within data analysis activity
-
S9:
apply organizational architecture requirements to data analysis activities
-
S10:
apply statistical methodologies to data analysis tasks
-
S11:
apply predictive analytics in the collation and use of data
-
S12:
collaborate and communicate with a range of internal and external stakeholders using appropriate styles and behaviours to suit the audience
-
S13:
use a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data
-
S14:
collate and interpret qualitative and quantitative data and convert into infographics, reports, tables, dashboards and graphs
-
S15:
select and apply the most appropriate data tools to achieve the optimum outcome
Behaviours (7)
How the apprentice will work
-
B1:
maintain a productive, professional and secure working environment
-
B2:
show initiative, being resourceful when faced with a problem and taking responsibility for solving problems within their own remit
-
B3:
work independently and collaboratively
-
B4:
logical and analytical
-
B5:
identify issues quickly, investigating and solving complex problems and applying appropriate solutions. Ensures the true root cause of any problem is found and a solution is identified which prevents recurrence.
-
B6:
resilient – viewing obstacles as challenges and learning from failure.
-
B7:
adaptable to changing contexts within the scope of a project, direction of the organisation or Data Analyst role.
Duties (12)
The tasks of the job, and the KSBs each one uses
-
Duty 1:
Identify data sources to meet the organisation's requirement, using evidence-based decision making to establish a rationale for inclusion and exclusion of various data sets and models Uses K1, K2, K3, K4, K5, K6, K8, K9, K10, K12, K15, S1, S2, S7, S8, S9, S15, B2, B3, B4, B5, B7
-
Duty 2:
Liaise with the client and colleagues from other areas of the organisation to establish reporting needs and deliver insightful and accurate information Uses K1, K2, K3, K4, K5, K6, K9, K10, K11, K12, K15, S1, S2, S4, S5, S7, S12, B1, B3, B4, B5, B6, B7
-
Duty 3:
Collect, compile and, if needed, cleanse data, such as sales figures, Digital Twins etc. solving any problems that arise, to or from a range of internal and external systems Uses K1, K2, K3, K4, K5, K6, K8, K10, K11, K12, K13, K15, S1, S2, S3, S4, S6, S7, S8, S9, S10, S13, B1, B2, B3, B4, B5, B6, B7
-
Duty 4:
Produce performance dashboards and reports in the Visualisation and Model Building Phase Uses K1, K2, K3, K4, K5, K6, K7, K8, K9, K10, K11, K12, K13, K15, S1, S2, S3, S4, S5, S7, S8, S9, S10, S11, S12, S13, S14, S15, B2, B3, B4
-
Duty 5:
Support the organisation by maintaining and developing reports for analysis to aid with decisions, and adhering to organisational policy/legislation Uses K1, K2, K3, K7, K8, K10, K11, K12, S1, S2, S3, S5, S8, S9, S14, B1, B2, B3
-
Duty 6:
Produce a range of standard and non standard statistical and data analysis reports in the Model Building phase Uses K2, K3, K4, K5, K6, K7, K8, K9, K10, K11, K12, K13, K14, S1, S2, S3, S4, S5, S8, S9, S10, S11, S13, S14, B2, B3, B6, B7
-
Duty 7:
Identify, analyse, and interpret trends or patterns in data sets Uses K1, K2, K3, K4, K5, K8, K10, K11, K12, K13, K14, K15, S1, S2, S3, S4, S5, S6, S10, S11, S13, S14, B2, B3, B4, B5, B7
-
Duty 8:
Draw conclusions and recommend an appropriate response, offer guidance or interpretation to aid understanding of the data Uses K1, K2, K7, K8, K11, K14, S1, S2, S3, S4, S5, S7, S10, S11, S12, S13, S14, B2, B3, B4, B5, B7
-
Duty 9:
Summarise and present the results of data analysis to a range of stakeholders, making recommendations Uses K2, K3, K4, K5, K7, K9, K10, K12, K13, K15, S1, S2, S4, S5, S7, S9, S12, S14, S15, B1, B3, B4, B7
-
Duty 10:
Provide regular reports and analysis to different management or leadership teams, ensuring data is used and represented ethically in line with relevant legislation (e.g. GDPR which incorporates Privacy by Design). Uses K1, K2, K3, K4, K5, K6, K7, K9, K10, K11, K12, K15, S1, S2, S4, S5, S7, S10, S12, S14, S15, B3, B4, B5
-
Duty 11:
Ensure data is appropriately stored and archived, in line with relevant legislation e.g. GDPR Uses K1, K2, K3, K6, K8, K11, K12, S1, S2, S3, S9, B1, B3, B4
-
Duty 12:
Practice continuous self learning to keep up to date with technological developments to enhance relevant skills and take responsibility for own professional development Uses K7, K8, K10, K11, K13, K14, K15, S1, S3, S4, S6, S7, S12, B1, B2, B3, B4, B5, B6, B7
Source: Skills England, Data analyst (ST0118 v1.1). Contains public sector information licensed under the Open Government Licence v3.0.
Read the end-point assessment plan (PDF)
