London Fire Brigade

Data Modeller

Incomplete applications

15
Incomplete applications
13 SME, 2 large

Completed applications

41
Completed applications
38 SME, 3 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Friday 5 July 2019
Deadline for asking questions Tuesday 9 July 2019 at 11:59pm GMT
Closing date for applications Friday 12 July 2019 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Data engineer
Summary of the work Experienced Data Modeller, Knowledge of Data modelling, Data warehousing, Data Stories from whiteboard to star schema. Experienced in collaborative techniques of working with stakeholders to gather business requirements and translate them into conceptual and logical data models.
Latest start date Monday 2 September 2019
Expected contract length 1 year
Location London
Organisation the work is for London Fire Brigade
Maximum day rate 700-1000.00

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement Lack of expertise through generic recruitment suppliers.
Who the specialist will work with You will be the sole Data Modeller on the project team you will be experienced in collaborative techniques of working with stakeholders so as to gather business requirements and translate them into conceptual and logical data models. Reporting to the Project Manager you will work alongside the ETL developer, reporting team and data owners to ensure all confirmed dimensions are identified, documented and created.
What the specialist will work on Study on the current data across the brigade.
Writing Data Stories including data warehousing analytic end to end architecture. Conformed dimensions. Transfer business models into conceptual & logical data models. Data models meet appropriate standards & documented, communicated, updated & centrally managed. Collaborative stakeholder management. Agile Methodology & BEAM.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place Southwark , lONDON
Working arrangements Must be based in London.
Security clearance N/A

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
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.

Skills and experience
Opportunity attribute name Opportunity attribute value
Essential skills and experience
  • Data warehousing and dimensional data modelling experience
  • Agile methodology, such as BEAM
  • White board to star schema – full breadth of data modelling process
  • Be able to translate business requirements into conceptual and logical data models
  • Knowledge of how to identify and create conformed dimensions
  • Collaborative techniques of working with stakeholders to write Data stories.
  • Extensive experience of translating requirements into facts and dimensions with appropriate accompanying documentation (i.e. data dictionary)
  • Located in London
  • Can start within 3-4 weeks.
Nice-to-have skills and experience
  • Public sector
  • 10+ years experience

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 15
Cultural fit criteria
  • How solves problems
  • How specialist works with others
  • How takes responsibility for their work
  • Can work with clients with low technical expertise
Assessment methods
  • Work history
  • Reference
  • Interview
Evaluation weighting

Technical competence

60%

Cultural fit

20%

Price

20%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Is the role Outside of IR35? We are looking for a service to be offered and Business to Business offering with an outcome.
2. Is there an incumbent? No.
3. Latest start date states 2nd September, yet one of the essential skills states: 'Can start within 3-4 weeks' CV's of candidates sent must be able to start within 3-4 weeks from interview dates of around mid to late July, therefore no later than September 2nd. Candidates must be able to start by September 2nd.
4. If a specialist is based in say Kent/Surrey for example and can easily commute in to Central London, is this acceptable? Yes we are considering all surrounding areas with good train links as long as journey time is under 1.5 hours.
5. You've stated the latest start date as the 2nd September, but in the essential's "can start within 3-4 weeks." Please could you clarify when you expect the successful candidate to start the contract? Start at least by September 2nd (which will be around 3-4 weeks from interview stage)
6. Is there a current incumbent? No.
7. Please can you confirm if there is an incumbent? No.
8. Please can you confirm if the role is outside IR35? This is a service with an outcome and so will not be inside IR35
9. Is the role Outside IR35? Correction this role is outside IR35 as it is deemed as a service offering .
10. At what point please should candidate CV's be supplied – with this application or upon short listing? 11:59 Friday 12th July
11. At what point please should candidate CV's be supplied – with this application or upon short listing? CV's must be supplied by this Friday the 12th of July by 11:59pm
12. Is there any possibility of remote working once the service has been established? This will be discussed upon special circumstances, when we shortlist.
13. People have asked when CVs should be supplied. It was my understanding on the DOS framework that they are sent (by request of the client) on successful selection at interview stage. Can you please confirm? Yes, these are to be submitted upon shortlisting. Please note this is a correction on submitting by the 12th.
14. Is there option for remote working? This will be decided upon commencement of work.