Senior Data Analyst (4073)

Job summary

Join Social Security Scotland as a Senior Data Analyst (Report Developer) and help shape how data is used to support the delivery of vital public services across Scotland. This role is focused on the design, development and support of high-quality Power BI reporting solutions, enabling colleagues and leaders to make informed operational and strategic decisions based on trusted data.

Working within the Data Services Team, you will lead the end-to-end development of Power BI dashboards and reports, from understanding requirements and business needs through to developing, publishing and supporting solutions within the Power BI Service. You will work with complex datasets and enterprise data platforms to create accurate, insightful and user-focused reporting products that meet organisational needs.

A key aspect of the role is supporting the organisation's move towards a managed self-service reporting model. You will help establish and promote reporting standards, governance and best practice while ensuring reporting products are robust, accessible and fit for purpose. You will also provide guidance, documentation and support to users, helping colleagues build confidence in the effective use of data and reporting tools.

This role is ideally suited to an experienced Power BI Developer, BI Developer or Reporting Analyst with strong technical expertise in Power BI (including Power BI service) data analysis and stakeholder engagement. You'll be comfortable working with complex data, translating business requirements into meaningful visualisations, and influencing how reporting services are developed and delivered across a large organisation.

Above all, we're looking for someone who combines excellent Power BI development skills with a passion for using data to drive improvement, support decision-making and deliver better outcomes for the people of Scotland.

A Senior Data Analyst leads data analysis in a team or across an area. They ensure data is appropriately prepared, managed and used, and that data analysis outcomes
align with the organisation's goals.

At this role level, you will:

• Guide others in appropriate practices for preparing, managing and using data.
• Lead the application and improvement of processes and ways of working with data, reporting and data visualisation.
• Lead communication of data, data products and data projects with stakeholders, adapting to their needs and requirements, including translating business requirements into effective reporting and visualisation solutions using Power BI.

Job description

Responsibilities

• Proficient in applying a variety of data visualisation approaches, including the design, development and maintenance of Power BI reports and dashboards.
  
• Works with stakeholders and colleagues to understand reporting requirements and translate these into effective, user-focused visualisations and reporting products.
  
• Develops data visualisation standards.
  
• Carries out complex data analysis and synthesis with a variety of methods and tools.
  
• Produces written and verbal data analysis (e.g. reports, dashboards, presentations or briefings) for technical and non-technical audiences.
  
• Runs meetings and workshops, where data analysis, reporting and data visualisation matters are discussed with technical and non-technical colleagues.
  
• Assures and peer reviews data analysis and synthesis output of other colleagues.
  
• Resolves data issues and manages others in data-driven solution implementation, including investigating and resolving reporting issues and validating reporting outputs.
  
• Defines and employs data management and governance mechanisms and tooling, including reporting and business intelligence platforms.
  
• Carries out data mapping and pipelining activities in support of data integration exercises.
  
• Contributes to established corporate data patterns and standards.
  
• Ensures data meet the necessary metadata standards in support of semantic interoperability across digital systems.
  
• Deals with diverse datasets.
  
• Applies methodology for data quality management.
  
• Manages data analysis projects and exchanges relevant views and knowledge with others.

Person specification

Success Profiles
We use an assessment framework called ‘Success Profiles’ which lists the elements we test and provides detailed descriptions of each. Find out more about the framework here.

For this post, the following Success Profile elements will be assessed:

Experience:

1. Solid experience in manipulating, linking and preparing data in order to carry out data analysis, reporting and visualisation activities including data modelling and use of Power BI.
2. Experience of leading workshops with technical and non-technical staff, identifying information and reporting requirements and/or presenting technical output in relation to data analysis and data visualisation activities.
   

Behaviours:

• Making Effective Decisions (Level 3)
• Leadership (Level 3)

You can find out more about Success Profiles Behaviours here.

Technical / Professional skills:

This role is aligned to Senior Data Analyst within the Government Digital and Data Profession.

Please review the following to understand the skill expectations: Data Analyst - Government Digital and Data Profession Capability Framework

These skills will be tested during the Technical Assessment if you are successful at sift stage. They will not be assessed at application stage.

Benefits

Annual Leave - You will receive 25 days annual leave on joining us. This will increase to 30 days after two full years of service. You will also have 11.5 public and privilege days of leave every year. We also offer Flexi-time. Any extra hours you've worked can be taken as leave when suitable.

A Civil Service Pension - This job comes with a Civil Service pension. New joiners to the Civil Service will join a career average pension scheme as standard. Read more here - www.civilservicepensionscheme.org.uk.

Healthy work life balance - We can offer the possibility of full-time, part-time, term-time, and job shares. We also encourage flexible working.

Discounts - You can enjoy a vast range of retail, travel and lifestyle discounts through our benefit scheme.

Personal support for you - Our Employee Assistance Programme gives you confidential, independent information and guidance 24/7.

Volunteering special leave - Up to six days paid special leave a year for volunteering. We support our staff to help causes important to them.

Great locations - Our bright and modern offices in the heart of Dundee and Glasgow have been designed with staff in mind. Both locations are ideal for public transport.

Things you need to know

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

Expected Timeline (subject to change)
Sift - week commencing 26th October
Interview – week commencing 16th November
Location - In Person in either Dundee or Glasgow

To apply please submit an application form by clicking on the ‘Apply at Advertisers Site’ button.

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a basic (or equivalent) criminal record check.People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

Working for the Civil Service

The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants.

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

Diversity and Inclusion

The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see theCivil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).

Apply and further information

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window).Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants

Job contact :

• Name : Resourcing Team
• Email : recruitment@socialsecurity.gov.scot
• Telephone : 08001577194

Recruitment team

• Email : Recruitment@socialsecurity.gov.scot

Further information

https://www.socialsecurity.gov.scot/working-with-us/help-with-your-application