Business Intelligence Developer

On behalf of Defra, we are looking for a Business Intelligence Developer (Inside IR35) for a 4 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. Disability Confident As a member of the Disability Confident Scheme, Defra guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance. Armed Forces Covenant Defra guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance. 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".