Notice Information
Notice Title
DART Resource - Data Analyst
Notice 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.
Notice Details
Publication & Lifecycle
- Open Contracting ID
- ocds-b5fd17-a6183b52-1b38-4efa-b3ad-8b2608e03bba
- Publication Source
- Contracts Finder
- Latest Notice
- https://www.contractsfinder.service.gov.uk/Notice/b7b236b7-7f3d-46c2-85a2-a8517fc092df
- Current Stage
- Award
- All Stages
- Award
Procurement Classification
- Notice Type
- Award Notice
- Procurement Type
- Framework
- Procurement Category
- Services
- Procurement Method
- Selective
- Procurement Method Details
- Call-off from a framework agreement
- Tender Suitability
- SME
- Awardee Scale
- Not specified
Common Procurement Vocabulary (CPV)
- CPV Divisions
71 - Architectural, construction, engineering and inspection services
-
- CPV Codes
71621000 - Technical analysis or consultancy services
Notice Value(s)
- Tender Value
- Not specified
- Lots Value
- Not specified
- Awards Value
- £153,080 £100K-£500K
- Contracts Value
- Not specified
Notice Dates
- Publication Date
- 28 Jul 20232 years ago
- Submission Deadline
- 17 Apr 2023Expired
- Future Notice Date
- Not specified
- Award Date
- 27 Apr 20232 years ago
- Contract Period
- 8 May 2023 - 31 Mar 2024 6-12 months
- Recurrence
- Not specified
Notice Status
- Tender Status
- Complete
- Lots Status
- Not Specified
- Awards Status
- Active
- Contracts Status
- Not Specified
Buyer & Supplier
Contracting Authority (Buyer)
- Main Buyer
- ENVIRONMENT AGENCY
- Contact Name
- Available with D3 Tenders Premium →
- Contact Email
- Available with D3 Tenders Premium →
- Contact Phone
- Available with D3 Tenders Premium →
Buyer Location
- Locality
- WARRINGTON
- Postcode
- WA4 1HT
- Post Town
- Warrington
- Country
- England
-
- Major Region (ITL 1)
- TLD North West (England)
- Basic Region (ITL 2)
- TLD6 Cheshire
- Small Region (ITL 3)
- TLD61 Warrington
- Delivery Location
- Not specified
-
- Local Authority
- Warrington
- Electoral Ward
- Latchford East
- Westminster Constituency
- Warrington South
Further Information
Notice Documents
-
https://www.contractsfinder.service.gov.uk/Notice/b7b236b7-7f3d-46c2-85a2-a8517fc092df
28th July 2023 - Awarded contract notice on Contracts Finder -
https://www.contractsfinder.service.gov.uk/Notice/0d8f56a4-d0a5-48b5-a4d3-cab4667a2815
17th May 2023 - Awarded contract notice on Contracts Finder -
https://www.contractsfinder.service.gov.uk/Notice/Attachment/422fb4cd-2e03-4a48-88f1-6f01bb669fc6
Data Analyst - NEC4 PSC - DART Resource_Redacted -
https://www.contractsfinder.service.gov.uk/Notice/Attachment/6b696e55-3bd7-4061-937a-1231d3022975
Data Analyst - NEC4 PSC - DART Resource_Redacted
Open Contracting Data Standard (OCDS)
View full OCDS Record for this contracting process
The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts.
{
"tag": [
"compiled"
],
"id": "ocds-b5fd17-a6183b52-1b38-4efa-b3ad-8b2608e03bba-2023-07-28T14:11:55+01:00",
"date": "2023-07-28T14:11:55+01:00",
"ocid": "ocds-b5fd17-a6183b52-1b38-4efa-b3ad-8b2608e03bba",
"language": "en",
"initiationType": "tender",
"tender": {
"id": "CF-0079200D8d000003VQwdEAG",
"title": "DART Resource - Data Analyst",
"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.",
"status": "complete",
"classification": {
"scheme": "CPV",
"id": "71621000",
"description": "Technical analysis or consultancy services"
},
"items": [
{
"id": "1",
"deliveryAddresses": [
{
"postalCode": "WA4 1HT"
},
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
},
{
"postalCode": "WA4 1HT"
},
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
}
]
}
],
"procurementMethod": "selective",
"procurementMethodDetails": "Call-off from a framework agreement",
"tenderPeriod": {
"endDate": "2023-04-17T15:00:00+01:00"
},
"contractPeriod": {
"startDate": "2023-05-09T00:00:00+01:00",
"endDate": "2024-03-31T23:59:59+01:00"
},
"suitability": {
"sme": true,
"vcse": false
},
"mainProcurementCategory": "services"
},
"parties": [
{
"id": "GB-CFS-229938",
"name": "Environment Agency",
"identifier": {
"legalName": "Environment Agency"
},
"address": {
"streetAddress": "Richard Fairclough House",
"locality": "Warrington",
"postalCode": "WA4 1HT",
"countryName": "United Kingdom"
},
"contactPoint": {
"name": "Rebecca Pickthall",
"email": "rebecca.pickthall@defra.gov.uk"
},
"roles": [
"buyer"
]
},
{
"id": "GB-CFS-240179",
"name": "Turner & Townsend Project Management Limited",
"identifier": {
"legalName": "Turner & Townsend Project Management Limited"
},
"address": {
"streetAddress": ", Leeds"
},
"roles": [
"supplier"
]
},
{
"id": "GB-CFS-209999",
"name": "Turner & Townsend Project Management Limited",
"identifier": {
"legalName": "Turner & Townsend Project Management Limited"
},
"address": {
"streetAddress": "Low Hall, Calverley Lane, Horsforth, Leeds LS18 4GH"
},
"roles": [
"supplier"
]
}
],
"buyer": {
"id": "GB-CFS-229938",
"name": "Environment Agency"
},
"awards": [
{
"id": "ocds-b5fd17-a6183b52-1b38-4efa-b3ad-8b2608e03bba-1",
"status": "active",
"date": "2023-05-28T00:00:00+01:00",
"datePublished": "2023-05-17T07:39:34+01:00",
"value": {
"amount": 153080,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-240179",
"name": "Turner & Townsend Project Management Limited"
}
],
"contractPeriod": {
"startDate": "2023-05-09T00:00:00+01:00",
"endDate": "2024-03-31T23:59:59+01:00"
},
"documents": [
{
"id": "1",
"documentType": "awardNotice",
"description": "Awarded contract notice on Contracts Finder",
"url": "https://www.contractsfinder.service.gov.uk/Notice/0d8f56a4-d0a5-48b5-a4d3-cab4667a2815",
"datePublished": "2023-05-17T07:39:34+01:00",
"format": "text/html",
"language": "en"
},
{
"id": "2",
"description": "Data Analyst - NEC4 PSC - DART Resource_Redacted",
"url": "https://www.contractsfinder.service.gov.uk/Notice/Attachment/422fb4cd-2e03-4a48-88f1-6f01bb669fc6",
"format": "application/pdf"
}
]
},
{
"id": "ocds-b5fd17-a6183b52-1b38-4efa-b3ad-8b2608e03bba-2",
"status": "active",
"date": "2023-04-28T00:00:00+01:00",
"datePublished": "2023-07-28T14:11:55+01:00",
"value": {
"amount": 153080,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-209999",
"name": "Turner & Townsend Project Management Limited"
}
],
"contractPeriod": {
"startDate": "2023-05-09T00:00:00+01:00",
"endDate": "2024-03-31T23:59:59+01:00"
},
"documents": [
{
"id": "3",
"documentType": "awardNotice",
"description": "Awarded contract notice on Contracts Finder",
"url": "https://www.contractsfinder.service.gov.uk/Notice/b7b236b7-7f3d-46c2-85a2-a8517fc092df",
"datePublished": "2023-07-28T14:11:55+01:00",
"format": "text/html",
"language": "en"
},
{
"id": "4",
"description": "Data Analyst - NEC4 PSC - DART Resource_Redacted",
"url": "https://www.contractsfinder.service.gov.uk/Notice/Attachment/6b696e55-3bd7-4061-937a-1231d3022975",
"format": "application/pdf"
}
]
}
]
}