Awarded to SoftwareONE UK Ltd

Start date: Wednesday 1 November 2017
Value: £56,992
Company size: large
Department for Work and Pensions

Software Developer - Universal Credit Full Service Data Delivery Team

4 Incomplete applications

2 SME, 2 large

10 Completed applications

8 SME, 2 large

Important dates

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


Specialist role
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
Organisation the work is for
Department for Work and Pensions
Maximum day rate

About the work

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

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 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): & 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

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
  • 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 many specialists to evaluate
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


Cultural fit




Questions asked by suppliers

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).