Awarded to Aventius

Start date: Monday 2 March 2020
Value: £80,000
Company size: SME
Salford Royal NHS Foundation Trust, Stott Lane, Salford, M6 8HD

BI Azure Consultancy

14 Incomplete applications

11 SME, 3 large

19 Completed applications

19 SME, 0 large

Important dates

Published
Tuesday 11 February 2020
Deadline for asking questions
Thursday 13 February 2020 at 11:59pm GMT
Closing date for applications
Tuesday 18 February 2020 at 11:59pm GMT

Overview

Specialist role
Business analyst
Summary of the work
The work will cover but not limited to: -
- Support the design of Azure Data Platform Architecture to minimise ongoing revenue costs
- Support the implementation of the new Azure Data Platform to defined policy and design
- Supporting the above implementation through any required app development
Latest start date
Monday 2 March 2020
Expected contract length
Up to 2 years
Location
North West England
Organisation the work is for
Salford Royal NHS Foundation Trust, Stott Lane, Salford, M6 8HD
Maximum day rate
£400 per 7.5 hour day (Including Travel and Subsistence)

About the work

Early market engagement
Who the specialist will work with
Consisters of 14 members of technical staff at varying levels of skill and seniority
What the specialist will work on
Current Business Intelligence data platform is based on old technology which doesn’t facilitate the consumption and processing of big data.
The work will cover but not limited to
- Support the design of Azure Data Platform Architecture to minimise ongoing revenue costs
- Support the implementation of the new Azure Data Platform to defined policy and design
- Supporting the above implementation through any required app development

Work setup

Address where the work will take place
Salford Royal NHS Foundation Trust
Turnpike House (and Remotely)
631 Eccles New Road,
Salford, Greater Manchester,
M50 1SW
Working arrangements
Working arrangements to be confirmed
Security clearance
N/A

Additional information

Additional terms and conditions

Skills and experience

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Essential skills and experience
  • Comprehensive understand of the Azure platform is required to ensure minimisation of on-going revenue costs
  • High and low level architectural design of a modern data platform
  • Working knowledge of networking and infrastructure to support discussions with supporting Digital functions
  • Broader experience \ knowledge of Microsoft Power Platform
  • Competency in the development of PowerShell and general business application development
  • Experience of full software development life cycle in the context of data warehousing
  • Knowledge of Continues Deployment and Continuous Integration in the context of data warehousing
Nice-to-have skills and experience

How suppliers will be evaluated

All suppliers will be asked to provide a work history.

How many specialists to evaluate
3
Cultural fit criteria
  • Proven experience in last 3-years of an open/collaborative working relationship at all levels with excellent communication and co-ordination skills when conducting daily stand-ups, team meetings, presentation and demonstrations
  • Forward looking organisation with continual development to keep up with changing ICT landscape
  • Has a no-blame culture and encourages people to learn from their mistakes, working as
  • Suppliers must demonstrate an ability and willingness to work collaboratively within a multi-vendor delivery environment
  • Able to communicate effectively with users, technical architects and solve issues with complex integrations
Additional assessment methods
Evaluation weighting

Technical competence

40%

Cultural fit

20%

Price

40%

Questions asked by suppliers

1. Q1. Is the role Inside or Outside IR35?
A1. The role is outside of IR35
2. Q2. Is there a current incumbent? Do you have a person/consultancy already in mind for this role?
A2. We do have fixed term resources supporting various programmes of work.
This is an open tender and all submissions will be reviewed on their merit
3. Q3. Is the day rate of £400 exclusive of agency rate or is it an all in price?
A3. It is an 'all in' price
4. Q4. What will be the minimum length for the contract please?
Our specialist's interest lies on the basis that this will be a 2 year role for certain.
A4. The contract is for 24 months. The resource demand over the period will fluctuate dependant on demand but will not exceed 1 person at any given time.
5. Q5. Does the specialist need NHS experience?
A5. Does not need NHS Experience but it is desirable
6. Q6. Is there an incumbent supplier providing this specific resource currently?
A6. Yes, the Trust has a supplier providing BI Azure Consultancy on a short term basis
7. Q7. Is remote working an option?
A7. Remote working is possible but there is also be a requirement to be on site.
8. Q8. In response to Q6, you have stated "Yes, the Trust has a supplier providing BI Azure Consultancy on a short term basis". Could you clarify what you mean by this? E.g. Are they short term and expecting to be replaced by the winning supplier here or are they likely to also be bidding for the work too?
A8. The current supplier’s contract ends on the 28th February. We are not aware of the current suppliers intent to bid for the work.
9. Q9. Is it possible to share the current data platform architecture, tools and technologies being used currently?
A9. The current platform is a standard on-premise datawarehouse SQL Stack architecture. Using a combination of SSIS and stored procedure to process data
10. Q10. "...Azure platform is required to ensure minimisation of on-going revenue costs". Does this refer to whole Azure cost like VM, Storage etc. or just BI/Data-Platform specific?
A10. Just BI/Data Platform specific. There may be the requirement to use VM’s for certain services but this will be determined with the detailed design