850000.00

{
  "buyer": {
    "id": "GB-FTS-5427",
    "name": "Westminster City Council"
  },
  "date": "2025-04-08T10:56:59+01:00",
  "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\u0027s 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\u0027s 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",
  "id": "013577-2025",
  "initiationType": "tender",
  "language": "en",
  "ocid": "ocds-h6vhtk-04fe91",
  "parties": [
    {
      "address": {
        "countryName": "United Kingdom",
        "locality": "London",
        "postalCode": "SW1E 6QP",
        "region": "UKI",
        "streetAddress": "64 Victoria Street"
      },
      "contactPoint": {
        "email": "jpeek@westminster.gov.uk",
        "name": "Jade Peek",
        "url": "https://wcc.ukp.app.jaggaer.com"
      },
      "details": {
        "buyerProfile": "http://www.westminster.gov.uk",
        "classifications": [
          {
            "description": "Regional or local authority",
            "id": "REGIONAL_AUTHORITY",
            "scheme": "TED_CA_TYPE"
          },
          {
            "description": "General public services",
            "id": "01",
            "scheme": "COFOG"
          }
        ],
        "url": "https://wcc.ukp.app.jaggaer.com"
      },
      "id": "GB-FTS-5427",
      "identifier": {
        "legalName": "Westminster City Council"
      },
      "name": "Westminster City Council",
      "roles": [
        "buyer"
      ]
    },
    {
      "address": {
        "countryName": "United Kingdom",
        "locality": "London",
        "postalCode": "WC2A 2LL",
        "streetAddress": "The Royal Court of Justice, The Strand"
      },
      "id": "GB-FTS-5080",
      "identifier": {
        "legalName": "The High Court of Justice"
      },
      "name": "The High Court of Justice",
      "roles": [
        "reviewBody"
      ]
    }
  ],
  "tag": [
    "tender"
  ],
  "tender": {
    "classification": {
      "description": "Software implementation services",
      "id": "72263000",
      "scheme": "CPV"
    },
    "coveredBy": [
      "GPA"
    ],
    "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\u0027s 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\u0027s 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 \u201clift and shift\u201d 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 \u00a33.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One budget is up to \u00a3850,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.",
    "hasRecurrence": false,
    "id": "ocds-h6vhtk-04fe91",
    "items": [
      {
        "deliveryAddresses": [
          {
            "region": "UK"
          }
        ],
        "id": "1",
        "relatedLot": "1"
      }
    ],
    "legalBasis": {
      "id": "32014L0024",
      "scheme": "CELEX"
    },
    "lots": [
      {
        "contractPeriod": {
          "endDate": "2028-08-17T23:59:59+01:00",
          "startDate": "2025-08-18T00:00:00+01:00"
        },
        "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\u0027s 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\u0027s 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 \u201clift and shift\u201d 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 \u00a33.87million represents the full potential project and is subject to further budgetary approval. The initial Phase One budget is up to \u00a3850,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.",
        "hasOptions": false,
        "hasRenewal": true,
        "id": "1",
        "renewal": {
          "description": "The initial Phase One budget is up to \u00a3850,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."
        },
        "status": "active",
        "submissionTerms": {
          "variantPolicy": "notAllowed"
        },
        "value": {
          "amount": 3870000.0,
          "currency": "GBP"
        }
      }
    ],
    "mainProcurementCategory": "services",
    "participationFees": [
      {
        "id": "1",
        "type": [
          "document"
        ]
      }
    ],
    "procurementMethod": "selective",
    "procurementMethodDetails": "Restricted procedure",
    "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).",
    "secondStage": {
      "invitationDate": "2025-05-08T00:00:00+01:00"
    },
    "status": "active",
    "submissionMethod": [
      "electronicSubmission",
      "written"
    ],
    "submissionMethodDetails": "https://wcc.ukp.app.jaggaer.com",
    "submissionTerms": {
      "bidValidityPeriod": {
        "durationInDays": 180
      },
      "languages": [
        "en"
      ]
    },
    "techniques": {
      "hasDynamicPurchasingSystem": true
    },
    "tenderPeriod": {
      "endDate": "2025-05-29T12:00:00+01:00"
    },
    "title": "850000.00",
    "value": {
      "amount": 3870000.0,
      "currency": "GBP"
    }
  }
}