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 Monday 26 June 2017
Expected contract length 2 year contract – initial 4 month statement of work
Organisation the work is for Department for Work and Pensions
About the work
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.
Skills and experience
Essential skills and experience:
Ability to build APIs using Java
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.