Senior Power BI and Collaboration Engineer

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

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.

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

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

Job contact :

• Name : HR Recruitment Team
• Email : HRRecruitment@acas.org.uk

Recruitment team

• Email : HRRecruitment@acas.org.uk