As part of their continued growth, they are looking for an experienced BI Developer to join their team in Bridgwater. This is an excellent opportunity to play a key role in designing and delivering enterprise-scale Business Intelligence solutions that enable data-driven decision making across major programmes and projects.
Working within a collaborative and technically skilled team, you'll be responsible for developing scalable Power BI solutions, semantic models and analytics capabilities using the latest Microsoft technologies, including Microsoft Fabric.
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 to maximise performance and scalability.
- Develop and enhance Power Query transformations and troubleshoot data performance issues.
- Optimise SQL queries and underlying data sources for analytical workloads.
- Work with Microsoft Fabric to develop modern analytics solutions.
- Utilise Python within analytics environments, including Fabric Notebooks and Databricks where appropriate.
- Support deployment, governance and automation of enterprise BI solutions.
- Collaborate with technical and business stakeholders to gather requirements and deliver high-quality reporting solutions.
- Promote best practice across data governance, security and analytics standards.
Essential Skills & Experience
- Extensive experience 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 experience designing dimensional data models for enterprise analytics.
- Excellent knowledge of Microsoft Fabric architecture.
- Advanced experience with DAX and enterprise semantic modelling using star schema design.
- Strong experience tuning and optimising Power BI semantic models.
- Advanced knowledge of Power Query, including transformation optimisation and diagnostics.
- Strong SQL skills with experience optimising data sources for reporting and analytics.
- Experience using Python within analytics environments such as Microsoft Fabric Notebooks or Databricks.
- 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
- Experience implementing governance standards across enterprise analytics platforms.
Desirable Skills
- Experience working within Azure-based data platforms.
- Knowledge of enterprise data governance frameworks.
What's on Offer
- Opportunity to join a fast-growing consultancy delivering work on nationally significant programmes.
- Exposure to cutting-edge Microsoft Fabric and enterprise analytics technologies.
- Hybrid working arrangements.
- Competitive salary and comprehensive benefits package.
- Ongoing professional development and certification support.
- Excellent career progression within a growing consultancy delivering complex digital transformation projects.
BI Developer employer: Frontier Resourcing Ltd
As a leading employer in the manufacturing technology sector, we offer a dynamic work environment that fosters innovation and collaboration. Our commitment to employee growth is evident through continuous professional development opportunities and the chance to work on impactful projects within a highly regulated industry. Located in the UK, our team enjoys a supportive culture that values security, compliance, and excellence, making it an ideal place for Solution Architects looking to make a meaningful contribution to business transformation.
