Project 20092 - Software Developer - Universal Credit Full Service Data Delivery Team copy

Tender description

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. Specialist role Developer Expected Contract Length 2 year contract - initial 4 month statement of work Latest start date Monday 26 June 2017 Maximum Day Rate £550 Who Speclialist 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 Specialists 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 & 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. Work Location Caxton House, Tothill St, London Working Arrangments 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 Security Checked clearance is essential Additional T&Cs Additional terms and conditions can be found via DWP’s eTendering system: 1. 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) 2. For further Assistance please consult the online help, or the eTendering help desk on Phone 0800 368 4850 or email help@bravosolution.co.uk. No. of 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 • Meeting facilitation and chair person / leadership skills Evaluation Weighting Technical competence 70% Cultural fit 10% Price 20% Questions from Suppliers 1. Note from Buyer. Please note that this advert has been reissued to include the requirement for Security Checked clearance. 2. Will the role fall within IR35 legislation? At this time the role has been deemed as outside of IR35 however, should the features of the engagement change, a further assessment will be made which could change the determination. 3. The jobs posted this morning for DWP have now been duplicated. Does this mean that you will need more than 1 candidate for each role. Please confirm. No, the jobs were reissued to include the requirement for Security Checked clearance. The original advert should be removed shortly. We are only seeking one individual for each role. 4. Please could you confirm whether you have an incumbent in this position? Yes 5. Can you please confirm if the candidate should be BPSS cleared already or eligible candidates would also be considered. Would you sponsor BPSS clearance if the candidate is eligible We require Security Check clearance for this role at point of engagement to prevent delay of key deliverables. 6. Will you sponsor SC clearance if the candidate is eligible for SC clearance No - SC clearance required at point of engagement to prevent delay of key deliverables 7. What is the lead time for feedback once the application is submitted? We intend to have agreed the final three shortlisted candidates by 15 June. It is our intention to give any requested feedback as quickly as is possible. 8. Can more than one candidate per supplier be submitted for this role Suppliers may only put forward one candidate per specialist opportunity. 9. What are the other expenses which will be paid Any expenses requirements should be included in the overall price submitted for the role 10. Any expenses requirements should be included in the overall price submitted for the role Shortlisted suppliers will be sent a Work History template to be completed. 11. What is the total number for positions open for this role One 12. Is occasional remote working allowed? Yes – but only within the United Kingdom 13. Is there any travel involved in this role and will the travel expenses be paid ? The role is London based and no travel is anticipated. 14. Is the rate inclusive or exclusive of VAT? The day rate price excludes VAT 15. Would you consider work permit holders (e.g. Tier 2 General Visa) and EU passport holders for this role ? Yes- as long as they have SC clearance at point of engagement 16. Do we have to apply in the www.digitalmarketplace.service.gov.uk website also though its mentioned that the candidates have to be submitted via Bravo as part of the supplier tender responses? Kindly confirm Applications must be made via the DOS portal. Bravo is being to used to share additional terms and conditions required by DWP. 17. The Java API requirement, is this a must have skill? unusual to find SQL, BI Data pared with Java. Yes 18. When you mention SQL, does this mean the consultant needs MS SQL Server or simply PostgreSQL? When you mention SQL, does this mean the consultant needs MS SQL Server or simply PostgreSQL? 19. Will DWP SSCL sponsor SC clearance for consultants who do not have it currently but are eligible for it? No –SC clearance must be held at point of engagement 20. Experience of working with DWP or similar organisation in the last 3 years - Can you please specify as to what to you mean by similar organizations. Will you consider any public sector experience as similar experience or the candidate should have specific experience in pensions. Large national central government experience required