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.