Awarded to Be-IT Resourcing Limited

Start date: Monday 13 August 2018
Value: £74,250
Company size: SME
Scottish Enterprise

ETL Developer - P19-0038

8 Incomplete applications

5 SME, 3 large

13 Completed applications

10 SME, 3 large

Important dates

Published
Wednesday 4 July 2018
Deadline for asking questions
Friday 6 July 2018 at 11:59pm GMT
Closing date for applications
Wednesday 11 July 2018 at 11:59pm GMT

Overview

Specialist role
Developer
Summary of the work
To support activities of Scottish Enterprise and partners the specialist will work with the Azure platform, data warehousing, data modelling, SQL databases / data factory / data lake, ETL & SQL server integration services.
Latest start date
Monday 6 August 2018
Expected contract length
6 months with the option to extend for 2, 3 month periods
Location
Scotland
Organisation the work is for
Scottish Enterprise
Maximum day rate
£450 per day excluding VAT

About the work

Early market engagement
Who the specialist will work with
Working within an Agile service design, delivery and support team of circa 50 people responsible for digital transformation activities across the organisation. It’s a multidisciplinary team with software developers, testers, designers, user researchers, Dynamics developers, service designers and product owners. The ETL team will work closely with our head of software engineering, our CRM and analytics team.
What the specialist will work on
Working as part of an agile team working on a digital transformation programme putting data at the heart of service design, development and delivery. Microsoft Azure and Dynamics are at the core of our infrastructure. We are developing our data strategy and will be working on data warehousing and data modelling and will be looking for a developer with relevant experience with SQL databases, data factory, data lake etc

Work setup

Address where the work will take place
The supplier will work predominantley at our premises in Glasgow but there is also an option for suppliers to work remotely for part of the week.
Scottish Enteprise
5 Atlantic Quay
150 Broomielaw
Glasgow
G2 8LU
Working arrangements
The supplier is expected to supply a resource to work as part of the team based in the office in Glasgow city centre. Standard working hours of 9-5 Mon-Fri.
Security clearance
Baseline Personnel Security Standard level clearance is required for this role.

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
  • Microsoft Azure & Agile Development Practices
  • Data Warehousing and Data Modelling
  • Azure SQL Databases / Data Factory / Data Lake
  • ETL & SQL Server Integration Services (SSIS)
  • T-SQL / SQL Server
  • Platform as a Service (PaaS)
  • Office & Dynamics 365
Nice-to-have skills and experience
  • Business Intelligence & Power BI
  • SQL Server Reporting Services
  • SQL Server Analysis Services
  • Analytics & Machine Learning
  • Big Data / Hadoop / HDInsight / Tableau
  • Visualisation

How suppliers will be evaluated

How many specialists to evaluate
5
Cultural fit criteria
Agile Approach
Assessment methods
  • Work history
  • Interview
Evaluation weighting

Technical competence

65%

Cultural fit

5%

Price

30%

Questions asked by suppliers

1. Please can you confirm if this role is inside / outside of IR35?
The IR35 status is that the intermediaries legislation doesn't apply to this engagement.
2. Is there a current incumbent or is this a new role?
No
3. The rate seems low. Is there any flexibility there please?
Yes there could be some flexibility in the day rate up to £500 per day (or potentially £550 for a top candidate). This is consistent with the Data & Advanced Analytics typical rates for Database Developers for Scotland.
4. I agree on the rate issue. Even £550 all-in is pretty low for an Azure (Data Lakes/Data Factory etc) Database Specialist. There aren't that many of these people about, certainly given the location and people may have to stay over during the weeks if travelling from further South. They command a high rate for that reason. Would you perhaps re-issue this piece of work at around the £600-£650 (max) mark?
We will be letting the procurement run its course and if we don’t manage to secure someone we’ll review and go back to the market if required.