Frontier Resourcing
Business Intelligence Developer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Business Intelligence Developer
BI Developer – Power BI & Microsoft Fabric
Frontier Resourcing is excited to support an ambitious consultancy delivering innovative project controls solutions across the UK’s most critical sectors, including Infrastructure, Rail, Civil Engineering, Nuclear, and Defence.
As part of their continued growth, they are seeking an experienced BI Developer to join their team in Bridgwater. This is an ideal opportunity to take a leadership role in designing and delivering enterprise-scale Business Intelligence solutions that drive data-driven decision-making across major programmes and projects.
Working within a collaborative and technically skilled team, your key responsibilities will include:
Responsibilities
- Design, develop, and maintain enterprise Power BI semantic models, dashboards, and reports.
- Develop scalable dimensional data models (fact and dimension tables) to support analytical reporting.
- Design and optimise enterprise semantic models using star schema methodologies.
- Develop advanced DAX measures, calculations, and KPIs to support business reporting requirements.
- Optimise Power BI datasets and semantic models for maximum performance and scalability.
- Develop and refine Power Query transformations, including troubleshooting data performance issues.
- Optimise SQL queries and underlying data sources for analytical workloads.
- Work with Microsoft Fabric to build modern analytics solutions.
- Leverage Python in analytics environments, such as Fabric Notebooks and Databricks.
- Support deployment, governance, and automation of enterprise BI solutions.
- Collaborate with technical and business stakeholders to gather requirements and deliver high-impact reporting solutions.
- Promote best practices in data governance, security, and analytics standards.
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.
Essential Skills & Experience
- Extensive experience in developing Power BI semantic models, dashboards, and enterprise reporting solutions.
- Experience delivering analytics solutions within Infrastructure, Rail, Nuclear, Defence, or other highly regulated industries.
- Strong expertise in designing dimensional data models for enterprise analytics.
- Deep knowledge of Microsoft Fabric architecture.
- Advanced experience with DAX and enterprise semantic modelling using star schema design.
- Proven ability in tuning and optimising Power BI semantic models.
- Advanced skills in Power Query, including transformation optimisation and diagnostics.
- Strong SQL knowledge, with experience in optimising data sources for reporting and analytics.
- Familiarity with Python in analytics environments, such as Microsoft Fabric Notebooks or Databricks.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Working knowledge of:
- Microsoft Entra ID (Azure AD) Security Groups
- Role-Based Access Control (RBAC)
- Deployment Pipelines
- REST APIs
- Data Gateway Architecture
- Audit Logging and Monitoring
- Implementation of governance frameworks in enterprise analytics platforms.
Desirable Skills
- Experience working with Azure-based data platforms.
- Knowledge of enterprise data governance frameworks.
What’s on Offer?
- Join a fast-growing consultancy delivering work on nationally significant programmes.
- First-hand exposure to cutting-edge Microsoft Fabric and enterprise analytics technologies.
- Flexible hybrid working arrangements.
- Competitive salary and comprehensive benefits package.
- Support for ongoing professional development and certification.
- Excellent career progression within a consultancy delivering complex digital transformation projects.
The role offers unparalleled opportunity for those with a passion for data-driven decision-making and a desire to shape the future of enterprise BI. If you're ready to make an impact, see [link/application date].
“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