This opportunity is closed for applications

The deadline was Monday 15 June 2020
Scottish Enterprise

P21-0032 Data Engineer 2

11 Incomplete applications

10 SME, 1 large

22 Completed applications

18 SME, 4 large

Important dates

Published
Monday 8 June 2020
Deadline for asking questions
Wednesday 10 June 2020 at 11:59pm GMT
Closing date for applications
Monday 15 June 2020 at 11:59pm GMT

Overview

Specialist role
Data engineer
Summary of the work
As a data engineer you will be an integral member of the data team that drives development of new services. You will help create user-focused data solutions by analysing, preparing, transforming, loading, and maintaining data and systems with a strong focus on delivering fit-for-purpose services.
Latest start date
Monday 22 June 2020
Expected contract length
8 months
Location
Scotland
Organisation the work is for
Scottish Enterprise
Maximum day rate
£475 excluding VAT and inclusive of all other costs

About the work

Early market engagement
Who the specialist will work with
Working within an Agile service design, delivery and support team of circa 30 people responsible for digital transformation activities across the organisation. It’s a multidisciplinary team with software developers, business analysts, data engineers, testers, designers, user researchers, Dynamics developers, service designers and product owners. The data engineer will work closely with the service design team with product owners and service designers to implement new data and analytics processes to support the delivery of services to our users.
What the specialist will work on
The specialist will support the implementation of SE’s digital transformation. This service design team are looking specifically at the systems and processes involved in managing financial transactions with businesses who have successfully applied for business support. The review of these services will require hands on business analysis as well as working within an agile delivery team with varied tasks involved day to day.

Work setup

Address where the work will take place
The supplier is expected to supply a resource to work as part of the team. A core team is based in Glasgow city centre and work standard working hours of 9-5 Mon-Fri. It is expected that the resource would be available for physical meetings and coworking at times but remote working is available.
Working arrangements
The supplier is expected to supply a resource to work as part of the team. A core team is based in Glasgow city centre and work standard working hours of 9-5 Mon-Fri. It is expected that the resource would be available for physical meetings and coworking at times but remote working is available.
Security clearance
Baseline Personnel Security Standard level clearance is required for this role.

Additional information

Additional terms and conditions
option to extend the contract by 3 months

This role is outwith IR35 legislation (doesn't apply)

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
  • UML or other methodologies
  • Data flow diagramming
  • Power BI and Power Query
  • Azure Synapse (Kimball method)
  • Azure SQL Database
  • Azure Data Factory
  • Azure Data Bricks
  • Integration Services
  • PowerShell, C#, R, Python, TSQL,
  • Entity Relation Modelling (Logical and physical)
  • Azure Data Catalogue
Nice-to-have skills and experience
  • Power Platform
  • Common Data Store
  • Waterfall and Agile based techniques
  • Project life cycle management, from inception, business case, project initiation, through to implementation, governance, and controls
  • Managing Success Programmes and Scrum expertise applied to data driven projects is desired
  • Translate requirements from business to technical (UML or other methodology)
  • Business information modelling
  • Data analysis techniques
  • Conceptualise and describe/design data flow
  • Software development life cycle

How suppliers will be evaluated

All suppliers will be asked to provide a work history.

How many specialists to evaluate
5
Cultural fit criteria
  • Work as part of an agile team, helping others clear priority tasks as required
  • Deliver value to customers early and often.
  • Be transparent and collaborative in decision making.
  • Take responsibility and ownership of tasks.
  • Challenge the status quo.
Additional assessment methods
  • Reference
  • Interview
Evaluation weighting

Technical competence

60%

Cultural fit

20%

Price

20%

Questions asked by suppliers

1. please confirm if you have an incumbent?
Yes
2. Will this be re awarded to the incumbent?
This is an open procurement process and we don’t know who will be responding to our requirements. We will follow the relevant evaluation process to award this contract
3. What are you looking for from a new supplier that the current incumbent is not providing?
As we have reached the end of our duration contract with the incumbent supplier we are bound by our own procurement policy to conduct a new competitive procurement process.
4. How do you require 'PowerShell, C#, R, Python, TSQL' responses to be answered within the limit, what are you looking for here?
Candidates should match the skills required and demonstrate that they can deliver the requirements.
5. Is there flexibility on the start date? For example, would 1st July be acceptable?
Yes there is some flexibility on the start date.