Awarded to Baytree IT Services

Start date: Monday 30 October 2017
Value: £38,160
Company size: SME
Independent Parliamentary Standards Authority (IPSA)

Data Migration SQL Specialist

11 Incomplete applications

10 SME, 1 large

20 Completed applications

17 SME, 3 large

Important dates

Published
Tuesday 3 October 2017
Deadline for asking questions
Tuesday 10 October 2017 at 11:59pm GMT
Closing date for applications
Tuesday 17 October 2017 at 11:59pm GMT

Overview

Specialist role
Developer
Summary of the work
IPSA are implementing an integrated ERP solution to replace a variety of corporate systems. We are seeking a SQL data migration specialist to design and develop scripts that will extract data from existing systems and transform it to match the target schema.
Latest start date
Monday 30 October 2017
Expected contract length
3 Months (60 days)
Location
London
Organisation the work is for
Independent Parliamentary Standards Authority (IPSA)
Maximum day rate
Up to £650 per day for an exceptional candidate

About the work

Early market engagement
Who the specialist will work with
The developer will work closely with a technical lead that will provide the business requirements for the data migration and integration work. Some interaction with technical as-is/to-be system supplier staff may be required as well as liaison with internal technical and business stakeholders.
What the specialist will work on
1.) Data migration technical requirements analysis
2.) Define Extract, Transform and Load (ETL) technical approach
3.) Iterative development and testing of SQL based ETL scripts
4.) Running scripts in live data migration environments
5.) Technical post-migration reconciliation testing
6.) Additional ad hoc SQL scripting as needed (e.g. to identify and correct data quality issues, support integration requirements etc.)
7.) Liaison with technical and business stakeholders

Work setup

Address where the work will take place
The IPSA,
4th Floor,
30 Millbank,
London,
SW1P 4DU
Working arrangements
Successful candidate will be available to work onsite full time. No expenses can be provided.
Security clearance
CTC minimum held at the time of application.

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
  • Extensive MS SQL development experience
  • Extensive experience designing and developing ETL solutions for data migration
  • Experience producing detailed technical designs from higher-level business requirements
  • Database administration (DBA) experience in SQL Server
Nice-to-have skills and experience
Experience working with the UNIT4 Business World On! ERP solution (formerly Agresso)

How suppliers will be evaluated

How many specialists to evaluate
3
Cultural fit criteria
  • Experience working directly with both business and technical stakeholders
  • Ability to clearly articulate technical concepts for non-technical audiences
  • A pragmatic approach to problem solving and delivery
  • Experience working in a multi-vendor landscape
Assessment methods
  • Work history
  • Reference
  • Interview
Evaluation weighting

Technical competence

70%

Cultural fit

10%

Price

20%

Questions asked by suppliers

1. Does this position fall inside or outside of IR35?
This position falls outside of IR35 legislation provided the supplier is a limited company.
2. 1. Regarding the CTC clearance status, if the candidate does not hold active CTC clearance and is willing to go through the process, can this be considered, if yes will you sponsor the security clearance.
2. What is the lead time for feedback once the application is submitted? 3. Any chances of change in start date as the latest date mentioned is 30th Oct 2017
4. What are the other expenses which will be paid?
5. What are the exact work locations?
6. Any specific format(pdf,doc) in which CVs to be sent later?
7. Is occasional remote working allowed?
1. CTC clearance must be held at the time of application
2. Feedback will be provided on or before the 25th October
3. We are prepared to consider a slightly later start date for an exceptional candidate
4. No expenses will be paid
5. The IPSA, 4th Floor, 30 Millbank, London, SW1P 4DU
6. PDF
7. The role is full time onsite
3. 1.Is there any travel involved in this role and will the travel expenses be paid ? 2. Is the rate inclusive or exclusive of VAT? 3.Would you consider work permit holders (e.g. Tier 2 General Visa) and EU passport holders for this role ?
1. The role is based full time out of IPSA's London office. No travel to other sites is involved. No expenses will be paid..
2. The maximum date rate is exclusive of VAT.
3. Suppliers must have the right to work in the UK for the 60 day period specified, IPSA does not have a licence to sponsor Tier 2 General Visa applicants. Please note CTC clearance must also be held at the time of application.