Data and Tools Developer - 31174

Job Description

Do you want to work for an organisation that values difference and includes everyone? Then the Environment Agency is the organisation for you! We are fully committed to being an inclusive employer and ensuring equal opportunities for everyone. We welcome flexible working patterns for all our vacancies, including job share.

We are seeking an enthusiastic Data and Tools Developer. You will be an important part of our Transformation Portfolio Office (TPO), working with colleagues to deliver delivery and assure high-quality data and the develop suitable tools to enable gathering of data and effective provision of management information. Your role will support ensuring that transformation work carried out across the Environment Agency is prioritised and managed effectively to maximise value to the organisation.

Responsibilities include:

• Advising on data standards and best practices of managing data
• Creating tools using Microsoft Power Platform to support delivery of our work and gather accurate data
• Working with portfolio teams and other stakeholders across the organisation to ensure that the data are assured appropriately and fit for purpose
• Preparing, analysing, and summarising various weekly, monthly, and periodic performance reports for use by various key stakeholders, with differing needs – where appropriate developing and putting in place automated tools to support this
• Working with other specialists in the team as well as non-technical business stakeholders
• Supporting development of analytics, modelling and reporting best practice.
• Responding to flood and environmental incidents is a central part of what we do. You will be required to have an incident role and make yourself available to respond to incidents, or to help provide business continuity during an incident. This may attract an additional payment; full training and alternative working arrangements will be available to enable you in your incident role.

The team

The role sits within the Transformation Portfolio Office within the Service Transformation team, Strategy Transformation and Assurance Directorate. Our vision is to enable the Environment Agency to deliver the right transformation in the right way, at the right time, with the right people. Our purpose is to:

• Invest to make the EA more effective/efficient
• Deliver transformation
• Improve wellbeing by ensuring changes are managed in a balanced way
• Right People with professional skills to deliver transformation

Experience/skills Required

We are looking for highly organised problem-solvers who can use their love for data to improve our service.

Essential skills:

• Experience in developing business information, using Power Platform and data analytics (Power Query, PowerApps, PowerAutomate, PowerBI)
• Experience in understanding metadata/data quality/data standards
• Proficient in using Excel and database querying to sort/manipulate data to identify errors
• Attention to detail, a passion for accuracy
• A positive attitude and a collaborative ‘can-do' approach to problem-solving
• Self-motivated, ability to work on own initiative
• Ability to communicate complex data in various formats
• Advanced numerical/analytical skills, experience in collecting/organising/analysing/disseminating large volumes of information accurately
• Ability to plan and deliver to tight timescales

Desirable skills:

• Experience in using APIs, Microsoft Dataverse and common programming/querying languages (python, SQL etc)
• Awareness of project management, Portfolio Management, or Programme Management Offices (PMO)
• Knowledge/experience in change management/business analysis.

Contact and additional information

In this national role, you can work in any one of 50 offices across England. We encourage blended home and office working. Some travel will be required to attend meetings and training. Interviews will take place from 3 July 2025 via MS Teams.

For further details please contact: Talent Acquisition Coordination Team: eatalent@environment-agency.gov.uk

Feedback is generally not available at sift stage. Further similar roles, either permanent or temporary, will be available across the organisation. If candidates consent to be on the reserve list, we will hold your details for 6 months and we may offer you an alternative post.

Competence 1

Data and Information Management

Description Definition : Collects, analyses, interprets, records, manages, develops and shares data, material or information appropriately for a variety of purposes. Please provide an example of where you have had to create a tool for the purposes of gathering data from users, then processing and storing the data securely. What software did you use, how did you capture and process the data? If a large number of applications are received, an initial sift using this lead competence may be conducted. Successful candidates will then proceed to a full sift or directly to assessment/interview. ou may wish to use the STAR (Situation, Task, Action Result) to formulate your answer to this question

Competence 2

Communicates Effectively

Description Definition: Listens and questions to understand and engage. Conveys information and ideas clearly, accurately and persuasively through speech and writing. Please tell us about a situation where you have communicated complex information to a non-technical audience. What was the desired outcome, who was the audience, how did you gather and present the information and what systems did you use? ou may wish to use the STAR (Situation, Task, Action Result) to formulate your answer to this question

Competence 3

Achieves Results

Description Definition: Sets and delivers high work standards, demonstrates the drive to meet targets. Prioritises and organises tasks and resources to ensure timely achievement of results. Please describe how you organise your own work and ensure the teams you work with deliver the outcomes with the most benefits. What tools do you use and how do you deal with competing pressures? You may wish to use the STAR (Situation, Task, Action Result) to formulate your answer to this question.

If you are applying from the Civil Service please note that the Environment Agency is not a part of HM Civil Service and you would not be a Crown Servant in the event of being appointed. Therefore, you will not be eligible for continuous service. For applicants who currently work in local government or other bodies listed in the Redundancy Payments (Continuity of Employment in Local Government etc) (Modification) Order 1999, you may be eligible for continuous service for the purpose of calculating any future redundancy payment. If you are unsure of your status then you should contact your own HR Team.

We are fully committed to having a diverse and inclusive workforce to reflect the communities we serve. We welcome flexible working patterns for all our vacancies, including job share, so please include clearly any information regarding your preferred working arrangements on your application. We also have a Guaranteed Interview Policy to support those with a disability who are seeking employment. We have committed to guaranteeing an interview to anyone with a disability whose application meets the minimum criteria for the post.

The Environment Agency, as a Non-Departmental Public Body, is committed to providing value for money and utilises Central Government frameworks and contracts for all external recruitment needs. For this reason, we are unable to engage with the market directly through post, email or phone calls . Should you wish to become a support supplier on one of these frameworks or contracts please visit https://www.gov.uk/government/publications/become-a-crown-commercial-service-supplier/becoming-a-supplier-through-the-crown-commercial-service-what-you-need-to-know for more information.