← Back to search results

AwardedFind a Tender · award

FTS - Westminster City Council - P390 Contract for a Data Hub Implementation Partner

Buyer: Westminster City Council →

BuyerWestminster City Council
StatusAwarded
DeadlineNot published
ValueValue not published
Published29 Sept 2025

What is being bought

WCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products. The programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval. It should be noted that the advertised estimated budget of up to £3.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One spend is up to £799,273.00. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary, subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.

Delivery location

UK

Categories

Software implementation services 72263000

Lot details

Lot 1

WCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products. The programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval. Phase 1 The initial phase will be to design the new data warehouse environment, then migrate and refactor the existing corporate data warehouse. It will involve discovery and analysis around the data sets, privacy considerations, etc. of the data held in the existing Microsoft SQL Server environment. These datasets and their data pipelines will need to be migrated onto the Snowflake environment. Downstream dependencies such as Power BI dashboards will need to be repointed and if necessary, redesigned. Importantly, this will require extensive refactoring. For example, ingestion may move from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF) and the overall architectural pattern will move from ETL to ELT. The migration is therefore not a "lift and shift" migration. However, the scope will be limited to datasets currently processed into the existing CDW.

Statuscancelled

Award criteria
Technical/Quality — 70%
price — 30%

What is included

ItemCategoryQuantity
1Not publishedNot published

Comparable-procurement analytics

Benchmarked against retained Find a Tender procedures with CPV division 72. The category anchor is Software implementation services (72263000); this is a deliberately broad market comparator. The comparison is shown at several levels rather than pretending one company or region is always the best benchmark.

Comparison setProceduresReported bids per procedureNamed award suppliersPrice evidence
Market: CPV division 724,4541 median · 11.5 average (1,518 of 4,454 with a bid count)1.7 average (1,763 of 4,454 with named award suppliers)Not published
Same buyer31 median · 1 average (2 of 3 with a bid count)1 average (3 of 3 with named award suppliers)Not published
Delivery region: UK1,4151 median · 23.6 average (446 of 1,415 with a bid count)2.6 average (550 of 1,415 with named award suppliers)Not published

“Reported bids” is an official aggregate, sometimes reported per lot; it is the closest available competition measure. “Named award suppliers” are winners, not all applicants.

Price-outcome signal

Not enough comparable procedures currently publish both a GBP tender value and a usable lowest-valid-bid value to calculate a responsible price-reduction benchmark. Tenderline deliberately does not infer a saving from named award suppliers or from missing award values.

Procurement strategy & market signals

Framework agreementNot published
Dynamic purchasing systemNot published
Competitive procurementNot published
Recurring requirementNot published
Procurement method rationaleNot published
Rationale classificationsNot published
Special regimeNot published
Covered byGPA
Submission policyNot published
Selection criteriaNot published
Risk detailsNot published

Planning & early market engagement

BudgetNot published
No-engagement rationaleNot published
Planning documents0
Planning milestones0

No planning milestones published.

Related procurements

No linked framework, prior procurement or reprocurement published.

Awards

Contracts

Contract for a Data Hub Implementation Partner

Statusactive
Value£3,870,000

Documents & submission route

No documents are published in the current source record.

Source data inventory

Diagnostic view. “Not published” means this current release does not provide a value.

OCIDocds-h6vhtk-04fe91
Latest release ID060664-2025
Latest release timestampMon Sep 29 2025 15:37:40 GMT+0000 (Coordinated Universal Time)
Sourcefind-a-tender
Official notice URLNot published
Tender statuscomplete
Procurement methodselective
Procurement method detailsRestricted procedure
Main procurement categoryservices
Above thresholdNot published
Legal basis32014L0024
Tender period: startNot published
Tender period: endNot published
Expression of interest deadlineNot published
Enquiry deadlineNot published
Award period: startNot published
Award period: endNot published
Submission method detailsNot published
Submission languagesNot published
Electronic catalogue policyNot published
Total tender valueNot published
Tender lots in source1
Tender items in source1
Tender documents in source0
Awards in latest release1
Contracts in latest release1
Parties in latest release3

Notice history

DateEventReference
29 Sept 2025award, contract060664-2025
8 Apr 2025tenderUpdate013608-2025
8 Apr 2025tender013577-2025

All source data

Unmodified official OCDS data retained by Tenderline for this procurement process.

Complete current OCDS release JSON
{
  "id": "060664-2025",
  "tag": [
    "award",
    "contract"
  ],
  "bids": {
    "statistics": [
      {
        "id": "1",
        "value": 5,
        "measure": "bids",
        "relatedLot": "1"
      }
    ]
  },
  "date": "2025-09-29T16:37:40+01:00",
  "ocid": "ocds-h6vhtk-04fe91",
  "buyer": {
    "id": "GB-FTS-5427",
    "name": "Westminster City Council"
  },
  "awards": [
    {
      "id": "060664-2025-1",
      "title": "Contract for a Data Hub Implementation Partner",
      "status": "active",
      "suppliers": [
        {
          "id": "GB-FTS-162328",
          "name": "Altimetrik UK Limited"
        }
      ],
      "relatedLots": [
        "1"
      ]
    }
  ],
  "tender": {
    "id": "ocds-h6vhtk-04fe91",
    "lots": [
      {
        "id": "1",
        "status": "cancelled",
        "hasOptions": false,
        "description": "WCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products.\nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.\nPhase 1\nThe initial phase will be to design the new data warehouse environment, then migrate and refactor the existing corporate data warehouse. It will involve discovery and analysis around the data sets, privacy considerations, etc. of the data held in the existing Microsoft SQL Server environment. These datasets and their data pipelines will need to be migrated onto the Snowflake environment. Downstream dependencies such as Power BI dashboards will need to be repointed and if necessary, redesigned. Importantly, this will require extensive refactoring. For example, ingestion may move from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF) and the overall architectural pattern will move from ETL to ELT. The migration is therefore not a \"lift and shift\" migration. However, the scope will be limited to datasets currently processed into the existing CDW.",
        "awardCriteria": {
          "criteria": [
            {
              "name": "Technical/Quality",
              "type": "quality",
              "description": "70%"
            },
            {
              "type": "price",
              "description": "30%"
            }
          ]
        }
      }
    ],
    "items": [
      {
        "id": "1",
        "relatedLot": "1",
        "deliveryAddresses": [
          {
            "region": "UK"
          }
        ]
      }
    ],
    "title": "FTS - Westminster City Council - P390 Contract for a Data Hub Implementation Partner",
    "status": "complete",
    "coveredBy": [
      "GPA"
    ],
    "legalBasis": {
      "id": "32014L0024",
      "scheme": "CELEX"
    },
    "description": "WCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products.\nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.\nIt should be noted that the advertised estimated budget of up to £3.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One spend is up to £799,273.00. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary, subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.",
    "classification": {
      "id": "72263000",
      "scheme": "CPV",
      "description": "Software implementation services"
    },
    "procurementMethod": "selective",
    "mainProcurementCategory": "services",
    "procurementMethodDetails": "Restricted procedure"
  },
  "parties": [
    {
      "id": "GB-FTS-5427",
      "name": "Westminster City Council",
      "roles": [
        "buyer"
      ],
      "address": {
        "region": "UKI32",
        "locality": "London",
        "postalCode": "SW1E 6QP",
        "countryName": "United Kingdom",
        "streetAddress": "64 Victoria Street"
      },
      "details": {
        "url": "https://wcc.ukp.app.jaggaer.com",
        "buyerProfile": "http://www.westminster.gov.uk",
        "classifications": [
          {
            "id": "REGIONAL_AUTHORITY",
            "scheme": "TED_CA_TYPE",
            "description": "Regional or local authority"
          },
          {
            "id": "01",
            "scheme": "COFOG",
            "description": "General public services"
          }
        ]
      },
      "identifier": {
        "legalName": "Westminster City Council"
      },
      "contactPoint": {
        "email": "tenders@westminster.gov.uk"
      }
    },
    {
      "id": "GB-FTS-162328",
      "name": "Altimetrik UK Limited",
      "roles": [
        "supplier"
      ],
      "address": {
        "region": "UK",
        "locality": "Wokingham",
        "postalCode": "RG41 5TP",
        "countryName": "United Kingdom",
        "streetAddress": "Building 220, Wharfdale Road, Winnersh"
      },
      "details": {
        "scale": "sme"
      },
      "identifier": {
        "legalName": "Altimetrik UK Limited"
      }
    },
    {
      "id": "GB-FTS-5080",
      "name": "The High Court of Justice",
      "roles": [
        "reviewBody"
      ],
      "address": {
        "locality": "London",
        "postalCode": "WC2A 2LL",
        "countryName": "United Kingdom",
        "streetAddress": "The Royal Court of Justice, The Strand"
      },
      "identifier": {
        "legalName": "The High Court of Justice"
      }
    }
  ],
  "language": "en",
  "contracts": [
    {
      "id": "060664-2025-1",
      "title": "Contract for a Data Hub Implementation Partner",
      "value": {
        "amount": 3870000,
        "currency": "GBP"
      },
      "status": "active",
      "awardID": "060664-2025-1",
      "dateSigned": "2025-09-26T00:00:00+01:00"
    }
  ],
  "initiationType": "tender"
}
Complete JSON history (3 releases)
29 Sept 2025 · 060664-2025 · award, contract
{
  "id": "060664-2025",
  "tag": [
    "award",
    "contract"
  ],
  "bids": {
    "statistics": [
      {
        "id": "1",
        "value": 5,
        "measure": "bids",
        "relatedLot": "1"
      }
    ]
  },
  "date": "2025-09-29T16:37:40+01:00",
  "ocid": "ocds-h6vhtk-04fe91",
  "buyer": {
    "id": "GB-FTS-5427",
    "name": "Westminster City Council"
  },
  "awards": [
    {
      "id": "060664-2025-1",
      "title": "Contract for a Data Hub Implementation Partner",
      "status": "active",
      "suppliers": [
        {
          "id": "GB-FTS-162328",
          "name": "Altimetrik UK Limited"
        }
      ],
      "relatedLots": [
        "1"
      ]
    }
  ],
  "tender": {
    "id": "ocds-h6vhtk-04fe91",
    "lots": [
      {
        "id": "1",
        "status": "cancelled",
        "hasOptions": false,
        "description": "WCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products.\nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.\nPhase 1\nThe initial phase will be to design the new data warehouse environment, then migrate and refactor the existing corporate data warehouse. It will involve discovery and analysis around the data sets, privacy considerations, etc. of the data held in the existing Microsoft SQL Server environment. These datasets and their data pipelines will need to be migrated onto the Snowflake environment. Downstream dependencies such as Power BI dashboards will need to be repointed and if necessary, redesigned. Importantly, this will require extensive refactoring. For example, ingestion may move from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF) and the overall architectural pattern will move from ETL to ELT. The migration is therefore not a \"lift and shift\" migration. However, the scope will be limited to datasets currently processed into the existing CDW.",
        "awardCriteria": {
          "criteria": [
            {
              "name": "Technical/Quality",
              "type": "quality",
              "description": "70%"
            },
            {
              "type": "price",
              "description": "30%"
            }
          ]
        }
      }
    ],
    "items": [
      {
        "id": "1",
        "relatedLot": "1",
        "deliveryAddresses": [
          {
            "region": "UK"
          }
        ]
      }
    ],
    "title": "FTS - Westminster City Council - P390 Contract for a Data Hub Implementation Partner",
    "status": "complete",
    "coveredBy": [
      "GPA"
    ],
    "legalBasis": {
      "id": "32014L0024",
      "scheme": "CELEX"
    },
    "description": "WCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products.\nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.\nIt should be noted that the advertised estimated budget of up to £3.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One spend is up to £799,273.00. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary, subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.",
    "classification": {
      "id": "72263000",
      "scheme": "CPV",
      "description": "Software implementation services"
    },
    "procurementMethod": "selective",
    "mainProcurementCategory": "services",
    "procurementMethodDetails": "Restricted procedure"
  },
  "parties": [
    {
      "id": "GB-FTS-5427",
      "name": "Westminster City Council",
      "roles": [
        "buyer"
      ],
      "address": {
        "region": "UKI32",
        "locality": "London",
        "postalCode": "SW1E 6QP",
        "countryName": "United Kingdom",
        "streetAddress": "64 Victoria Street"
      },
      "details": {
        "url": "https://wcc.ukp.app.jaggaer.com",
        "buyerProfile": "http://www.westminster.gov.uk",
        "classifications": [
          {
            "id": "REGIONAL_AUTHORITY",
            "scheme": "TED_CA_TYPE",
            "description": "Regional or local authority"
          },
          {
            "id": "01",
            "scheme": "COFOG",
            "description": "General public services"
          }
        ]
      },
      "identifier": {
        "legalName": "Westminster City Council"
      },
      "contactPoint": {
        "email": "tenders@westminster.gov.uk"
      }
    },
    {
      "id": "GB-FTS-162328",
      "name": "Altimetrik UK Limited",
      "roles": [
        "supplier"
      ],
      "address": {
        "region": "UK",
        "locality": "Wokingham",
        "postalCode": "RG41 5TP",
        "countryName": "United Kingdom",
        "streetAddress": "Building 220, Wharfdale Road, Winnersh"
      },
      "details": {
        "scale": "sme"
      },
      "identifier": {
        "legalName": "Altimetrik UK Limited"
      }
    },
    {
      "id": "GB-FTS-5080",
      "name": "The High Court of Justice",
      "roles": [
        "reviewBody"
      ],
      "address": {
        "locality": "London",
        "postalCode": "WC2A 2LL",
        "countryName": "United Kingdom",
        "streetAddress": "The Royal Court of Justice, The Strand"
      },
      "identifier": {
        "legalName": "The High Court of Justice"
      }
    }
  ],
  "language": "en",
  "contracts": [
    {
      "id": "060664-2025-1",
      "title": "Contract for a Data Hub Implementation Partner",
      "value": {
        "amount": 3870000,
        "currency": "GBP"
      },
      "status": "active",
      "awardID": "060664-2025-1",
      "dateSigned": "2025-09-26T00:00:00+01:00"
    }
  ],
  "initiationType": "tender"
}
8 Apr 2025 · 013608-2025 · tenderUpdate
{
  "id": "013608-2025",
  "tag": [
    "tenderUpdate"
  ],
  "date": "2025-04-08T11:48:40+01:00",
  "ocid": "ocds-h6vhtk-04fe91",
  "buyer": {
    "id": "GB-FTS-5427",
    "name": "Westminster City Council"
  },
  "tender": {
    "id": "ocds-h6vhtk-04fe91",
    "title": "Westminster City Council - ITT for a Data Hub Implementation Partner",
    "amendments": [
      {
        "id": "2",
        "unstructuredChanges": [
          {
            "where": {
              "label": "Title",
              "section": "II.1.1"
            },
            "newValue": {
              "text": "Westminster City Council - ITT for a Data Hub Implementation Partner"
            },
            "oldValue": {
              "text": "850000.00"
            }
          }
        ]
      }
    ],
    "legalBasis": {
      "id": "32014L0024",
      "scheme": "CELEX"
    },
    "description": "This opportunity is being procured via the Crown Commercial Service Spark DPS (RM6094). Therefore to be able to submit a tender, you must be registered as a supplier on the DPS. Please note that this can take up to 15 days;\n* Register on the DPS by following the below link by 5pm (UK time) on Friday 11th April 2025. https://supplierregistration.cabinetoffice.gov.uk/organisation/register\n* Register on Westminster City Council's (WCC) eProcurement system Jaggaer https://wcc.ukp.app.jaggaer.com\n* Westminster City Council will pull a shortlist on Wednesday 7th May based on the Spark DPS registered suppliers. Please note that it is the Supplier's responsibility to ensure that they are registered on the DPS and showing live prior to this date.\n* Shortlisted suppliers will be added to the opportunity and able to view & submit a bid\nWCC is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products.\nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.\nPhase 1\nThe initial phase will be to design the new data warehouse environment, then migrate and refactor the existing corporate data warehouse. It will involve discovery and analysis around the data sets, privacy considerations, etc. of the data held in the existing Microsoft SQL Server environment. These datasets and their data pipelines will need to be migrated onto the Snowflake environment. Downstream dependencies such as Power BI dashboards will need to be repointed and if necessary, redesigned. Importantly, this will require extensive refactoring. For example, ingestion may move from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF) and the overall architectural pattern will move from ETL to ELT. The migration is therefore not a \"lift and shift\" migration. However, the scope will be limited to datasets currently processed into the existing CDW.\nIt should be noted that the advertised estimated budget of up to £3.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One budget is up to £850,000.00. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary, subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.",
    "classification": {
      "id": "72263000",
      "scheme": "CPV",
      "description": "Software implementation services"
    },
    "mainProcurementCategory": "services"
  },
  "parties": [
    {
      "id": "GB-FTS-5427",
      "name": "Westminster City Council",
      "roles": [
        "buyer"
      ],
      "address": {
        "region": "UK",
        "locality": "London",
        "postalCode": "SW1E 6QP",
        "countryName": "United Kingdom",
        "streetAddress": "64 Victoria Street"
      },
      "details": {
        "url": "https://wcc.ukp.app.jaggaer.com"
      },
      "identifier": {
        "legalName": "Westminster City Council"
      },
      "contactPoint": {
        "email": "jpeek@westminster.gov.uk"
      }
    }
  ],
  "language": "en",
  "initiationType": "tender"
}
8 Apr 2025 · 013577-2025 · tender
{
  "id": "013577-2025",
  "tag": [
    "tender"
  ],
  "date": "2025-04-08T10:56:59+01:00",
  "ocid": "ocds-h6vhtk-04fe91",
  "buyer": {
    "id": "GB-FTS-5427",
    "name": "Westminster City Council"
  },
  "tender": {
    "id": "ocds-h6vhtk-04fe91",
    "lots": [
      {
        "id": "1",
        "value": {
          "amount": 3870000,
          "currency": "GBP"
        },
        "status": "active",
        "renewal": {
          "description": "The initial Phase One budget is up to £850,000.00 and covers year one of the contract. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary,  subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.  There are 2 x optional 12 month extensions based on the above."
        },
        "hasOptions": false,
        "hasRenewal": true,
        "description": "This opportunity is being procured via the Crown Commercial Service Spark DPS (RM6094).  Therefore to be able to submit a tender, you must be registered as a supplier on the DPS. Please note that this can take up to 15 days;\n* Please register on the DPS by following the below link by 5pm (UK time) on Friday 11th April 2025. https://supplierregistration.cabinetoffice.gov.uk/organisation/register\n* Register on Westminster City Council's eProcurement system Jaggaer https://wcc.ukp.app.jaggaer.com\n* Westminster City Council will pull a shortlist on Wednesday 7th May based on the Spark DPS registered suppliers. Please note that it is the Supplier's responsibility to ensure that they are registered on the DPS and showing live prior to this date.\n* All shortlisted suppliers will be added to the opportunity and able to view and submit a bid.\nWestminster City Council (WCC) is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products. \n\n          \nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.  \n\n          \nPhase One: \nThe initial phase will be to design the new data warehouse environment, then migrate and refactor the existing corporate data warehouse. It will involve discovery and analysis around the data sets, privacy considerations, etc. of the data held in the existing Microsoft SQL Server environment. These datasets and their data pipelines will need to be migrated onto the Snowflake environment. Downstream dependencies such as Power BI dashboards will need to be repointed and if necessary, redesigned. Importantly, this will require extensive refactoring. For example, ingestion may move from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF) and the overall architectural pattern will move from ETL to ELT. The migration is therefore not a “lift and shift” migration. However, the scope will be limited to datasets currently processed into the existing CDW.\nIt should be noted that the advertised estimated budget of up to £3.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One budget is up to £850,000.00. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary,  subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.",
        "contractPeriod": {
          "endDate": "2028-08-17T23:59:59+01:00",
          "startDate": "2025-08-18T00:00:00+01:00"
        },
        "submissionTerms": {
          "variantPolicy": "notAllowed"
        }
      }
    ],
    "items": [
      {
        "id": "1",
        "relatedLot": "1",
        "deliveryAddresses": [
          {
            "region": "UK"
          }
        ]
      }
    ],
    "title": "850000.00",
    "value": {
      "amount": 3870000,
      "currency": "GBP"
    },
    "status": "active",
    "coveredBy": [
      "GPA"
    ],
    "legalBasis": {
      "id": "32014L0024",
      "scheme": "CELEX"
    },
    "techniques": {
      "hasDynamicPurchasingSystem": true
    },
    "description": "This opportunity is being procured via the Crown Commercial Service Spark DPS (RM6094).  Therefore to be able to submit a tender, you must be registered as a supplier on the DPS. Please note that this can take up to 15 days;\n* Please register on the DPS by following the below link by 5pm (UK time) on Friday 11th April 2025. https://supplierregistration.cabinetoffice.gov.uk/organisation/register\n* Register on Westminster City Council's eProcurement system Jaggaer https://wcc.ukp.app.jaggaer.com\n* Westminster City Council will pull a shortlist on Wednesday 7th May based on the Spark DPS registered suppliers. Please note that it is the Supplier's responsibility to ensure that they are registered on the DPS and showing live prior to this date.\n* All shortlisted suppliers will be added to the opportunity and able to view and submit a bid.\nWestminster City Council (WCC) is looking to develop its next generation, strategic data platform, to underpin its reporting, analytics, AI and personalisation goals. The platform will leverage Snowflake as its core data warehouse, likely supported by a range of other products and services. The programme of work will involve consolidation of a range of existing data platforms through migration activities, as well as identifying and processing new datasets to fuel new data products. \n\n        \nThe programme will likely involve several phases. In first instance, the contract will focus on Phase One, covering delivery items related to the Data hub and Data deliverables. Future phases, that are in scope, will be subject to variations throughout the contract term, as and when required as the programme progresses and subject to budget approval.  \n\n        \nPhase One: \nThe initial phase will be to design the new data warehouse environment, then migrate and refactor the existing corporate data warehouse. It will involve discovery and analysis around the data sets, privacy considerations, etc. of the data held in the existing Microsoft SQL Server environment. These datasets and their data pipelines will need to be migrated onto the Snowflake environment. Downstream dependencies such as Power BI dashboards will need to be repointed and if necessary, redesigned. Importantly, this will require extensive refactoring. For example, ingestion may move from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF) and the overall architectural pattern will move from ETL to ELT. The migration is therefore not a “lift and shift” migration. However, the scope will be limited to datasets currently processed into the existing CDW.\nIt should be noted that the advertised estimated budget of up to £3.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One budget is up to £850,000.00. Further phases and additional expenditure will be confirmed as the programme progresses and are discretionary,  subject to both budgetary approval and the requirements of the council, therefore not guaranteed to the supplier.",
    "secondStage": {
      "invitationDate": "2025-05-08T00:00:00+01:00"
    },
    "tenderPeriod": {
      "endDate": "2025-05-29T12:00:00+01:00"
    },
    "hasRecurrence": false,
    "reviewDetails": "Precise information on deadline(s) for review procedures:\nIn accordance with Regulation 86 (Notices of decisions to award a contract), Regulation 87 (Standstill Period) and Regulations 91 (Enforcement of duties through the Court) of the Public Contracts Regulations 2015 (as amended).",
    "classification": {
      "id": "72263000",
      "scheme": "CPV",
      "description": "Software implementation services"
    },
    "submissionTerms": {
      "languages": [
        "en"
      ],
      "bidValidityPeriod": {
        "durationInDays": 180
      }
    },
    "submissionMethod": [
      "electronicSubmission",
      "written"
    ],
    "participationFees": [
      {
        "id": "1",
        "type": [
          "document"
        ]
      }
    ],
    "procurementMethod": "selective",
    "mainProcurementCategory": "services",
    "submissionMethodDetails": "https://wcc.ukp.app.jaggaer.com",
    "procurementMethodDetails": "Restricted procedure"
  },
  "parties": [
    {
      "id": "GB-FTS-5427",
      "name": "Westminster City Council",
      "roles": [
        "buyer"
      ],
      "address": {
        "region": "UKI",
        "locality": "London",
        "postalCode": "SW1E 6QP",
        "countryName": "United Kingdom",
        "streetAddress": "64 Victoria Street"
      },
      "details": {
        "url": "https://wcc.ukp.app.jaggaer.com",
        "buyerProfile": "http://www.westminster.gov.uk",
        "classifications": [
          {
            "id": "REGIONAL_AUTHORITY",
            "scheme": "TED_CA_TYPE",
            "description": "Regional or local authority"
          },
          {
            "id": "01",
            "scheme": "COFOG",
            "description": "General public services"
          }
        ]
      },
      "identifier": {
        "legalName": "Westminster City Council"
      },
      "contactPoint": {
        "url": "https://wcc.ukp.app.jaggaer.com",
        "name": "Jade Peek",
        "email": "jpeek@westminster.gov.uk"
      }
    },
    {
      "id": "GB-FTS-5080",
      "name": "The High Court of Justice",
      "roles": [
        "reviewBody"
      ],
      "address": {
        "locality": "London",
        "postalCode": "WC2A 2LL",
        "countryName": "United Kingdom",
        "streetAddress": "The Royal Court of Justice, The Strand"
      },
      "identifier": {
        "legalName": "The High Court of Justice"
      }
    }
  ],
  "language": "en",
  "description": "This opportunity is being procured via the Crown Commercial Service Spark DPS (RM6094).  Therefore to be able to submit a tender, you must be registered as a supplier on the DPS. Please note that this can take up to 15 days;\n* Please register on the DPS by following the below link by 5pm (UK time) on Friday 11th April 2025. https://supplierregistration.cabinetoffice.gov.uk/organisation/register\n* Register on Westminster City Council's eProcurement system Jaggaer https://wcc.ukp.app.jaggaer.com\n* Westminster City Council will pull a shortlist on Wednesday 7th May based on the Spark DPS registered suppliers. Please note that it is the Supplier's responsibility to ensure that they are registered on the DPS and showing live prior to this date.\n* All shortlisted suppliers will be added to the opportunity and able to view and submit a bid.\nThis opportunity and all associated procurement documents will be accessible to all shortlisted suppliers via our City of Westminster Procurement and Contracts portal (\"the Portal\"), kindly visit https://wcc.ukp.app.jaggaer.com and search for the following reference: ITT_30323. If you have any questions, please submit these through the portal.\nOur portal is free to register on.\nTo view details of the Opportunity via the Portal please click the following link and click on Opportunities: https://wcc.ukp.app.jaggaer.com\nOr browse as follows:\n- Connect to https://wcc.ukp.app.jaggaer.com\n- Enter your Username and Password\n- Go to Published Opportunities\n- Click on the Project Title to view details",
  "initiationType": "tender"
}