AMS PSR

On behalf of Defra, we are looking for a Data Modeller (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.

Our objectives are:

• To pass on to the next generation a natural environment protected and enhanced for the future. 
• To lead the world in food, farming, and fisheries with a sustainable model of food production. 
• To be an outstanding organisation focused on making a difference, with world class delivery capability.

Department for Environment, Food & Rural Affairs www.gov.uk. 

25 Year Environment Plan - GOV.UK www.gov.uk

As a Data Modeller, your main responsibilities will be:

We are seeking a highly skilled Data Modeller 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 implement robust data models to support reporting and analytics.
• Collaborate with data engineering teams to optimise data pipelines and storage solutions.
• Ensure data integrity, consistency, and compliance with governance standards.
• Work with stakeholders to translate business requirements into scalable data solutions.
• Support integration and management of data across Microsoft Fabric and Dataverse environments.

Essential:

• SQL Expertise: Advanced skills in writing, optimising, and troubleshooting complex queries.
• Data Engineering: Strong understanding of ETL processes, data pipelines, and performance tuning.
• Microsoft Fabric: Hands-on experience with Fabric components for analytics and data management.
• Dataverse: Practical knowledge of data modelling and integration within Microsoft Dataverse.
• 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 another data modeller.

Desirable:

• Experience with Power BI and other Microsoft ecosystem tools.
• Familiarity with cloud-based data platforms and modern data architecture principles.

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".