Power BI Optimisation Lead

Equans is looking for an Power BI Optimisation Lead to join our team  on a 12 month fixed term contract basis. This is a full-time role working 37.5 hours per week. On offer is a competitive salary, company vehicle or allowance, bonus and benefits package.

As a lead within the BI Support team, you’ll lead efforts to standardise and streamline Power BI deployments, proactively monitor capacity usage, and introduce innovative tooling to support smarter reporting.

Your expertise will be vital in shaping best practices, coaching developers, and enabling a well-governed, scalable reporting environment that empowers decision-makers across the business.

What will you deliver?

Capacity & Strategic Governance

• Lead proactive monitoring and auditing of Power BI model performance, refresh cycles, and resource utilisation to ensure optimal system health.
• Define enterprise-wide benchmarks and publishing protocols to safeguard against inefficient deployments.
• Architect and implement breach detection frameworks with automated alerting for mission-critical models.

Enterprise Model Optimisation

• Drive strategic remediation of underperforming datasets and workspaces, aligning with business priorities.
• Champion standardised model architecture to minimise refresh overhead and eliminate duplication across reporting layers.
• Orchestrate centralised data sourcing strategies to streamline queries and elevate performance at scale.

Tooling Innovation & Automation

• Evaluate and deploy AI-powered extensions and third-party solutions to accelerate model optimisation and reduce manual intervention.
• Spearhead the integration of support applications that enhance delivery velocity and operational efficiency

Strategic Technology Enablement

• Assess and pilot emerging technologies (e.g., Direct Lake, SQL DB instances) to future-proof data infrastructure.
• Design refresh segmentation strategies to mitigate peak load and improve system responsiveness.

Best Practice Leadership

• Develop and embed reusable model templates and modular design frameworks to foster consistency and scalability.
• Establish cross-functional communities of practice to embed Power BI optimisation standards across teams.
• Promote a culture of self-service analytics through scalable, user-friendly model design.

What can we offer you?

On offer is a competitive salary, car or car allowance, bonus and benefits package, which includes;

• 25 days annual leave (+ public holidays)
• Life Cover equivalent to 2x times annual salary
• Employee discount shopping schemes on major brands and retailers
• Gym membership discounts 
• Cycle to work scheme 
• Holiday purchase scheme
• 2 corporate social responsibility days per year
• Broad range of learning opportunities, such as professional qualifications, collective/individual training, and personalized support programmes
• Attractive Employee Referral Rewards Scheme
• Access to our growing employee networks including AccessAbility (representing those with physical and mental disabilities), Encompass (representing the LGBTQ+ community), RISE (representing people from ethnic backgrounds), WOMEN TOGETHER (representing women in Equans), Working Parents, and Young Professionals.
• 24/7 Employee Assistance Program and access to mental wellbeing app

Who are we looking for?

• Strong expertise in Power BI architecture, capacity planning, and performance tuning
• Proficient in DAX, Power Query, and data modelling best practices
• Experience with monitoring tools (e.g., Capacity Metrics App) and alerting systems
• Familiarity with emerging technologies like Direct Lake and AI-driven optimisation
• Ability to translate technical insights into business value and strategic recommendations
• Proven track record of driving cost savings and operational efficiency in BI environments
• Flexible approach with the ability to change priorities at short notice and to manage large workloads and deadlines
• Experience in Power BI development and optimisation, including model design, performance tuning, and capacity management
• Demonstrated success in reducing infrastructure costs and improving report performance through strategic model architecture
• Hands-on experience auditing Power BI environments, identifying inefficiencies, and implementing scalable solutions
• Familiarity with Power BI Premium capacity metrics, refresh diagnostics, and workspace governance
• Experience collaborating with BI teams to embed best practices and coach junior developers
• Track record of introducing innovative tooling and automation to streamline BI delivery
• Exposure to alternative technologies such as Direct Lake, SQL DB instances, and AI-driven optimisation tools
• Expert stakeholder engagement across technical and business teams, with the ability to translate complex insights into actionable recommendations
• Experience leading or contributing to communities of practice and driving adoption of BI standards across an organisation

Who are we?

Equans is a world leader in energy services with nearly 100,000 employees working in more than 50 countries, with an annual turnover of over 17 billion euros.  

In the UK & Ireland, Equans is a provider of technical, FM, regeneration and energy services – with specialist capabilities in smart buildings, green mobility, district & embedded energy and decentralised renewables.

Equans’ 13,500 UK & Ireland employees combine these activities to help businesses, public sector organisations and government to embrace the energy transition towards net zero, and also the digital & industrial transitions that are redesigning the way we move, work and live.

Equans is a Bouygues group company.

What’s next?

If this role is of interest to you, please click below to register, apply, and track your progress! A member of our Resourcing Team will review your application and be in touch.

As part our commitment to better reflect the markets within which we operate, we encourage applications from women, ethnically diverse individuals and people with disabilities, along with all candidates who identify with protected characteristic groups under the Equality Act 2010. 

At Equans we’re committed to delivering a culture where everyone’s voice is heard and supported. We know the value a diverse workforce creates, delivering better results for our people, customers, and stakeholders. Diversity and inclusion is at the core of what we do, should you join Equans you’ll find a welcoming and open workplace where you’re supported and encouraged to be your true self at work. 

You’ll also have access to our growing employee networks including AccessAbility (representing those with physical and mental disabilities), Encompass (representing the LGBTQ+ community), RISE (representing people from ethnic backgrounds), WOMEN TOGETHER (representing women in Equans), Working Parents, Young Professionals, Veterans and Reservists Network (VaR).

For this role, you must have evidence of the right to work in the UK. Unfortunately, we are not able to offer a re-location package with this job role.  Certain roles may require applicants to undergo a Disclosure check, as noted in the role requirements.

The Equans Resourcing Team supports this job advert. Agency involvement is not required. All related enquiries must come to the resourcing team not direct to Equans Managers.