The National Trust for Scotland is the charity that cares for, shares and speaks up for Scotland’s magnificent
heritage. Since 1931, we’ve pioneered public access to and shared ownership of some of the most magnificent
buildings, collections and landscapes in Scotland. We’re Scotland’s largest membership organisation and we’re
independent from government.
Among the many properties in the Trust’s care are two of the most outstanding buildings designed by Charles Rennie
Mackintosh and Margaret Macdonald; The Hill House and Mackintosh at the Willow. Together, these sites welcome
280,000 visitors annually, promoting the cultural legacy of Mackintosh and engaging visitors with the life and
works of two of Scotland's most influential artists. The Mackintosh Illuminated Project will bring together
these two properties in a joint engagement, communications and marketing and outreach programme to spotlight the
design duo, sharing, celebrating and inspiring as many as possible with their creative genius and the beauty of
their creations and create the foundation for a reappraisal of how Mackintosh and Macdonald are perceived and
appreciated locally and internationally.
Job purpose
This role, providing a Diploma in Data Analytics SCQF Level 6 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
- Support the identification and understanding of key audiences related to the Trust and the Mackintosh
Illuminated Project in particular.
- Learn to use a variety of data analysis tools (Excel, SQL, Python,
Power BI) to help answer business questions
- Work with the Insights Manager to improve end-to-end
audience research including data collection, storage, transformation, modelling and
reporting.
- Contribute to Mackintosh Illuminated project reporting as required
- Work with the
Mackintosh Illuminated project team and a range of Audience and Support, Public Engagement and Research and IT
colleagues.
- Gain credits for the diploma including:
- Supporting Digital Business
Transformation
- Applying Methods and Principles in Project Management
- Developing Meta-Skills and
Personal Professionalism
- Managing Data Assets
- Planning Data Analysis
- Locating and
Accessing Data Sources
- Transforming Data for Analysis
- Analysing Data
- Visualising and
Communicating Data
- Implementing Machine Learning Models
Required qualifications, skills, experience & knowledge
Qualifications
Essential
- Participating in the SCQF Level 6 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
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
Place in organisational structure:Audience & Support – Communications
The Purpose, Context, Key Responsibilities, and Person Specification reflect the requirements of the job at the time
of issue. The Trust reserves the right to amend these with appropriate consultation and/or request the
post-holder to undertake any activities that it believes to be reasonable within the broad scope of the job or
his/her general abilities.