Award of Business Intelligence Engineers x3

{
    "tag": [
        "compiled"
    ],
    "id": "ocds-r6ebe6-0000758003-2024-09-25T12:14:25Z",
    "date": "2024-09-25T12:14:25Z",
    "ocid": "ocds-r6ebe6-0000758003",
    "initiationType": "tender",
    "parties": [
        {
            "id": "org-1",
            "name": "Forestry and Land Scotland",
            "address": {
                "streetAddress": "Great Glen House",
                "locality": "Inverness",
                "postalCode": "IV3 8NW"
            },
            "contactPoint": {
                "name": "Business Support",
                "telephone": "+44 3000676000",
                "url": "http://https://forestryandland.gov.scot"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "org-2",
            "name": "Artscape Gardens",
            "address": {
                "streetAddress": "23 Glenvilla Cirle",
                "locality": "Paisley",
                "postalCode": "PA2 8TS"
            },
            "contactPoint": {
                "name": "Arthur Marsh"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-3",
            "name": "Perth & Kinross Council",
            "address": {
                "streetAddress": "35 Kinnoull Street",
                "locality": "Perth",
                "postalCode": "PH1 5GD"
            },
            "contactPoint": {
                "name": "Community Greenspace",
                "email": "dhammett@pkc.gov.uk",
                "telephone": "01738476000",
                "url": "http://www.pkc.gov.uk"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "org-4",
            "name": "Perth and Kinross Countryside Trust",
            "address": {
                "streetAddress": "35 Kinnoull Street",
                "locality": "Perth",
                "postalCode": "PH1 5GD"
            },
            "contactPoint": {
                "name": "Bid Strachan"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-5",
            "name": "Clyde Gateway URC",
            "address": {
                "streetAddress": "The Olympia Building",
                "locality": "Glasgow",
                "postalCode": "G40 2QH"
            },
            "contactPoint": {
                "name": "Development",
                "email": "rowan.carmichael@clydegateway.com",
                "telephone": "0788 078 6500",
                "url": "http://www.clydegateway.com"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "org-6",
            "name": "LDA Design Consulting Ltd",
            "address": {
                "streetAddress": "17 Minster Precincts",
                "locality": "Peterborough",
                "postalCode": "PE1 1XX"
            },
            "contactPoint": {
                "name": "Anne South"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-7",
            "name": "GTR Contracts Ltd",
            "address": {
                "streetAddress": "Terraughtie Farm",
                "locality": "Dumfries",
                "postalCode": "DG2 8PT"
            },
            "contactPoint": {
                "name": "Tanya Russell"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-8",
            "name": "Borders General Hospital",
            "address": {
                "streetAddress": "Borders General Hospital",
                "locality": "MELROSE",
                "postalCode": "TD6 9BS"
            },
            "contactPoint": {
                "name": "Procurement",
                "email": "shona.milne@borders.scot.nhs.uk",
                "telephone": "01896826182",
                "url": "http://www.nhsborders.org.uk/"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "org-9",
            "name": "Shred Station",
            "address": {
                "streetAddress": "Osborne House, Wendover Road",
                "locality": "Norwich",
                "postalCode": "NR13 6LH"
            },
            "contactPoint": {
                "name": "Chris Pearson"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-10",
            "name": "Scottish Government",
            "address": {
                "streetAddress": "4 Atlantic Quay",
                "locality": "Glasgow",
                "postalCode": "G2 8EA"
            },
            "contactPoint": {
                "name": "Corporate Transformation",
                "telephone": "+44 1412420133",
                "url": "http://www.scotland.gov.uk"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "org-11",
            "name": "ASA Recruitment (Quick Quotes)",
            "address": {
                "streetAddress": "6 Coates Crescent",
                "locality": "Edinburgh",
                "postalCode": "EH3 7AL"
            },
            "contactPoint": {
                "name": "Gary Burns"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-12",
            "name": "Harvey Nash Limited",
            "address": {
                "streetAddress": "Waverley Gate",
                "locality": "Edinburgh",
                "postalCode": "EH1 3EG"
            },
            "contactPoint": {
                "name": "Graeme McNaull"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-13",
            "name": "NHS Ayrshire & Arran",
            "address": {
                "streetAddress": "Eglinton House, Ailsa Hospital",
                "locality": "Ayr",
                "postalCode": "KA6 6AB"
            },
            "contactPoint": {
                "name": "Capital Planning",
                "telephone": "+44 1294323219",
                "url": "http://www.nhsaaa.net"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "org-14",
            "name": "Central Demolition Ltd",
            "address": {
                "streetAddress": "Central House, Chattan Industrial Estate",
                "locality": "Bonnybridge",
                "postalCode": "FK4 2AG"
            },
            "contactPoint": {
                "name": "Scott Cochran"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-15",
            "name": "Sight and Sound Technology",
            "address": {
                "streetAddress": "Welton House, North Wing",
                "locality": "Northampton",
                "postalCode": "NN3 6WD"
            },
            "contactPoint": {
                "name": "Glenn Tookey"
            },
            "roles": [
                "supplier"
            ]
        },
        {
            "id": "org-16",
            "name": "Lorien Resourcing Ltd",
            "address": {
                "streetAddress": "Randolph House",
                "locality": "Edinburgh",
                "postalCode": "EH2 4QZ"
            },
            "contactPoint": {
                "name": "Ria Newham"
            },
            "roles": [
                "supplier"
            ]
        }
    ],
    "buyer": {
        "name": "Scottish Government",
        "id": "org-10"
    },
    "tender": {
        "id": "tender-778908",
        "title": "Award of Business Intelligence Engineers x3",
        "description": "The Scottish Government is progressing with a flagship change programme to improve the performance and efficiency of how corporate shared services are provided to core Scottish Government and other public bodies in Scotland.With significant multi-year investment in technology planned, the corporate shared services programme will deploy the solutions and platforms required to enable operational and cultural change to meet user needs and provide a better customer experience. It has been agreed that the scope of phase one will be to improve the current shared service capability in Finance and HR. This will then provide a foundation for further growth to support the government's wider vision for shared services and the ability to be a data driven organisation.This role is based in the newly formed Corporate Transformation Directorate. The corporate shared services programme is the initial focus of this role but will widen as the portfolio of corporate transformation programmes expands. This is a great opportunity to be involved in the early stages of creating this new organisation.As a Business Intelligence (BI) Engineer on the corporate Shared Services Programme, you will have a key role in helping understand corporate services data and analysing and presenting it in a way that supports the programme.Immediate activity, and for the foreseeable future, will revolve around the development of reporting solutions with Oracle BI Publisher and OTBI. So the post holder needs to be a confident and well experienced BI Engineer with Oracle Fusion Cloud technologies. Functional expertise of Oracle Cloud HCM and ERP is also strongly desired.Aside from report development, the post holder may be asked to carry out data quality and data analysis activities as required by the business needs at the time. Therefore, experience with Excel and Power BI will be advantageous.The post holder is also expected to upskill on-the-job permanent members of staff and as the Data and Analytics function evolves within the directorate. This activity will happen on an ad hoc basis depending on permanent staff needs.This role will sit within a developing Data and Analytics team within the Corporate Transformation Directorate.Main DutiesThe initial focus of work is:* Work to build reports on the Oracle Fusion cloud using OTBI & BI Publisher* Looking at current management information and analytics produced by existing systems for finance and human resources.* Helping prepare data to support BI solutions.* Prepare functional and/or technical specifications for reports built on Oracle Cloud - mainly, HCM and ERP.You will:* Build reports as per business requirements and functional specifications.* Produce relevant specification documents and provide technical advice on reports to non-technical colleagues.* Summarise and present data and conclusions in the most appropriate format for users.* Have good command of Oracle HCM, Oracle ERP (especially Finance modules) to build reports.* Be able to help less experienced permanent members of staff develop their Oracle Cloud report development skills.* Apply tools and techniques for data analysis and data visualisation (including the use of business information tools).* Identify, collect and migrate data to and from a range of systems.* Manage, clean, abstract and aggregate data alongside a range of analytical studies on that data.",
        "mainProcurementCategory": "services",
        "tenderPeriod": {
            "endDate": "2025-03-01T00:00:00Z"
        },
        "additionalClassifications": [
            {
                "id": "72000000",
                "description": "IT services: consulting, software development, Internet and support",
                "scheme": "CPV"
            }
        ]
    },
    "awards": [
        {
            "id": "awd-1",
            "value": {
                "amount": 675,
                "currency": "GBP"
            },
            "suppliers": [
                {
                    "id": "org-12",
                    "name": "Harvey Nash Limited"
                },
                {
                    "id": "org-16",
                    "name": "Lorien Resourcing Ltd"
                }
            ],
            "items": [
                {
                    "id": "awditem-1",
                    "description": "The Scottish Government is progressing with a flagship change programme to improve the performance and efficiency of how corporate shared services are provided to core Scottish Government and other public bodies in Scotland.With significant multi-year investment in technology planned, the corporate shared services programme will deploy the solutions and platforms required to enable operational and cultural change to meet user needs and provide a better customer experience. It has been agreed that the scope of phase one will be to improve the current shared service capability in Finance and HR. This will then provide a foundation for further growth to support the government's wider vision for shared services and the ability to be a data driven organisation.This role is based in the newly formed Corporate Transformation Directorate. The corporate shared services programme is the initial focus of this role but will widen as the portfolio of corporate transformation programmes expands. This is a great opportunity to be involved in the early stages of creating this new organisation.As a Business Intelligence (BI) Engineer on the corporate Shared Services Programme, you will have a key role in helping understand corporate services data and analysing and presenting it in a way that supports the programme.Immediate activity, and for the foreseeable future, will revolve around the development of reporting solutions with Oracle BI Publisher and OTBI. So the post holder needs to be a confident and well experienced BI Engineer with Oracle Fusion Cloud technologies. Functional expertise of Oracle Cloud HCM and ERP is also strongly desired.Aside from report development, the post holder may be asked to carry out data quality and data analysis activities as required by the business needs at the time. Therefore, experience with Excel and Power BI will be advantageous.The post holder is also expected to upskill on-the-job permanent members of staff and as the Data and Analytics function evolves within the directorate. This activity will happen on an ad hoc basis depending on permanent staff needs.This role will sit within a developing Data and Analytics team within the Corporate Transformation Directorate.Main DutiesThe initial focus of work is:* Work to build reports on the Oracle Fusion cloud using OTBI & BI Publisher* Looking at current management information and analytics produced by existing systems for finance and human resources.* Helping prepare data to support BI solutions.* Prepare functional and/or technical specifications for reports built on Oracle Cloud - mainly, HCM and ERP.You will:* Build reports as per business requirements and functional specifications.* Produce relevant specification documents and provide technical advice on reports to non-technical colleagues.* Summarise and present data and conclusions in the most appropriate format for users.* Have good command of Oracle HCM, Oracle ERP (especially Finance modules) to build reports.* Be able to help less experienced permanent members of staff develop their Oracle Cloud report development skills.* Apply tools and techniques for data analysis and data visualisation (including the use of business information tools).* Identify, collect and migrate data to and from a range of systems.* Manage, clean, abstract and aggregate data alongside a range of analytical studies on that data."
                }
            ]
        }
    ],
    "contracts": [
        {
            "id": "awd-1",
            "awardID": "awd-1",
            "status": "active"
        }
    ],
    "relatedProcesses": [
        {
            "id": "1",
            "identifier": "ocds-r6ebe6-0000686586"
        }
    ],
    "bids": {
        "statistics": [
            {
                "id": "1",
                "measure": "bids",
                "value": 3
            }
        ]
    },
    "noticetype": "PCS Notice - Quick Quote Award"
}