Her Majesty's Passport Office

Data Migration Specialist- 1

Incomplete applications

6
Incomplete applications
4 SME, 2 large

Completed applications

7
Completed applications
5 SME, 2 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Monday 31 July 2017
Deadline for asking questions Wednesday 2 August 2017 at 11:59pm GMT
Closing date for applications Monday 7 August 2017 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Developer
Summary of the work Specialist required to work in the data migration team to identify source data requirements, assess data quality, map and specify the required transformations from the source to the target data, validate and perform trial data migration in production, cleanse data, and conduct a post implementation review of the data migration.
Latest start date Thursday 31 August 2017
Expected contract length Up to 2 years
Location London
Organisation the work is for Her Majesty's Passport Office
Maximum day rate

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement N/A
Who the specialist will work with Specialist will be part of data architecture team working closely with the Enterprise Data Architect. Specialist will be required to work with multiple development teams and existing vendor to understand legacy and new data structures.
What the specialist will work on Specialist will work on developing the Data Migration scripts, performing trial migrations and executing migration scripts, to migrate the data from legacy to new data stores.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place Westminster,Victoria, Fleet Street.
Working arrangements We expect the specialist to work collaboratively with existing in house project teams that are transforming the HMPO business processes/applications.
Work is based in London and will involve the supplier being on site 5 days per week to work collaboratively with HMPO teams; travel and expenses remains the responsibility of the supplier.
Service design and development must align with the HM Passport Office strategic technical architecture and technologies.
Security clearance DV (Developed Vetting) clearance is required.

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions Breakpoints to assess progress and quality will be set at the end of alpha phase.

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
  • Have demonstrable experience of successfully designing and implementing data migration, data transformation, data quality, modelling, testing and post production reviews.
  • Have demonstrable experience of mapping source and target data models, identify gaps, data cleansing, schema modelling (Relational/XML/JSON).
  • Have demonstrable experience of successfully delivering digital solutions that collect and manage personal and/or sensitive information with appropriate controls and protection.
  • Have demonstrable hands-on experience of Kafka, Big Data, Hadoop, HBase, Map Reduce, Storm, Java, JMS.
Nice-to-have skills and experience
  • Have demonstrable experience of successfully and collaboratively working, coaching and sharing knowledge with Public Sector client teams, particularly those with limited agile development experience.
  • Have demonstrable experience of successfully design, implementation and migration of relational databases to Big data based data stores utilising Amazon AWS.
  • Have demonstrable experience of Her Majesty's Passport Office business processes and data stores.
  • Have demonstrable hands-on experience using SQL, Oracle, ETL, AQ, Apache Nifi, HDF, SAM.
  • Have exisiting, valid DV Clearance

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 3
Cultural fit criteria
  • Be transparent and collaborative when making decisions.
  • Take responsibility for their work.
  • Can work with clients with low technical expertise.
  • Able to work within HMPO design, delivery and governance framework.
Assessment methods
  • Work history
  • Interview
Evaluation weighting

Technical competence

60%

Cultural fit

15%

Price

25%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Please could you confirm the IR35 status & Max rate for this role We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
The maximum day rate has been left blank intentionally, we will assess the day rate for suppliers using the evaluation weighting we have disclosed on the requirements
2. Does this fall inside or outside of the IR35 legislation? We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
3. Would you consider a candidate with current SC clearance who is willing to go through DV clearance process? Yes however, current DV clearance is preferred but HMPO will support the process for successful candidate
4. Is the rate inclusive or exclusive of VAT? The day rate is exclusive of VAT
5. Is there any travel involved in this role and will the travel expenses be paid? There may be travel involved to different regional sites in the UK and any travel required by the business will be paid.
6. What is the total number for positions open for this role There are two positions both positions are currently live on DOS.
7. Is occasional remote working allowed? No
8. Any specific format(pdf,doc) in which CVs to be sent later CVs can be sent in either PDF or Doc format
9. What are the other expenses which will be paid Other than travel expenses for business needs, other expenses will not be covered.
10. Any chances of change in start date as the latest date mentioned is Thursday 31 August 2017 The latest start date remains the same but will depend on the successful candidates clearance process.
11. Can more than one candidate per supplier be submitted for this role No, the way the digital marketplace is set up, a supplier can only submit one candidate per role.
12. Will this role be within IR35? We expect this engagement to be outside IR35, however status is assessed on a case-by-case basis.
13. What is the lead time for feedback once the application is submitted? The panel will aim to send their shortlisting results by week ending 11h August 2017.
Interviews will take place week commencing 14th August 2017.