Data Analytics Apprentice
Organisation: The National Trust for Scotland
Salary: £27,976
Location: 50 South Gyle Crescent, Edinburgh EH12 9LD
Job purpose
This role, providing a Diploma in Data Analytics SCQF Level 8 will work with the Insight Manager to support the collection, management, analysis and reporting of audience and project data primarily related to the Mackintosh Illuminated Project. The work will help guide decision makers and support robust reporting across the project workstreams.
Through hands-on experience and structured learning, they will gain skills in data collection, management, analysis and reporting, giving them strong foundations for a career uncovering insight from data.
The role is part of the Audiences & Support Directorate and there is flexibility in the role location.
Key responsibilities and accountabilities
1. Support the identification and understanding of key audiences related to the Trust and the Mackintosh Illuminated Project in particular.
2. Learn to use a variety of data analysis tools (Excel, SQL, Python, Power BI) to help answer business questions
3. Work with the Insights Manager to improve end-to-end audience research including data collection, storage, transformation, modelling and reporting.
4. Contribute to Mackintosh Illuminated project reporting as required
5. Work with the Mackintosh Illuminated project team and a range of Audience and Support, Public Engagement and Research and IT colleagues.
6. Gain credits for the diploma including:
a. Supporting Digital Business Transformation
b. Applying Methods and Principles in Project Management
c. Developing Meta-Skills and Personal Professionalism
d. Managing Data Assets
e. Planning Data Analysis
f. Locating and Accessing Data Sources
g. Transforming Data for Analysis
h. Analysing Data
i. Visualising and Communicating Data
j. Implementing Machine Learning Models
Required qualifications, skills, experience & knowledge
Qualifications
Essential
• Participating in the SCQF Level 8 Diploma in Data Analytics as part of this role.
• National 5 (or equivalent) in Mathematics or IT related subject.
• National 5 (or equivalent) in English.
Desirable
• Interest in heritage and conservation.
The current duties of this job do not require a criminal records (Disclosure Scotland) check to be carried out.
Experience
Essential
• Excellent analytical and numeracy skills and attention to detail
• IT literacy and familiarity with data analysis tools (principally Excel) and the ability to pick up other tools as appropriate
• Demonstrable experience of our core values (brave, caring, curious, inclusive, vibrant).
• Strong teamworking skills
• Good communication skills with the ability to effectively communicate complex ideas
• Ability to manage time efficiently and effectively in an environment of changing priorities.
Desirable
• Passion for data and uncovering meaningful insights
Dimensions and scope of job
People Management
• No line management responsibility
• Close working relationship with A&S, property teams and other Directorates
Financial Management
None
Tools / equipment / systems
Training will be provided for all the below:
• Microsoft Office systems including OneDrive, Teams, Excel
• Core NTS Survey platforms (MS Forms, Snap Survey)
• SQL and Microsoft Azure
• Data analysis and visualization tools (Power BI, Python)
Key performance indicators and targets
• Contributes to key objectives of the Insights function such as survey data collected, projects completed and unique users to the Audience and Insights SharePoint Hub.
• Contributes to A&S KPI through supporting membership and marketing work with actionable insight.
• Completion of all coursework and assignments for SCQF Level 6 Diploma in Digital Marketing
Application Deadline: Sunday 07/06/2026
