Senior Data Analyst; Report Developer

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 toward 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.

• 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.
• Carrying 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.
• Carrying out data mapping and pipelining activities in support of data integration…