ETL Developer - P19-0038

Tender description

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. Specialist role Developer Expected Contract Length 6 months with the option to extend for 2, 3 month periods Latest start date Monday 6 August 2018 Maximum Day Rate £450 per day excluding VAT Who Speclialist 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 Specialists 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 Skills & 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 Haves • Business Intelligence & Power BI • SQL Server Reporting Services • SQL Server Analysis Services • Analytics & Machine Learning • Big Data / Hadoop / HDInsight / Tableau • Visualisation Work Location 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 Arrangments 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. No. of Specialists to Evaluate 5 Cultural Fit Criteria Agile Approach Evaluation Weighting Technical competence 65% Cultural fit 5% Price 30% Questions from 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.