Office of Rail and Road

ETL Developer

Incomplete applications

Incomplete applications
0 SME, 2 large

Completed applications

Completed applications
5 SME, 0 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Tuesday 20 February 2018
Deadline for asking questions Tuesday 27 February 2018 at 11:59pm GMT
Closing date for applications Tuesday 6 March 2018 at 11:59pm GMT


Opportunity attribute name Opportunity attribute value
Specialist role Developer
Summary of the work 1) To enable loading of three datasets without manual adjustments from the ETL admin (ie no macro, no editing of the source file prior to loading)
2) Mapping of the data is not within scope, but advice on query optimisation will be sought.
Latest start date Friday 30 March 2018
Expected contract length Less than 4 weeks
Location London
Organisation the work is for Office of Rail and Road
Maximum day rate

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement
Who the specialist will work with Specialist will be working with senior BI developer and other members of the BI team as necessary.
What the specialist will work on Build 3 ETL packages for the loading of data from 3 bespoke excel workbooks into a pre-existing data warehouse.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place 1 Kemble Street, London, WC2B 4AN
Working arrangements Working in the ORR's head office in London where a laptop will be supplied for this piece of work. The work will be for between 6-9 days in total.
Security clearance Basic clearance is required.

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
  • Minimum experience of two years’ experience of SQL Server Integration Services, 2008 R2 edition.
  • Minimum of one year familiarity with SQL Server Management Studio; creating new tables via a script for multiple databases
  • Understanding of the role of metadata within the ETL process.
  • Understanding of standard data warehouse design principles including star schema, roles of staging and DW warehouses, look-up transformations.
  • Able to create free-standing ETL packages for transferring 2-3 Excel datasets from multi-tab source to a single DW table.
Nice-to-have skills and experience
  • Advise on query optimisation
  • Understanding of source control, particularly Team Foundation Server

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 5
Cultural fit criteria
  • Work as a team with our organisation and other suppliers
  • Be comfortable standing up for their discipline
  • Can work with clients with low technical expertise
Assessment methods Work history
Evaluation weighting

Technical competence


Cultural fit




Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. What is the exact contract length? 10 working days
2. What is the rate for this role? £450 per day
3. Is there an incumbent in the role? There is no incumbent in post, but there is a BI developer in post who will assist the developer in setting up and will be on hand to answer any questions during the developer being in post.
4. Can the work be done remotely? While remote working is technically possible, operational requirements mean that it would be more far more productive if they work on site.

They will be:
• using an ORR laptop, which is our property
• working with a bespoke ETL system
• working to specific requirements
• offering advice on potential approaches
• needing to ask me questions fairly frequently.
5. Could you please confirm whether the role is inside or outside of IR35? Please can you be more specific?
6. In relation to the IR35 question, would you accept a Specialist working through a Personal Services Company model or would you need them to work through a PAYE model (including Management Companies)? We would expect specialists to work through a PAYE arrangement.