RED OLIVE TRADING LIMITED

Data Engineering, Data Warehouse Reporting and Data Lake, Data Science, AI and Machine Learning

We design and develop cloud-based AI solutions and data platforms including data lakes and warehouses, using e.g. dimensional modelling and Data Vault. Delivery on all major cloud platforms: Azure, AWS and Google Cloud. High productivity through automation tools and responsive delivery through our Agile-based data science methodology.

Features

• Proven across Microsoft Azure, Google Cloud and Amazon Web Services
• Data automation skills in WhereScape, Matillion and DBT.
• Cloud data architecture definition by experienced consultants with relevant certifications
• Design and creation of cloud platforms for prototyping or production
• Design and build of Data Science and Gen AI solutions
• **For data advisory services, see our separate service listing**
• **For data visualisation services, see our separate service listing**
• Data Warehouse Reporting for all sectors including Housing

Benefits

• Long established, proven specialist data consultancy accredited in multiple technologies.
• Red Olive's automated estimating tools enable reliable planning.
• Our industry data models empower good decisions quicker.
• We design data quality in, improving customer understanding and service.
• Our automated data-specific tools slash testing time and effort.
• We offer master data management quickstart and maturation.
• We ensure compliance through visual data lineage and provenance.
• Skills include Google Cloud, Microsoft Azure and WhereScape.
• UK-headquartered, Red Olive delivers data systems that businesses love.
• Deep understanding of customer's challenges to tackle real world problems

£600 to £1,500 a unit a day

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at jefferson.lynch@red-olive.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

152091873362884

Contact

Jefferson Lynch
+447860353027
jefferson.lynch@red-olive.co.uk

Planning

• Planning service: Yes
• How the planning service works: We collaborate on a discovery engagement to define the scope of the work. We apply our automated estimated tools developed from many years of successful projects. These enable the comparison of effort and timing across different cloud platforms. ; We use a business matrix to enable the selection and sequencing of work based on business audience and priority of benefit, ensuring control is maintained throughout the project.; The output is a timed, sequenced plan, with estimates for each main activity and dependencies identified.
• Planning service works with specific services: No

Training

• Training service provided: Yes
• How the training service works: We can provide training for end-users, plus your data and reporting teams on the systems that we implement and a wide range of data matters: ; 1) We offer interactive, small-group training with a live trainer in the principles of data warehouse design. This does not require any specific software, will help you ensure your data model meets the needs of your business users and that it makes sense to them, so they will willingly use it and it will provide benefit. ; 2) We provide hands-on training such as database skills for data teams, training in the use of specific ETL tools such as WhereScape and reporting tools such as Microsoft Power BI. ; 3) We also provide training organisation-wide on how to ensure data privacy compliance while maximising use of your organisation's data. ; 4) We also define target operating models, and this often means we carry out a training needs analysis to identify the skills gaps you face in each future role. We advise what training is need by role, consolidated across all roles, and propose a training plan. We are clear with you which training we will deliver ourselves and how to cover any we are unable to provide.
• Training is tied to specific services: No

Setup and migration

• Setup or migration service available: Yes
• How the setup or migration service works: Whether this is a straight migration or you want to redesign your data systems during the move to cloud is determined during planning. ; Based on the requirement we define a target cloud data architecture including automated processes to ensure ongoing data quality. We are happy to use your preferred platform and we can also bring our own accelerated migration tool, ROSIE. ; ROSIE decreases the time and effort taken to migrate to cloud and has the additional benefit of avoiding the need to learn new programming languages for cloud data management. ROSIE enables your existing staff to migrate to cloud working based on their existing skills in SQL and so this greatly increases your ability to benefit from you existing, internal staff on the migration team. This greatly reduces the overall time taken and the cost to migrate. ; ; ROSIE DQ is an additional module that enables quicker identification of data quality problems and enables easier fixing. Ongoing, once live on the cloud, ROSIE can be used as the basis of your new cloud-based data warehouse, greatly reducing the learning curve for your staff. Because there is no proprietary code, ROSIE also makes any future cloud to cloud migration much simpler.
• Setup or migration service is for specific cloud services: No

Quality assurance and performance testing

• Quality assurance and performance testing service: Yes
• How the quality assurance and performance testing works: Red Olive's standard methodology for data systems includes unit and integration testing by Red Olive, and user acceptance testing by the client and supported by us. ; In addition, Red Olive can provide ROSIE Test, an additional module to accompany ROSIE. ROSIE Test follows a defined testing framework, specifically designed for testing data systems. ; Benefits of ROSIE Test include: ; The testing process and results are made visible and auditable and are written to a structured database.; Execution of testing is around twice as fast as hand-written testing. ; ROSIE Test leads to less reliance on any single person, this helps ensure testing is comprehensive and makes it easier to identify the source of a problem.; Additional models can be provided such as ROSIE Data Quality.

Security testing

• Security services: No

Ongoing support

• Ongoing support service: Yes
• Types of service supported: Hosting or software provided by your organisation
• How the support service works: We can provide a range of options for ongoing UK based support including: ; 1) "Break-fix" support for cloud data warehouses, lakes, and reports. ; 2) Scheduled support blocks to enable access to a wide range of skills as needed for changes and enhancement requiring up to a few days of work. Larger pieces of work are usually handled as consulting engagements or projects. ; 3) Full hosting of many cloud solutions, including the creation of new cloud environments for e.g. prototyping and experimentation.

Service scope

• Service constraints: No generic constraints

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: If we enter into a support agreement with you, we offer a number levels of ongoing paid support which are agreed with individual clients.
• User can manage status and priority of support tickets: No
• Phone support: Yes
• Phone support availability: 9 to 5 (UK time), Monday to Friday
• Web chat support: No
• Support levels: We can provide a range of options for ongoing UK based support including: 1) "Break-fix" support for cloud data warehouses, lakes, and reports. 2) Scheduled support blocks to enable access to a wide range of skills as needed for changes and enhancement requiring up to a few days of work. Larger pieces of work are usually handled as consulting engagements or projects. 3) Full hosting of many cloud solutions, including the creation of new cloud environments for e.g. prototyping and experimentation.

Resellers

• Supplier type: Reseller providing extra features and support
• Organisation whose services are being resold: WhereScape, Exasol, Google Cloud Platform, some Microsoft

Staff security

• Staff security clearance: Staff screening not performed
• Government security clearance: None

Standards and certifications

• ISO/IEC 27001 certification: No
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: Yes
• Cyber essentials plus: No
• Other security certifications: No

Social Value

• Social Value:

  Social Value

  • Fighting climate change
  • Equal opportunity

  Fighting climate change

  Red Olive is committed to doing its part to help fight climate change. We have become a fully remote business, since 2021, which has hugely reduced the need to commute, either by car, or public transport. We support the use of Teams or Zoom meetings wherever possible and only travel for meetings where necessary. As an organisation we have reduced our CO2 emissions considerably over the last 3+ years.

  Equal opportunity

  Red Olive is an equal opportunities employer. We are committed to hiring and treating all employees equally.

Pricing

• Price: £600 to £1,500 a unit a day
• Discount for educational organisations: No

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

Request an accessible format

If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at jefferson.lynch@red-olive.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.