Data and Insights Assistant

  • Salary: £24,612 to £26,860

  • Location: Hybrid working remotely and in our office (Caledonian Exchange, 19A Canning Street, Edinburgh, EH3 8EG)

  • Directorate: Strategy and Operations

  • Term: Permanent

  • Hours: Full-time (Monday-Friday, 35 hours per week) some evening and weekend work may be required, look at our website for flexible working options that you might request.

  • Closing date: Friday 25 September

  • Interview date: Interviews will take place in person at our office in Edinburgh on Tuesday 6 October 

  • Important information: Visit this link to learn how to complete an application form at Young Scot. If you'd prefer to complete your application as a Word document and email it back to us, please download it using this link and email it to us.

About the role  

This role will support our Data and Insights Manager to deliver the Young Scot data and insight service. You will transform data into clear, actionable insights that support strategic and operational decision-making. You will work closely with teams across the organisation to develop high-quality dashboards, reports and visualisations using Power BI, Tableau and Excel. Combining analytical expertise, data visualisation, stakeholder engagement and data storytelling, you will ensure information is accurate, accessible and meaningful for both technical and non-technical audiences.

This is an opportunity with room to grow your skills in data visualisation and survey development, as well as the knowledge that you are improving life for young people in Scotland.

The successful candidate will have excellent Microsoft Excel skills, an interest in data visualisation and some knowledge of the public and third sectors in Scotland.  

What you’ll be doing from day-to-day:

  • Working with teams across the organisation to identify key data, insight and intelligence to be gathered.

  • Maintaining and updating datasets on a weekly, monthly, and quarterly basis. These will include social media and web reporting, as well as enquiry ticket management.

  • Collating, cleaning and processing data for reporting

  • Preparing data and producing regular reports for internal staff teams

  • Preparing data and producing regular reports for external stakeholders and partners, including local authority partners

  • Preparing and reporting on surveys for a variety of partner organisations

  • Performing data validation and quality assurance to ensure accuracy, consistency and reliability of reports.

  • Identifying opportunities to automate manual reporting processes and improve reporting efficiency.

  • Other duties to support the Data and Insights Manager

A great candidate will have a mix of these skills and experiences:  

  • Good knowledge and understanding of data and analysis

  • Excellent attention to detail

  • Able to manage own workload and work to deadlines.

  • Able to work effectively in a team and on own initiative.

  • Good knowledge of working with a diverse range of individuals and organisations.

  • Able to manage multiple tasks and projects.

  • Communication: Ability to present complex information clearly, concisely and confidently to senior and non-technical audiences.

  • Good knowledge of using Office365, particularly Excel

  • While training may be available, knowledge and experience of data visualisation software such as PowerBi would be an advantage.

application form
How to apply

Essential competencies (assessed at interview) 

Achieving Excellence – Level 2 WORKS TO GOALS AND MANAGES CHALLENGES

Understands the link between their own work and the organisation's strategic aims. Works towards goals set by others. Measures progress against targets. Seeks to understand challenges and to find ways to manage these.  Acknowledges the work and contribution of others but can also provide an opinion from their own expertise. Has the confidence to admit when they do not know.

Understanding Issues & Finding Solutions – Level 1 IMPROVES AND ACTS NOW

Addresses current opportunities and problems by improving and adapting existing approaches and ways of working. Breaks down an issue into its key elements and sets a plan of action.

Collaborating for Success – Level 2 BUILDS RAPPORT AND ADDS VALUE

Demonstrates awareness of the strategic importance of effective stakeholder relationships in, improving organisational delivery and in managing risk.  Uses a planned approach to build positive relationships.  Questions how this is adding value for the stakeholder and makes decisions with the stakeholder in mind.

Working with People – Level 1 WORKS COLLABORATIVELY

Takes a consistent approach that promotes openness, transparency and collaborates and is not afraid to seek advice from others. Knows and acknowledges strengths and weaknesses.  Allows their voice to be heard Does not bully or harass or tolerate inappropriate behaviour. 

Ability to Adapt – Level 1 ACCEPTS NEED FOR FLEXIBILITY

Demonstrates a willingness to change ideas or perceptions based on new information or changes e.g. technical developments. Is open to new ideas and listens to other people's points of view.        

Fiona Pringle