Contract: NHS Community Services Data Warehouse Developer
Rate: £450 per day + VAT, outside IR35
Expenses: Up to 2 client visits per month reclaimable, travel and accommodation
Location: Southeast England
Duration: 3 months initially
Start: January 2025
Our client, an NHS community healthcare provider has asked for our support with re-building a data mart within their Data Warehouse to enable more accurate statutory Community Services Data Set reporting (CSDS) to NHS England. For this assignment, you will be:
- Analysing the current processes and warehouse architecture for collecting information from the 30+ different source tables that feed into their CSDS extraction process at present
- Understanding and communicating back to the data warehouse and BI team your findings including any data quality and architectural issues within their existing processes
- Developing a new process for extracting relevant data from tables into the CSDS file for submissions to NHSE
- Conducting hands-on analysis and development work on SQL server utilising, T-SQL, Stored Procedures, ETL procedures, SSIS, SSRS, SSAS
- Listening and learning the way the organisation works and quickly adjusting your approach accordingly
If you’re interested, please contact Alex in the Penpole Bristol office before 12:00 on Friday 10th January.