Scottish Enterprise

P21-0032 Data Engineer 2

11 Incomplete applications

10 SME, 1 large

18 SME, 4 large

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

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.

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 terms and conditions: option to extend the contract by 3 months

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

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

All suppliers will be asked to provide a work history.

How many specialists to evaluate

Cultural fit criteria

Additional assessment methods

Evaluation weighting

Technical competence

60%

Cultural fit

20%

Price

20%

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.