Your new company

One of the large Public Sector Organisations in the UK

Your new role

Data Modeller – Excel Calculator

What you'll need to succeed

My client is looking for a Data Modeller to support across a 4-week period before the end of the Financial Year – the role will entail developing two user-friendly Excel-based calculators:

1. Excel calculator development
   • Develop two user-friendly, Excel-based calculators for quantifying the nutrient reductions (in nitrogen and phosphorus) generated by:
     1. Land Use Change – the conversion of land from uses associated with high nutrient exports (intensive agriculture) to uses associated with low nutrient exports (semi-natural greenspace).
     2. Septic tank and PTP Upgrades – upgrading inefficient septic tanks or PTPs to more efficient PTP models. Natural England will provide a draft version of this calculator to be updated.
   • Use input datasets that have been provided by Natural England. These will include nutrient export coefficients derived from Farmscoper, soil type, and rainfall.
   • Provide precautionary nutrient reduction estimates (in kg of total nitrogen and total phosphorus/ha/year) based on a methodology specified by Natural England.
   • Ensure the calculators enable changes to input datasets that can be administered by Natural England in the future.
2. Written technical methodology
   • Document the methodology for calculating the nutrient reductions generated by the two measures in a format that ensures reproducibility by Natural England.
   • Detail all assumptions, limitations, and uncertainties.
3. User instructions
   • Write a set of clear user instructions to accompany each calculator that:
     1. Provide step-by-step guidance for the user to input site-specific information.
     2. Explain technical terms in plain, accessible language.
     3. Follow Natural England’s accessibility requirements.

• One calculator for quantifying the nutrient reductions generated by land use change.
• One updated calculator for quantifying the nutrient reductions generated by septic tank and PTP upgrades.
• Each calculator will be accompanied by:
  1. Clear, step-by-step user instructions that meet Natural England’s accessibility standards.
  2. Technical methodology to ensure reproducibility by Natural England. Including assumptions, uncertainties, and limitations.

What you'll get in return

This is a 4-week remote engagement for someone to set up Excel Calculators, aiding the new FY.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.

If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.