PowerBI designer/developer

Tender description

Summary of the work Specialist PowerBI designer/developer Specialist role Developer Latest start date Monday 7 September 2020 Who Speclialist Work With Howard Taylor, Senior Civil Engineer (Project manager) What Specialists 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 Skills & 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 Haves • Have experience in coding in Python • Have experience in previous work relating to UK railways or transport Work Location 25 Cabot Square, London, E13 4QZ Working Arrangments Due to covid-19 we expect the specialist to work from home, however our office in Canary Wharf may be open for use. No. of Specialists to Evaluate 3 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 Assessment Method Interview Evaluation Weighting Technical competence 60% Cultural fit 20% Price 20% Questions from 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 No 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 DBS 10. Will you consider working with offshore candidates No