Senior Power BI and Collaboration Engineer

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 (opens in a new window).

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 (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Strengths and Experience.

How to apply

Please click on the 'Apply now' button.

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) (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.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 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

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.

Attachments

Job Description - G8 Senior Power BI and Collaboration Engineer Opens in new window (docx, 36kB)