# DART Resource - Data Analyst

> Contract award record from UK public-sector procurement sources.

## Key facts

- Public buyer: [Environment Agency](/buyers/environment-agency/contract-awards)
- Contract winner: [Turner & Townsend Project Management Limited](/contract-winners/turner-townsend-project-management/public-sector-contract-awards)
- Award value: £153,080
- Award date: 28 April 2023
- Published: 28 July 2023
- Contract start: 9 May 2023
- Contract end: 31 March 2024
- Stage: awarded
- Procurement category: services
- Notice ID: b7b236b7-7f3d-46c2-85a2-a8517fc092df-667117
- OCID: ocds-b5fd17-a6183b52-1b38-4efa-b3ad-8b2608e03bba

## 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\.

## Related contract awards

- [SW - AOMR Lot 3 Wessex RMP 26-27 - Glendale Upper Avon](/contracts/ocds-b5fd17-d7757e3f-e5c5-47ee-aa08-ff29c28e29c6): Environment Agency
- [East - FRAM lot 9c - Client Support Services - AtkinsRéalis UK](/contracts/ocds-b5fd17-1ab01b97-5c29-418d-b945-61a63e74ea5c): Environment Agency
- [East - FRAM lot 9c - Client Support Services - Mott MacDonald](/contracts/ocds-b5fd17-ff27062b-7dc1-40ed-88f9-92a4fa36571a): Environment Agency
- [Becket House Exit Strategy](/contracts/ocds-b5fd17-11d30d83-cef5-4311-868f-eaabefd021ee): Guy's and St Thomas' NHS Foundation Trust
- [Fire Door Survey](/contracts/ocds-b5fd17-a693cc3e-ffcc-4423-a016-88ff73dc893a): The Christie NHS Foundation Trust
- [Professional Service - Seconded Project Management Resource](/contracts/ocds-b5fd17-b5cf3fef-4514-422a-81de-3b47f00f377f): Gloucestershire Hospitals NHS Foundation Trust

## Source

[View the original notice on Contracts Finder](https://www.contractsfinder.service.gov.uk/Notice/b7b236b7-7f3d-46c2-85a2-a8517fc092df-667117)