Data Analyst

Key Responsibilities

• Produce accurate daily, periodic and annual reports for internal and external stakeholders.
• Build and maintain clear performance dashboards, reports and presentations.
• Respond to ad hoc reporting and analysis requests within agreed timescales.
• Analyse performance data to identify trends, issues, risks and opportunities for improvement.
• Provide clear commentary that explains the findings and business impact of the analysis.
• Complete routine data-quality checks and support the maintenance of relevant databases and reporting systems.
• Work with operational teams to understand reporting requirements and improve the quality of available management information.
• Support workforce and capacity reporting, including service levels, productivity, scheduling and resource availability.
• Help maintain relevant user accounts, access permissions, distribution lists and task lists in line with approved processes.
• Document new reporting processes and procedures and keep existing documentation up to date.
• Contribute to the continuous improvement and automation of reports and business processes.
• Handle company and customer information in accordance with data protection and information security requirements.

Skills, Knowledge and Expertise

• Higher-grade qualifications, or equivalent, in English and Mathematics at grade C or above.
• A clear, logical and analytical approach to problem-solving.
• Good attention to detail and a commitment to producing accurate work.
• Ability to organise and prioritise tasks within agreed deadlines.
• Ability to work independently while knowing when to seek guidance or support.
• Good written and verbal communication skills.
• Confidence working with colleagues and stakeholders at different levels of the organisation.
• Good working knowledge of Microsoft Excel and other Microsoft 365 applications.
• Ability and willingness to learn new systems and analytical tools.
• Ability to manage changing priorities and periods of increased workload.

• A qualification in data analytics, business intelligence, statistics or a related subject.
• Experience in a data analysis, reporting, management information or similar role.
• A degree or equivalent qualification in a STEM, business or analytical subject.
• Experience using one or more of the following: Excel, Power BI, SQL, Python, Snowflake, Power Automate, Power Apps or GitHub.
• Experience creating dashboards or presenting analytical findings to non-technical audiences.
• An understanding of data quality, data protection and information security.

Welcome to your Solvd. Journey

• On-the-job training and continuous personal development opportunities.
• Regular performance feedback and 1:1s to help you succeed.
• Support for family events, personal support, and a focus on having fun in the workplace.
• Opportunities for career progression.
• Competitive benefits.

• Discretionary ScotRail Season Ticket (home to work)
• Discretionary bonus scheme
• Hybrid working (for most roles, after probation)
• Living Wage and Living Hours Accredited
• 34 days holiday (including public holidays) with option to buy additional
• Generous salary exchange Pension Scheme and Life Assurance Scheme
• Optional Health Cashplan Scheme
• Employee Assistance Programme and Wellbeing Support including mental, physical, financial and social
• Flexible dress code where you can Dress for Your Day!
• Social events including Summer Event and Christmas Party