Department for Work and Pensions

Software Developer - Universal Credit Full Service Data Delivery Team

4 Incomplete applications

2 SME, 2 large

8 SME, 2 large

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

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.

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

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

Evaluation weighting

Technical competence

70%

Cultural fit

10%

Price

20%

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