Looking to lead a dynamic team while leveraging your SQL and Power Query skills? We have the perfect opportunity for you!"
This is a brilliant time to join Rural Payments Agency (RPA) – our organisation is growing and we’re at the heart of delivering the Government’s agricultural transition and making a genuine difference to the health of our environment and rural economy. We continue to make year on year improvements in performance as we become a data and intelligence-led organisation, embedding our vision of customer excellence at every level and growing our reputation to make a difference every day.
Our Data, Insight & Outcomes Business Area is a multidisciplinary team including Geospatial Analysts, Data Engineers and Architects, Data and Intelligence Analysts and a national Field Team. Together, we’re in a unique position to use our specialist skills to work with the agricultural community to deliver big, impactful change, supporting high level environmental and animal welfare outcomes and the move towards net zero. This is an exciting time to join our team as we grow and develop our ability to continuously analyse nationwide agricultural activity and provide agile, directed data and evidence-driven support to the farming community.
We have clear values that we are embedding at every level in our organisation – improving engagement and innovating to be a more inclusive, supportive, and engaging employer. Our people own our values and bring them to life in everything we do – recent new starters have talked glowingly about how supportive and caring their new colleagues are. We are proud of this culture; how open and approachable we are and our commitment to individual development, investing in the skills of our people and creating an environment in which everyone can flourish. We hope this appeals to you.
Further information can be found on the Rural Payments Agency website
The successful candidate will have experience of working with multiple data sources and possess the ability to deliver quality analysis and reporting to tight deadlines, focusing on what matters most to inform decision making.
The role will sit within our Data and Analysis team, working closely with colleagues throughout Operational Delivery and Engagement & Business Readiness. It will involve:
* Continual development and maintenance of our data production service of Power Query based toolkits and feeds for MI.
* Ensuring the service is efficient, robust and constantly looking to improve and enhance it, including working with Power Automate and Dataflows.
* Help transition legacy-based MS access data production tools into Power query.
* Maintain a range of tools which take non-structured data to create a standard source, which can be used to support both operational processing and MI delivery across all RPA Lines of Business.
* Exploring and exploiting the data available within the agency, utilising this to provide MI and validate underpinning planning assumptions.
* Supporting the delivery of our strategic aim to be RPA ‘single source of the truth’ on the agency’s performance against our commitments.
* Working closely with colleagues in Operational Delivery and key stakeholders, to ensure solutions are fit for purpose.
Responsibilities
* Provide a cohesive data and MI suite, consistently delivered accurately and on time, in line with demanding SLAs.
* Assess customers’ requirements, plan the development and delivery of solutions, ensuring these are delivered accurately, to deadline.
* Enable efficient, effective and timely decision making, by building an understanding of our data sources, and choosing the most appropriate data and tool for each purpose.
* Manage the team’s development work programme, ensuring outputs are delivered to deadline and of good quality.
* Help steer the direction of data within RPA, feeding into the Data Strategy.
* Unit test products to ensure the data produced is of high quality and meets requirements. Setting the teams overall quality processes and documentation.
* Work with customers to ensure that their requirements are fully understood, and outputs meet their needs, utilising prototyping where appropriate.
* Work closely with data suppliers to gain access to data in the most suitable form for RPA.
Proud member of the Disability Confident employer scheme
Disability Confident
About Disability Confident
A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident .