This opportunity is closed for applications

The deadline was Monday 15 June 2020
Scottish Enterprise

P21-0030 Data Engineer 1

8 Incomplete applications

8 SME, 0 large

23 Completed applications

19 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. Is there a current incumbent?
Yes
2. Is there an incumbent
Yes
3. How many suppliers will be taken to next stage
As per the published requirement we will take 5 through to the next stage
4. How will you evaluate our response? Do we need to share the profile of the proposed candidates as per each essential and nice to have criteria or should we explain where they used those skills/which project
We will be following the framework guidelines, where suppliers don’ meet the mandatory skills and experience they will be excluded, we will then create a shortlist with suppliers who have the most nice to have skills.
You will need to demonstrate within each criteria that you meet the skills. We may wish to conduct telephonic interviews
5. Is there an incumbent meeting this requirement? If yes, which organisation is it
Yes, James Harvard
6. please confirm if you have an incumbent?
Yes
7. Would you cover travel expenses?
No
8. Would a combination of UK onshore and remote offshore data engineering services be considered?
Yes this will be considered as long as all criteria is met and suppliers are able to attend location based activities at short notice when required.
9. 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.
10. It seems a stretch to have one candidate that has project experience in the BA stages, data architecting and modelling, ETL, reporting, big data engineering all specifically in the MS / Azure tools AND programming experience in C#, Python, R and T-SQL.
It seems it is a binary approval process however, would you recommend ticking yes and explaining exposure to these tools or experience in analogous tools in different stacks for example?
If a great candidate does not have evidence in all 11 specific requirements.
Successful candidates need to demonstrate the must have skills and the nice to have skills, meeting all the nice to have skills will help to ensure that candidate is taken through to the next stage.
11. The role requires BPSS level clearance. Do you expect the successful candidate to have this already, or will you support applications for clearance?
Candidates should have this or be in the process of applying for this
12. What is required for a candidate to exceed your expectations when evidencing the required skills and experience (especially the technologies listed under essential skills and experience)?
Candidates need to meet all of the must have skills in order for the nice to have skills to be evaluated. If Candidates meet all the skills then they maybe asked to attend an electronic interview.
13. Is there flexibility on the start date? For example, would 1st July be acceptable?
There is some flexibility to the start date.