Business Intelligence Developer

On behalf of Defra, we are looking for a Business Intelligence Developer (Inside IR35) for a 3 Month contract based REMOTELY/in UK Wide.

In the Defra group, we deal with a vast range of issues that profoundly impact on people's lives. We are responsible for England's environment, our countryside and rural economy, the food and farming sectors and have lead responsibility for protection from a wide range of natural threats and hazards. We have developed a set of three strategic objectives covering our policy outcomes and corporate objectives. These objectives help us to deliver our ambitious vision to build our green and healthy future and provide a framework for all the important work we carry out.

We are seeking a highly skilled Business Intelligence to join our team and play a key role in designing, structuring, and optimising data models that support our Business Intelligence and analytics initiatives. You will work closely with data engineers, analysts, and stakeholders to ensure data is accessible, reliable, and aligned with organisational needs.

. Design and develop BI solutions, including dashboards and reports, to meet business requirements.
. Implement and optimize data models for reporting purposes (not just high-level conceptual modelling).
. Ensure data accuracy, consistency, and usability across BI platforms

Essential:
. SQL Expertise: Advanced skills in writing, optimising, and troubleshooting complex queries.
. Proven experience as a BI Developer or in a similar role.
. Hands-on experience with Microsoft Fabric.
. Strong understanding of Data Visualisation and reporting best practices.
. Ability to deliver practical, business-focused solutions quickly and effectively. Strong analytical and problem-solving skills with attention to detail.
. Excellent communication skills for working with technical and non-technical stakeholders.
. Experience of working independently and alongside data modellers.

Desirable:
. Experience with Power BI and other Microsoft ecosystem tools.
. Familiarity with cloud-based data platforms and modern data architecture principles.
. Dataverse: Practical knowledge of data modelling and integration within Microsoft Dataverse.

Please be aware that this role can only be worked within the UK and not Overseas.

In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".