This opportunity is closed for applications

The deadline was Tuesday 4 August 2020
Office of Rail and Road

PowerBI designer/developer

18 Incomplete applications

16 SME, 2 large

36 Completed applications

33 SME, 3 large

Important dates

Tuesday 28 July 2020
Deadline for asking questions
Thursday 30 July 2020 at 11:59pm GMT
Closing date for applications
Tuesday 4 August 2020 at 11:59pm GMT


Specialist role
Summary of the work
Specialist PowerBI designer/developer
Latest start date
Monday 7 September 2020
Expected contract length
Organisation the work is for
Office of Rail and Road
Maximum day rate

About the work

Early market engagement
Who the specialist will work with
Howard Taylor, Senior Civil Engineer (Project manager)
What the specialist will work on
We have developed a fully working PowerBI tool using our in-house team, but we are now looking for a specialist PowerBI designer/developer to help us:
• make the interface more user-friendly
• add more analytical functionality
• join 2 parts of the tool seamlessly (numerical data + text based data)

The scope of work for the specialist will include the following technical tasks:
• PowerBI coding in DAX, R and M, for query manipulation and dynamic filtering
• Analysis within PowerBI, using analysis Services (or equivalent)
• PowerBI visualisations, including custom visualisations
• Linking PowerBI to data storage systems

Work setup

Address where the work will take place
25 Cabot Square, London, E13 4QZ
Working arrangements
Due to covid-19 we expect the specialist to work from home, however our office in Canary Wharf may be open for use.
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 experience in coding in DAX, M and R
  • Have experience in use of Analysis Services
  • Have experience in designing custom visuals for PowerBI
  • Have experience in designing complex PowerBI models, with datasets from a wide range of sources
  • Have experience in rapid prototyping and working with constantly evolving requirements (e.g. Agile projects, or similar)
Nice-to-have skills and experience
  • Have experience in coding in Python
  • Have experience in previous work relating to UK railways or transport

How suppliers will be evaluated

All suppliers will be asked to provide a work history.

How many specialists to evaluate
Cultural fit criteria
  • The person must be open-minded, innovative, and able to take on new ideas and change course very quickly.
  • Be able to work from home without constant supervision
Additional assessment methods
Evaluation weighting

Technical competence


Cultural fit




Questions asked by suppliers

1. Expected contract length
Approx 1 month full time, but could be anywhere from 3 weeks to 2 months – to be agreed before starting and will depend on day rates and whether the specialist is working full/part time etc.
2. What is the budget
Will depend on the specialist’s skill level (i.e. day rate) and availability, but we are considering approx.. £10,000 to £15,000 total.
3. Is there a current incumbent
4. What is the IR35 status
It is anticipated that the rules will not apply but this will need to be determined once the ‘worker’ status is known.
5. Can you confirm the max day rate
There is no max day rate. Our assumed contract length and budget are based on assumed day rates up to £750/day, but we would consider paying a higher rate for someone with exceptional skills/experience (possibly for a slightly shorter contract duration).
6. What is the earliest start date as opposed to the latest start date
Monday 7th Sep
7. Is UK rail industry experience a must
This is not essential. The applicant will need to get up to speed on a large and complex set of data inputs very quickly, so this would be much easier if they were familiar with some of the terminology – but this is not essential.
8. Is this a full time Mon-Fri 9-5 role
We are happy to discuss different working patterns (e.g. 50% every day, 3 days per week, weekends etc), but we are looking for a very fast, reactive exchange of ideas and solutions between the specialist and the project manager.
9. Please confirm required security clearance
10. Will you consider working with offshore candidates