Senior Power BI and Collaboration Engineer

Details

Reference number

468029

Salary

£46,750 - £49,810

The Civil Service Pay Remit and Acas Pay Policy will apply.

A Civil Service Pension with an employer contribution of 28.97%

GBP

Job grade

Senior Executive Officer

Grade 8

Contract type

Fixed term

Length of employment

until 31 March 2028

Business area

ACAS - Digital Data and Technology

Type of role

Architecture and Data

Digital

Governance

Knowledge and Information Management

Strategy

Working pattern

Flexible working, Full-time, Part-time

Number of jobs available

1

Contents

Location

About the job

Benefits

Things you need to know

Apply and further information

Location

Leeds, Manchester, or Newcastle with an element of working from home. Please be aware that this role can only be worked in Great Britain and not overseas. You will be asked to express a location preference during the application process. Informal hybrid arrangements are available and the balance between home and workplace working is to be agreed with the line manager to achieve the right balance between collaboration, in-person engagement and flexibility.

Internal Acas employees are welcome to apply from any Acas location and will remain in their current contractual location if successful. These employees should select 'Any' as a location preference and add their current work location plus their Acas email address in the location preference section.

About the job

Job summary

The purpose of this role is to:

Manage the creation of Power BI data models and data connections

Manage the technical development of dashboards and data visualisations – currently via MS Power BI

Work with customers to advise on data related practices, offer guidance and support developmental projects related to Power BI

Support the team with wider team with innovative developments in data science and analytics

Support the Head of Collaboration Engineering in delivering key elements of the Data Strategy

Job description

The post holder’s main accountabilities will include the following:

Power BI Development and Delivery – Lead the design, build and maintenance of Power BI dashboards, reports, and semantic models, ensuring high-quality, scalable and reusable solutions aligned to best practice.

Data Modelling and Performance Optimisation – Develop and optimise data models, DAX measures, and data transformations, ensuring accuracy, performance, reliability, and robust data refresh processes.

Stakeholder Engagement and Requirements Management – Engage with business stakeholders to understand performance needs, define KPIs, and translate requirements into effective reporting and insight solutions.

Governance, Security and Quality Assurance – Ensure strong data governance through quality assurance processes, documentation, role-based access controls (RLS), and secure handling of sensitive data.

Operational Support and Continuous Improvement – Support live reporting environments, troubleshoot issues, monitor performance and user adoption, and drive continuous improvement in reporting products and processes.

Collaboration, Leadership and Capability Building – Work within agile teams and with cross-functional partners to integrate data sources and improve monitoring; provide guidance on best practice, mentor colleagues, and line manage a small team.

Strategic Contribution and Risk Management – Support delivery of the organisation’s data strategy, contribute to data initiatives, and identify, manage, and escalate risks, technical debt, and procurement considerations.

Who we are

Acas exists to make working life better for everyone in Britain. We are the experts in workplace matters, we’re impartial, so we’re not on anyone’s side. That means we’re working for everyone to help prevent, manage and resolve workplace issues.

Acas helps employers and employees by providing information, advice, training, conciliation and other services that prevent, manage or resolve workplace problems.

Acas: Britain’s Workplace Experts

Acas has been recognised for its Diversity and Inclusion in the workplace from the Employers Network for Equality and Inclusion awards; it has been Disability Confident Highly Commended, a Pay Gap award winner, and an Overall winner for public sector organisations. Acas is committed to providing services and developing policies which embrace diversity, promote equality of opportunity and eliminate unlawful discrimination.

Person specification

Essential Technical criteria

Power BI Data Modelling Knowledge: Strong knowledge of Power BI, including Data model construction, DAX, Power Query, and semantic modelling principles such as star schema design [Lead criterion]

Data and Platform Knowledge: Good understanding of SQL, KQL, relational data structures, and modern data platforms such as Azure Synapse and Microsoft Fabric.

Performance and Optimisation Techniques: Knowledge of methods for improving dashboards, visualisation, and model performance, including DAX optimisation and data refresh strategies.

Data Governance and Security: Understanding of data quality, metadata, documentation and secure data handling, including role-based access, workspace access controls, and privacy considerations.

Modern Data Practices: Awareness of agile ways of working and emerging technologies, including developments in AI and CoPilot capabilities.

Essential Experience criteria

Leadership and Capability Building: Experience leading or mentoring others and developing guidance or training to support adoption of reporting tools and good practice [Lead criterion]

Insight Development and Power BI Delivery: Experience designing and delivering data models, datasets, and dashboards that support performance monitoring and business decision making.

Data Integration and Solution Optimisation: Experience integrating data from multiple sources and improving performance of reporting solutions in live environments.

Stakeholder Engagement and Requirements Elicitation: Experience working with stakeholders to define requirements, shape metrics, and deliver outputs that meet user needs.

Desirable criteria (these will be assessed in the event of tie-breaker scenarios at the sift stage only)

Experience of using a range of tools and techniques related to data science and data analysis - to support the creation of innovative products and reports (e.g., Python, R, R Shiny)

Experience of project working within a DDaT environment

Excellent stakeholder relationship management

Relevant Certifications in MS Power BI and evidence of relevant IT/Data Science related training

Benefits

Alongside your salary of £46,750, Advisory, Conciliation and Arbitration Service contributes £13,543 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides .

We’re big believers in rewarding people for the amazing work they do. Take a look at some of the fantastic benefits we offer:

Learning and Development

Health and wellbeing

Pension scheme

Cycle to work scheme

Interest free season ticket loans

Volunteering opportunities

Could you ask for any more?

You’ll have access to a Lifestyle website where you’ll be able to grab savings on a wide range of products, from holidays to your weekly shop.

To find out more, check out: Working for Acas

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 for more information on appropriate and inappropriate use.

Selection process details

This vacancy is using Success Profiles , and will assess your Strengths and Experience.

How to apply

As part of the application process, you will be asked to complete:

An evidence-based Personal Statement and CV reflecting the Essential Experience and Technical criteria as listed in the Person Specification section of this advert. Your Personal Statement should be no longer than 1,250 words. It should avoid generalised assertions, instead including specific examples of achievements, explaining the degree of challenge, what you did and the outcomes.

A separate 250-word Statement reflecting the desirable criteria. Desirable criteria will only be assessed in the event of a tie-breaker scenario at sift or interview.

Should a large number of applications be received, an initial sift may be conducted using the:

Lead Essential Technical criterion: Strong knowledge of Power BI, including DAX, Power Query and semantic modelling principles such as star schema design

Lead Essential Experience criterion: Experience leading or mentoring others and developing guidance or training to support adoption of reporting tools and good practice

Candidates who pass the initial sift may be progressed to a full sift of all the above requirements or progressed straight to interview.

If a large number of applications meet the minimum standard, an interview wait list may be created for this position. This means that if you have met the minimum requirements at sift, you may be placed on a ‘Hold’ status for up to 12 months, and if we are able to invite you to an interview, we will be in touch.

Interview Details

If you have successfully passed sift at the application stage, you will be invited to an interview which will either take place via Microsoft Teams or Face-to-Face, and which will take place from the week commencing 03 August 2026.

It will be an Experience and Strengths based interview.

The following Essential Experience criteria will be assessed at Interview:

Insight Development and Power BI Delivery: Experience designing and delivering dashboards and datasets that support performance monitoring and business decision making

Stakeholder Engagement and Requirements Delivery: Experience working with stakeholders to define requirements, shape metrics and deliver outputs that meet user needs.

The following Essential Technical criteria will be assessed at Interview:

Performance and Optimisation Techniques: Knowledge of methods for improving dashboard and model performance, including efficient DAX patterns and refresh strategies.

Data Governance and Security: Understanding of data quality, metadata, documentation and secure data handling, including access controls and privacy considerations.

A reserve list will be created for this position; this means that if you have passed the interview, but we cannot immediately offer you this position, you will be placed on a reserve list for 12 months and may be considered for similar positions during that time.

Reasonable Adjustments

As a Disability Confident Leader, Acas is committed to creating an inclusive recruitment process. If you have a disability and feel that any part of the recruitment process puts you at a disadvantage, we will work with you to make Reasonable Adjustments that support your needs. If you require any changes to help you apply:

Please contact the Acas Recruitment Team via HRrecruitment@acas.org.uk as soon as possible before the closing date to discuss your needs.

Complete the “Assistance Required” section on the “Additional Requirements” page of your application form to let us know about any adjustments or support you may need during the recruitment process. For example, this might include accessibility arrangements for entering a building or interview room, communication support, modifications to assessment methods, etc.

You can find out more about the Disability Confident Scheme and Reasonable Adjustments by clicking these links.

Want to learn more about Civil Service recruitment? You can find out more on Civil Service Careers, including information on Success Profiles, writing a Personal Statement, acceptable use of Artificial Intelligence, and what to expect at Interview.

For applicants requiring a visa to work in the UK

Please be advised that Acas does not hold a UKVI Sponsorship Licence, so we cannot consider sponsoring a visa applicant or issuing a Certificate of Sponsorship.

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

Security

Successful candidates must undergo a 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)

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

Working for the Civil Service

The Civil Service Code 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 .

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.

The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion

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

Apply and further information

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 : HR Recruitment Team

Email : HRRecruitment@acas.org.uk

Recruitment team

Email : HRRecruitment@acas.org.uk

Further information

If you feel your application has not been treated in accordance with the Code and wish to make a complaint, you should contact us on via HRrecruitment@acas.org.uk in the first instance. If you are not satisfied with the response you receive from us, you can contact the Civil Service Commission.