Department for Work and Pensions

Software Developer - Universal Credit Full Service Data Delivery Team

Incomplete applications

4
Incomplete applications
2 SME, 2 large

Completed applications

10
Completed applications
8 SME, 2 large
Important dates
Opportunity attribute name Opportunity attribute value
Published Thursday 28 September 2017
Deadline for asking questions Monday 2 October 2017 at 11:59pm GMT
Closing date for applications Thursday 5 October 2017 at 11:59pm GMT

Overview

Overview
Opportunity attribute name Opportunity attribute value
Specialist role Developer
Summary of the work DWP is delivering modern data and analytics products that are driving innovation within the wider department. The UC programme has a massive amount of structured and unstructured data that is the foundation for a data driven approach and the UC data team sit at the heart of delivering that vision.
Latest start date Wednesday 1 November 2017
Expected contract length 2 year contract with initial Statement of Works of 5 months
Location London
Organisation the work is for Department for Work and Pensions
Maximum day rate £550

About the work

About the work
Opportunity attribute name Opportunity attribute value
Early market engagement
Who the specialist will work with Working as part of a multi-disciplinary team with responsibility to provide data to operational sites and colleagues to allow them to track, understand and improve operational performance. Types of roles that are included in this team are Full Stack Web Developers, Data Engineers, Java Software Engineers, UX designers, Data Scientists, Data Analysts, BI reporting Analysts.
What the specialist will work on - Develop data marts and cubes using SQL and other appropriate technologies.
- Build SQL stored procedures to support specific reporting requirements in Postgres and Hive.
- Develop APIs using Java and Spring Boot.
- Manage code versioning using Git.
- Follow and contribute to the improvement of team release processes.
- Work in an agile environment following a prioritised backlog.

Work setup

Work setup
Opportunity attribute name Opportunity attribute value
Address where the work will take place Caxton House, Tothill Street, London, SW1H 9NA
Working arrangements 5 days a week on-site working as part of a multi-disciplinary agile delivery team with work being specified by a work management system (JIRA). You will attend daily Town Halls, Stand-ups and relevant Show & Tells to monitor/discuss progress.
Security clearance Willingness to apply for SC level clearance or have existing level SC clearance will be required.

Additional information

Additional information
Opportunity attribute name Opportunity attribute value
Additional terms and conditions Additional clause to be added for Offshoring, Data Protection and Security. Additional terms and conditions can be found via DWP’s eTendering system:
Register on the eSourcing portal (this is only required once): https://dwp.bravosolution.co.uk & click the link to register - Accept the terms & conditions & click 'continue' - Enter your correct business & user details - Note your chosen username & click 'Save'. You will receive an email with your password (keep this secure).
For further Assistance please consult the online help, or the eTendering help desk on Phone 0800 368 4850 or email help@bravosolution.co.uk.

Skills and experience

Buyers will use the essential and nice-to-have skills and experience to help them evaluate suppliers’ technical competence.

Skills and experience
Opportunity attribute name Opportunity attribute value
Essential skills and experience
  • Experience of working with complex data structures in json format
  • Experience of writing SQL to transform complex data in large databases. Experience of creating stored SQL procedures to support reporting requirements.
  • Knowledge of the following tools: Postgres, Mongo, Spring Boot, IntelliJ, HDFS, Hive
  • Knowledge of Business Intelligence production best practice and creation of data marts / cubes of data
  • Experience of working with DWP or similar organisation in the last 3 years.
Nice-to-have skills and experience

How suppliers will be evaluated

How suppliers will be evaluated
Opportunity attribute name Opportunity attribute value
How many specialists to evaluate 3
Cultural fit criteria
  • Demonstrate flexibility (e.g. the ability to shift tasks to meet changing priorities)
  • Demonstrate successful collaborative working as part of a multi-supplier delivery team sharing knowledge within the team
  • Demonstrate meeting facilitation and chair person / leadership skills.
  • SQL test will be required,however,this will not be invigilated or time bound. This will not be individually scored but will act as background information on the capability of the applicant.
Assessment methods
  • Work history
  • Interview
  • Scenario or test
Evaluation weighting

Technical competence

70%

Cultural fit

10%

Price

20%

Questions asked by suppliers

Questions asked by suppliers
Supplier question Buyer answer
1. Will this fall outside IR35? Yes - This will fall outside IR35.
2. Can candidates work on site whilst the SC clearance is going through? Yes - The Department will sponsor the candidate's SC Clearance whilst they work providing they are eligible (been a UK resident for the last 5 years).