Senior Power BI and Collaboration Engineer

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., 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, * 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., * 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., 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., * 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

Do you have experience in SQL?, * 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, * 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, Successful candidates must undergo a criminal record check. People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Pulled from the full job description

• Company pension
• Cycle to work scheme, 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