Equans UK & Ireland
Power BI Optimisation Lead
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Power BI Optimisation Lead
Power BI Optimisation Lead (Fixed Term, 12 Months)
Equans is seeking an Power BI Optimisation Lead to join our BI Support team on a 12-month fixed-term contract basis. This is a full-time position (37.5 hours per week) offering a competitive salary, company vehicle/allowance, bonus, and comprehensive benefits package.
About the Role
As a lead within the BI Support team, you’ll lead efforts to:
- Standardise and streamline Power BI deployments
- Proactively monitor capacity usage
- Introduce innovative tooling for smarter reporting
Your expertise will be critical in shaping best practices, coaching developers, and establishing a well-governed, scalable reporting environment—empowering decision-makers across the business.
What You’ll Deliver
Capacity & Strategic Governance
- Lead proactive monitoring and auditing of Power BI performance (models, refresh cycles, resource utilisation)
- Define enterprise-wide benchmarks and publishing protocols to prevent 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, aligned with business priorities
- Champion standardised model architecture to minimise refresh overhead and eliminate duplication
- Orchestrate centralised data sourcing strategies to streamline queries and improve performance at scale
Tooling Innovation & Automation
- Evaluate and deploy AI-powered extensions and third-party solutions to accelerate optimisation and reduce manual effort
- Lead 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
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Best Practice Leadership
- Develop and embed reusable model templates and modular design frameworks for consistency and scalability
- Establish cross-functional communities of practice to embed Power BI optimisation standards
- Promote self-service analytics through scalable, user-friendly model design
What We Offer
Our benefits package includes:
-
25 days annual leave (+ public holidays)
-
Life cover equivalent to 2x annual salary
-
Employee discount schemes (major brands & retailers)
-
Gym membership discounts
-
Cycle to work scheme
-
Holiday purchase scheme
-
2 corporate social responsibility days per year
-
Broader learning opportunities (qualifications, training, and support)
-
Attractive employee referral rewards
-
Growing employee networks, including:
- AccessAbility (physical & mental disabilities)
- Encompass (LGBTQ+ community)
- RISE (ethnic backgrounds)
- Women Together (women in Equans)
- Working Parents
- Young Professionals
- Veterans and Reservists Network (VaR)
-
24/7 Employee Assistance Program
-
Access to a mental wellbeing app
Who We’re Looking For
Key Requirements
- Strong expertise in Power BI architecture, capacity planning, and performance tuning
- Proficiency in DAX, Power Query, and data modelling best practices
- Experience with monitoring tools (e.g., Capacity Metrics App) and alerting systems
- Familiarity with Direct Lake and AI-driven optimisation
- Ability to translate technical insights into business value and strategic recommendations
- Proven track record of reducing costs and operational inefficiencies in BI environments
- Flexible, adaptable mindset with the ability to manage large workloads and tight deadlines
Specific Experience
- Hands-on experience in:
- Power BI model design
- Performance tuning and capacity management
- Infra-cost reduction and report performance optimisation
- Auditing Power BI environments to identify inefficiencies
- Experience with Power BI Premium capacity metrics, refresh diagnostics, and workspace governance
- Collaborative experience in:
- Embedding best practices
- Coaching junior developers
- Track record of introducing innovative tooling and automation
- Exposure to Direct Lake, SQL DB instances, and AI-driven optimisation tools
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Stakeholder Engagement
- Strong expertise in translating complex insights into actionable recommendations
- Experience leading or contributing to communities of practice
- Ability to consult across technical and business teams
About Equans
Equans is a global leader in energy services, operating in 50+ countries with nearly 100,000 employees and an annual turnover of over €17 billion.
In the UK & Ireland, we deliver:
- Technical, FM, regeneration, and energy services
- Smart buildings, green mobility, district/embedded energy, and decentralised renewables
We support businesses, public sector organisations, and government in achieving:
- Net-zero goals
- Digital and industrial transitions
As a Bouygues Group company, Equans is committed to diversity, inclusion, and sustainability—embedded in our culture.
Next Steps
If this role interests you, apply now via the link below. A member of our Resourcing Team will review your application.
Equity & Inclusion Commitment
Equans actively encourages applications from:
- Women
- Ethnically diverse individuals
- People with disabilities
- All protected characteristic groups under the Equality Act 2010
At Equans, we foster a welcoming, inclusive workplace where every voice is heard.
Additional Notes
- Right to work in the UK is mandatory—no relocation package provided.
- Certain roles may require a DBS check.
For enquiries, please contact the Equans Resourcing Team (agencies need not apply).
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location