Published date: 17 May 2023

This notice was replaced on 28 July 2023

This notice does not contain the most up-to-date information about this procurement. The most recent notice is:

Awarded contract (published 28 July 2023)

Awarded contract - This means that the contract has been awarded to a supplier.


Contract summary

Industry

  • Technical analysis or consultancy services - 71621000

Location of contract

WA4 1HT

Value of contract

£0

Procurement reference

CF-0079200D8d000003VQwdEAG

Published date

17 May 2023

Closing date

17 April 2023

Closing time

3pm

Contract start date

9 May 2023

Contract end date

31 March 2024

Contract type

Service contract

Procedure type

Call-off from a framework agreement

A mini-competition or direct purchase from a pre-established framework agreement.

Contract is suitable for SMEs?

Yes

Contract is suitable for VCSEs?

No

Description

• Assisting Business Analysts to document data standards that must be applied to data sources to enable more efficient data collection and processing.
• Collecting data from a range of different sources with different formats.
• Using FME and other approaches to ETL data (transformations include applying business rules, KPI calculations and/or data validation tests). Making clear notes on FME Workbenches or in code to assist other/future data analysts.
• Managing the data model in the data warehouse, to ensure that data processing is kept as efficient as possible.
• Building and testing reports, dashboards and ad-hoc queries in a range of output applications (Power BI, Excel, etc.), working with Business Analysts and users during demonstrations and user acceptance testing.

More information

Attachments

Award information

Awarded date

28 May 2023

Contract start date

9 May 2023

Contract end date

31 March 2024

Total value of contract

£153,080

This contract was awarded to 1 supplier.

Turner & Townsend Project Management Limited

Address

, Leeds

Reference

None

About the buyer

Contact name

Rebecca Pickthall

Address

Richard Fairclough House
Warrington
WA4 1HT
United Kingdom

Email

rebecca.pickthall@defra.gov.uk