Environment Agency

Flood and Coastal Risk Management Conceptual Data Model

13 Incomplete applications

11 SME, 2 large

24 Completed applications

21 SME, 3 large

Published: Tuesday 4 September 2018
Deadline for asking questions: Tuesday 11 September 2018 at 11:59pm GMT
Closing date for applications: Tuesday 18 September 2018 at 11:59pm GMT

Overview

Specialist role: Business analyst
Summary of the work: The brief is to analyse the data structure of Flood and Coastal Risk Management to understand and collate concepts, entities and relationships, and use this to create as-is and to-be Conceptual Data Models.
Latest start date: Monday 3 December 2018
Expected contract length
Location: South West England
Organisation the work is for: Environment Agency
Maximum day rate: Maximum day rate £600 (excludes expenses).

About the work

Early market engagement
Who the specialist will work with: This work will involve engaging with technical leads around the FCRM to understand data concepts, entities and relationships. After the data has been modelled, the key findings will need to be communicated to senior management.

The work will be led by a Senior Advisor in the Environment Agency.
What the specialist will work on: 1. Gather information from appropriate sources to build an as-is, and a to-be picture of the data concepts, entities and relationships in the Flood and Coastal Risk Management (FCRM) directorate
2. Create an as-is Conceptual Data Model (CDM) for FCRM
3. If allowable within time constraints, create a to-be CDM
4. Identify and communicate key findings

Work setup

Address where the work will take place: This will require meetings or calls with Environment Agency (EA) staff and possibly travel to appropriate EA offices. A number of staff are based in Horizon House, Bristol, including the Senior Advisor. The senior managers are based across our EA offices. There may also be a requirement to hold meetings with Defra colleagues. There is no provision for the contractor to work from an EA office on a daily basis. The contractor can work from their normal base.
Working arrangements: The work will involve face to face meetings in Horizon House, Bristol with the Senior Advisor for project start up, updates and closure. Information gathering can be by face to face meeting or phone calls as appropriate. Regular shorter updates can be carried out over the phone.
Security clearance

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: Have understanding and experience of creating Conceptual Data Models

Be able to summarise findings concisely

Be able to manage the project

Communicate effectively

Be able to analyse and parse complex subjects

Be able to extract key information from others
Nice-to-have skills and experience: Facilitate workshops

Summarise findings for non technical audience

How suppliers will be evaluated

How many specialists to evaluate

Cultural fit criteria

Work as a team with our organisation
Be transparent and collaborative when making decisions
Have a no-blame culture and encourage people to learn from their mistakes
Share knowledge and experience with other team members
Challenge the status quo
Be comfortable standing up for their discipline
Operate in an environmentally sustainable manner

Assessment methods

Work history
Reference
Interview

Evaluation weighting

Technical competence

40%

Cultural fit

10%

Price

50%

Questions asked by suppliers

1. What is the IR35 status?: The role is outside IR35.
2. Is there a current incumbent?: No there is not a current incumbent
3. What is the contract length?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
4. Please can you confirm the contract length for the position?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019.
5. Please can you confirm the contract length?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019.
6. Are we right to assume that the individual will be predominantly home based with the need to come to the offices in Bristol for meetings?: The successful applicant can be based at home, or another office but will be required to travel to Environment Agency offices which include Bristol to work with the Senior Advisor running the work. They may also be required to travel to other offices, nationwide, although the most environmentally friendly but effective way of gathering information will be considered. There will be no regular provision of a desk space at Bristol office although hot desking is possible on an ad hoc basis.
7. What is the duration of the contract?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
8. What is the preferred start date?: A start date of mid October would be preferable, with latest start date of 3rd December
9. What is the contract length?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
10. Can the Agency please confirm if their is a current incumbent in this role: There is no current incumbent in the role
11. Can the Agency please confirm the offered day rate include VAT?: The maximum day rate excludes VAT
12. Can the Agency please confirm what is the IR35 status of the requirement.: The role is outside IR35.
13. Kindly confirm the contract length?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
14. Is this role In Scope of IR35?: This role is outside IR35
15. How long is the contract expected to run for?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
16. How long is the contract expected to run for?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
17. Please could you provide further details regarding the contract duration for this opportunity?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
18. Has the contract length been confirmed yet?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
19. What is the length of the contract? Or is it permanent?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
20. You have referred to the specialist working from their base, please can you confirm that this means they can work from their base except to attend meetings with the EA staff?: The successful applicant can be based at home, or another office but will be required to travel to Environment Agency offices which include Bristol to work with the Senior Advisor running the work. They may also be required to travel to other offices, nationwide, although the most environmentally friendly but effective way of gathering information will be considered. There will be no regular provision of a desk space at Bristol office although hot desking is possible on an ad hoc basis.
21. Does the Buyer have a guide to the expected contract length?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019
22. We note the start date of 3rd December. Can you please advise as to the length of the contract as there is a reference to potential time constraints?: We are looking at 50+ days of work over 3 -5 months, to be concluded before the end of March 2019.
23. Will the 50 working days be in a block or spread out over the 3-5 months?: We are flexible on the proposed solution to the requirements, but we expect the working days will spread out over the 3-5 months
24. Is the maximum day rate of £600 inclusive or exclusive of VAT?: The maximum day rate excludes VAT
25. Location of EA offices where the specialist is expected to attend face to face: Horizon House, Deanery Road, Bristol, BS1 5AH is the location where face to face meetings with the senior manager will take place, but there may be the need to travel to other Environment Agency offices
26. The frequency of visits to EA Offices?: This is yet to be determined and will depend on the best proposed solution to the requirements.
27. Can the specialist claim travel expenses from their base location: The specialist can claim expenses
28. Does the Environment Agency has a preferred software tool for this work, and if so, will it be providing entitlement for that usage to the supplier?: There is currently no preferred software tool but there is potential for one to be identified during the work. We will not be providing entitlement for usage of any software.
29. Is any sensitive personal data in scope?: No sensitive personal data will be in scope.
30. Are there any other data or security sensitivities?: No extra data or security sensitivities are anticipated
31. Is the work to be done using Agency infrastructure and if so, will the supplier be provided with remote access to this?: The work will not use Agency infrastructure, and the supplier will not have remote access.
32. Could the Agency define what reimbursable expenses it would regard as in scope: travel, subsistence, accommodation, software or other tools required for the work?: Reasonable travel expenses will be paid when visiting EA offices, e.g. train fares. This will depend where the successful supplier is based and will be by prior agreement only.

Can we store analytics cookies on your device?

Awarded to De Voil Consulting