Job summary
An exciting opportunity has arisen within the Data Management Services department for a Data Warehouse Architect. This role would be suitable for a senior SQL data warehouse developer who is looking to further progress their career or, existing technical architects with great team leadership skills wanting to work with data at a very large scale, in order to help improve outcomes for patients and support the wider NHS.
Main duties of the job
The role requires that the post holder technically lead and manage the delivery of large scale BI projects ensuring value for money and customer satisfaction. This will be achieved by leading the data warehouse team and by using and understanding advanced data warehousing techniques.
The post holder will be a strong team leader and communicator able to guide their team to become even more advanced and skilled. They will also use their technical expertise to improve standards of development across the CSU.
About us
This is an exciting time to join NHS South, Central and West.
We are one of the largest commissioning support units in the country, providing support and professional expertise for over 70 NHS and non-NHS customers, including clinical commissioning groups, NHS England, local authorities, foundation trusts, social enterprises and other health-related organisations.
We're supporting clients whose vision and quest for innovation requires us to be flexible, adaptable and open to adventure; giving us the freedom to work in new ways, looking at things from a different angle and challenging the norm.
We are committed to attracting and retaining the best people in order to provide the best possible services to our customers. Our staff enjoy challenging, rewarding roles, supporting our customers to improve their local health and care want our people to fulfil their potential so we offer a wide range of training, opportunities to gain qualifications as well as access to coaching and mentoring schemes.
If you join us, we will value your experience, your contribution and we will give you the knowledge to succeed as part of your specialist team and as part of our organisation.
To find out more about what SCW has to offer, please visit Our offer to you page.
Job description
Job responsibilities
Please refer to the job description and person specification for further details and information regarding this role.
Person Specification
Values & Behaviours
Essential
1. Patient First - Customer Excellence
2. Aspirational
3. Collaborative
4. Insightful
5. Respectful
Education
Essential
6. Educated to masters level or equivalent level of experience of working at a senior level in specialist area
7. Technical skills backed up with accredited professional certification
Knowledge & Experience
Essential
8. Extensive knowledge of Data warehousing and Business Intelligence, acquired through post graduate diploma or equivalent experience or training plus further specialist knowledge or experience to master's level equivalent.
9. Evidence of post qualifying and continuing professional development.
10. Must have an understanding of the background to and aims of current healthcare policy and appreciate the implications of this on engagement.
11. Should have an appreciation of the relationship between NHS England, the HSCIC, CCG and GP practices.
Skills & Capabilities
Essential
12. Must be able to provide and receive highly complex, sensitive or contentious information,
13. Negotiate on difficult and controversial issues including performance and change.
14. ETL design and development within Microsoft technologies
15. OLAP structures.
16. Reporting.
17. Demonstrated capability to plan over short, medium and long-term timeframes and adjust plans and resource requirements accordingly.
18. Must be able to prioritise own work effectively and be able to direct activities of others. Experience of managing and motivating a team and reviewing performance of the individuals.
19. Must be able to use initiative to decide relevant actions and make recommendations to Sponsor/ Manager, with the aim of improving deliverables and compliance to policies.
20. Ability to make decisions autonomously, when required, on difficult issues, working to tight and often changing timescales.
21. Experience of identifying and interpreting National policy. Experience of researching best practice (globally, private and public sector), interpreting its relevance and processes/ practices which could be implemented successfully to achieve system reform (advising on policy implementation).
22. Working knowledge of Microsoft Office with intermediate keyboard skills
23. Needs to have a thorough understanding of and commitment to equality of opportunity and good working relationships both in terms of day-to-day working practices, but also in relation to management systems.
24. Previously responsible for a budget, involved in budget setting and working knowledge of financial processes.
25. Used to working in a busy environment
26. Adaptability, flexibility and ability to cope with uncertainty and change
27. Willing to engage with and learn from peers, other professionals and colleagues in the desire to provide or support the most appropriate interventions
28. Professional calm and efficient manner
29. Effective organizer, influencer and networker
30. Demonstrates a strong desire to improve performance and make a difference by focusing on goals.
31. Completer/Finisher
Desirable
32. SharePoint
33. Tableau Server
34. Tableau development skills
35. Visualisation tool development.
36. SQL server administration.
37. Warehouse theory & Design.
38. Software design life cycle.
39. Security.
40. User Experience.
41. Comprehensive experience of project principles techniques and tools such as Prince 2 and Managing Successful Projects.