Job summary
If you are highly accurate and enjoy working with complex data, are experienced in using information to produce solutions, and are looking for a role that can make a difference, the NHS Business Services Authority (NHSBSA) have the opportunity for you! We are looking for a Data Warehouse Architect to be a key resource in our team. It is the perfect opportunity to see how the NHS can help you take the next step in your career!
Are you highly skilled in data warehouse technologies with experience in Data Architecture? You have what this role needs! You will join the Data Warehouse team and be a key member of the Architecture community, responsible for the design of the Data Warehouse architecture, ensuring it meets organisation standards and that it works efficiently and effectively for both ETL processing and the Business Intelligence needs of the organisation. You will be working with high-volume, complex, health-related data sets in an exciting and challenging environment using the latest Oracle cloud technologies.
What do we offer?
27 days leave (increasing with length of service) plus 8 bank holidays.
Flexible working (we are happy to discuss options such as compressed hours)
Flexi time Hybrid working model (we are currently working largely remotely)
Career development
Active wellbeing and inclusion networks
Excellent pension
NHS Car lease scheme
Access to a wide range of benefits and high street discounts!
Main duties of the job
Play a pivotal role in the development and execution of our business strategy. The NHSBSA produces vast amounts of data from the billions of transactions it performs every year across £36 billion of NHS activity; leveraging the value of this data is fundamental for the success of our strategy.
Use your Data Architecture experience in Data Warehouse environments to ensure we can deliver at pace and with confidence in the security, accuracy, and performance of our Enterprise Data Warehouse and associated technologies.
Ensure operational aspects of the Enterprise Data Warehouse are fulfilled alongside developing highly complex solutions to enable sourcing, extracting, transforming, loading, and providing access for data within the NHSBSA's data warehouse.
Use your expertise to provide highly complex data to drive the development of Business Intelligence and Insight.
Work with data experts from partner organisation to ensure that we are using best practice and the latest techniques in how we handle data.
About us
At the NHS Business Services Authority (NHSBSA) we deliver a range of essential national services to NHS organisations and contractors, patients, and the public.
You may already be using some of our services. Do you have a prescription pre-payment certificate? Perhaps you found this vacancy through NHS Jobs? We are behind these, and much more.
Being one of the UK's Best Big Companies to work for, our values are to be Collaborative, Adventurous, Reliable and Energetic. We CARE about what we do and support each other in achieving our objectives.
Our people are the heart of our organisation. We strive to ensure they feel trusted, valued, and empowered. We're passionate about nurturing and developing people. When you join us, we want you to grow, and we offer many opportunities for you to do that.
We welcome applications from people of all backgrounds. With wellbeing and inclusion central to our ethos, our BAME, Disability and Neurodiversity, LGBTQ+, Armed Forces and Women's networks help our colleagues to be their authentic selves at work.
At the NHSBSA we value and respect the diversity of our colleagues and are committed to being a flexible employer. We are proud to offer flexible working opportunities. Whether you're interested in hybrid working, working from home, flexible hours or job sharing, apply today and we can discuss available options with you at the interview stage.
We are the NHS delivering for the NHS.
Job description
Job responsibilities
Job purpose:
As the Data Warehouse Architect, you will be responsible for setting the direction and providing leadership to the data warehouse, data management, nosiness intelligence and data interoperability. You will promote innovation and champion the development of a culture that realizes the value of enterprise data warehouse across the NHS/NHSBSA. Monitoring best practice in data acquisition, process workflows, information requirements and standards and lead the data warehouse of best practice within the organisation.
As a key member in the architecture community, you will work closely and alongside the Enterprise Data Architect of the NHSBSA to ensure that the data warehouse is designed in keeping with the overall enterprise data architecture. You will understand the business impact of changes and recommend solutions to support the strategic aims of the Data Warehouse.
You will provide expertise and guidance in business intelligence and data warehouse, working collaboratively with key stakeholders in the planning, development, delivery and evaluation of BI systems and services.
The post holder will be responsible for leading the development and implementation of the Enterprise Data Warehouse, architecting conformed dimensions and ensuring best-practices are documented, communicated, understood and complied with in all design, development and deployment activities, promoting the wider use of business intelligence to drive change and supporting the organizations / our clients strategic aims and taking the lead role in developing, monitoring and assuring technical skills across the team.
In this role, you are accountable for:
- Act as technical, strategic, and architectural lead for the team responsible for building and developing the NHSBSAs data warehouse, providing expertise in acquiring and managing data for business systems in accordance with the strategy defined by the Enterprise Data Architect.
- Lead the development of architectural principles and ensure compliance with governance activities associated with the organisations enterprise architecture for the Data Warehouse.
- A key member of the Data Warehouse team, helping to formulate the NHSBSA Data strategy for the Data Warehouse, support the resolution of conflicting priorities and influence the portfolio of skills and business improvement initiatives.
- Deliver aspects of the Business Intelligence data strategy for the NHSBSA: responsible for the strategic development of the skill set, delivery of service innovation and implementation of new ways of working to drive improved data management.
- Lead individual for the development of Data Warehouse services across the NHSBSA to enable the implementation of effective Business Intelligence.
- Responsible for the analysis of highly complex and sensitive data within the Data Warehouse and the investigation of new data sources.
- Ensure Data Warehouse security is designed, developed, implemented, and maintained in line with recognised best practice.
- Lead architect and educator for the warehouse team, coordinating and delivering training as required to enable to the team to meet service delivery requirements
- Lead the monitoring and optimisation of the performance of the Data Warehouse systems and the accuracy of the reported data. Oversee the disaster recovery environment.
- Identify and implement methodologies to ensure the NHSBSAs policies for acquisition and analysis of highly sensitive data (person identifiable and commercial) are implemented effectively in the Data Warehouse. Provide expertise for the NHSBSA in methods for anonymization / pseudonymization of data.
- Responsibility for efficient functioning of the Data Warehouse and BI, and ensuring that security protections are appropriate and up to date.
- Line manage, motivate and lead Data Warehouse Developers to capture business data needs quickly and effectively with the aim of increasing individuals contributions through staff engagement.
- Undertake recruitment and selection in line with organisational processes and participate in the implementation and delivery of initiatives to secure suitable resources, increase skills levels and develop talent pools to meet the changing needs of the business landscape.
- Seeking, providing and taking feedback to support and encourage teams and individuals to develop thinking and independently work through issues, to reach solutions-based outcomes. Taking full accountability for the approach and decision-making practices within area, including providing positive challenge to ideas and solutions.
- Champion, communicate, and take personal ownership of the teams success criteria, and establish measures and targets to drive performance in alignment with the NHSBSAs business plan, and with IT architecture and business strategies. Utilize highly functioning communication skills to encourage collaborative client and customer focused approaches.
- Work with business service streams and shared services across the NHSBSA to understand, interpret and analyse operational processes in order that delivery of service improvement opportunities requiring improved data management are prompt, agile and deliver a great customer experience.
- Participate in the selection, delivery and testing of technology across the full product lifecycle; obtain knowledge of technology offerings in the marketplace through horizon scanning.
- Contribute to and prepare proposals for change including producing necessary estimates, mandates and business cases within the Data team.
- Actively participate and be the decision maker in procurement processes for full solutions that meet business needs.
- Develop proposals for future investment including both technology refresh and project- based change; preparing necessary estimates, mandates and business cases within the Data Warehouse team and providing estimates for such led by other departments.
- Contributing to budget management processes in accordance with NHSBSAs policies, standing orders, financial regulations and legislative requirements.
Job description
Job responsibilities
Job purpose:
As the Data Warehouse Architect, you will be responsible for setting the direction and providing leadership to the data warehouse, data management, nosiness intelligence and data interoperability. You will promote innovation and champion the development of a culture that realizes the value of enterprise data warehouse across the NHS/NHSBSA. Monitoring best practice in data acquisition, process workflows, information requirements and standards and lead the data warehouse of best practice within the organisation.
As a key member in the architecture community, you will work closely and alongside the Enterprise Data Architect of the NHSBSA to ensure that the data warehouse is designed in keeping with the overall enterprise data architecture. You will understand the business impact of changes and recommend solutions to support the strategic aims of the Data Warehouse.
You will provide expertise and guidance in business intelligence and data warehouse, working collaboratively with key stakeholders in the planning, development, delivery and evaluation of BI systems and services.
The post holder will be responsible for leading the development and implementation of the Enterprise Data Warehouse, architecting conformed dimensions and ensuring best-practices are documented, communicated, understood and complied with in all design, development and deployment activities, promoting the wider use of business intelligence to drive change and supporting the organizations / our clients strategic aims and taking the lead role in developing, monitoring and assuring technical skills across the team.
In this role, you are accountable for:
- Act as technical, strategic, and architectural lead for the team responsible for building and developing the NHSBSAs data warehouse, providing expertise in acquiring and managing data for business systems in accordance with the strategy defined by the Enterprise Data Architect.
- Lead the development of architectural principles and ensure compliance with governance activities associated with the organisations enterprise architecture for the Data Warehouse.
- A key member of the Data Warehouse team, helping to formulate the NHSBSA Data strategy for the Data Warehouse, support the resolution of conflicting priorities and influence the portfolio of skills and business improvement initiatives.
- Deliver aspects of the Business Intelligence data strategy for the NHSBSA: responsible for the strategic development of the skill set, delivery of service innovation and implementation of new ways of working to drive improved data management.
- Lead individual for the development of Data Warehouse services across the NHSBSA to enable the implementation of effective Business Intelligence.
- Responsible for the analysis of highly complex and sensitive data within the Data Warehouse and the investigation of new data sources.
- Ensure Data Warehouse security is designed, developed, implemented, and maintained in line with recognised best practice.
- Lead architect and educator for the warehouse team, coordinating and delivering training as required to enable to the team to meet service delivery requirements
- Lead the monitoring and optimisation of the performance of the Data Warehouse systems and the accuracy of the reported data. Oversee the disaster recovery environment.
- Identify and implement methodologies to ensure the NHSBSAs policies for acquisition and analysis of highly sensitive data (person identifiable and commercial) are implemented effectively in the Data Warehouse. Provide expertise for the NHSBSA in methods for anonymization / pseudonymization of data.
- Responsibility for efficient functioning of the Data Warehouse and BI, and ensuring that security protections are appropriate and up to date.
- Line manage, motivate and lead Data Warehouse Developers to capture business data needs quickly and effectively with the aim of increasing individuals contributions through staff engagement.
- Undertake recruitment and selection in line with organisational processes and participate in the implementation and delivery of initiatives to secure suitable resources, increase skills levels and develop talent pools to meet the changing needs of the business landscape.
- Seeking, providing and taking feedback to support and encourage teams and individuals to develop thinking and independently work through issues, to reach solutions-based outcomes. Taking full accountability for the approach and decision-making practices within area, including providing positive challenge to ideas and solutions.
- Champion, communicate, and take personal ownership of the teams success criteria, and establish measures and targets to drive performance in alignment with the NHSBSAs business plan, and with IT architecture and business strategies. Utilize highly functioning communication skills to encourage collaborative client and customer focused approaches.
- Work with business service streams and shared services across the NHSBSA to understand, interpret and analyse operational processes in order that delivery of service improvement opportunities requiring improved data management are prompt, agile and deliver a great customer experience.
- Participate in the selection, delivery and testing of technology across the full product lifecycle; obtain knowledge of technology offerings in the marketplace through horizon scanning.
- Contribute to and prepare proposals for change including producing necessary estimates, mandates and business cases within the Data team.
- Actively participate and be the decision maker in procurement processes for full solutions that meet business needs.
- Develop proposals for future investment including both technology refresh and project- based change; preparing necessary estimates, mandates and business cases within the Data Warehouse team and providing estimates for such led by other departments.
- Contributing to budget management processes in accordance with NHSBSAs policies, standing orders, financial regulations and legislative requirements.
Person Specification
Qualifications
Essential
- Masters level qualification in a relevant technical discipline such as computer science or relevant equivalent experience
Desirable
- Certified data management professional
- Project management qualification
- Qualification in Big Data Technologies
- Relevant Oracle qualification
Personal Qualities, Knowledge and Skills
Essential
- Understanding of the potential of data and the critical impact that quality data has across a complex organisation; a detailed understanding of data management practices, including knowledge of third party data cleansing, products and processes.
- Skilled negotiator able to develop relationships and manage stakeholders within the business and IT third parties
- Excellent understanding of data modelling and report development
- Significant knowledge of Business Intelligence and Data Warehouse methodology (FACT and Dimensions) and concepts including training others and architecting enterprise-wide analytical systems
- Detailed understanding of anonymising / pseudonymising highly sensitive data for analysis and reporting
- Data security
- High level understanding of Oracle OBIEE, including Answers, BI Admin tool and Web catalogue
- In-depth / expert knowledge of performance tuning and query optimisation techniques
- Strong analytical skills with good attention to detail
- Ability to analyse and document business reporting requirements with an understanding of the resulting technical implications
- Able to successfully lead teams in time sensitive initiatives
- Able to partner with cross-functional groups to accomplish defined business goals
- Strong multi-project management skills; experienced in organizing, prioritizing, planning, and executing multiple projects
- Able to effectively manage relationships with others within the organisation and with senior officials within the NHS and Department of Health
- Able to build collaborative environments, teaming cultures, and customer service mind-set
- Able to concentrate intensively, using significant discretion in decision making activities
- Excellent customer-facing skills, with the ability to present technology in a clear and understandable way to any audience
- Proactive and personally motivated
- Self-aware, flexible and adaptable
- Accurate with attention to detail
- Works effectively within a team environment
- Curious nature and effectively dives deep into material
- Focused on delivery
- Able to lead others, including the management of performance and delivery of outcomes, in non-line management relationships.
- Excellent communication and presentation skills with the ability to explain fundamental concepts including areas with highly complex and contentious subject matter to individuals at all levels of the organisation. Effective storytelling.
- Able to motivate, persuade and negotiate in non-line management relationships.
- Good at understanding requirements and checking back with sponsors that progress is on the right track
Desirable
- A good knowledge of freedom of information and data protection legislation
- Ability to produce system specifications
- Development of strategic plans
- Able to learn new technologies
Experience
Essential
- Significant experience of leading and managing teams to deliver data warehousing solutions in an operational environment
- Experience of policy development, and implementation, for effective data management
- Demonstrated leadership experience with a successful track record in building cross functional, virtual teams who are focused on information services provision
- Significant demonstrable Business Intelligence, Data modelling and Data Warehouse experience
- Significant experience of database design and development to deliver analytics and reporting
- Current expert knowledge and significant experience of using SQL and PLSQL and in writing advanced SQL (Oracle)
- Significant experience of data modelling
- Significant experience of requirements gathering and working with stakeholders to establish clear and realistic requirements
- Evidence of writing functional and technical specifications / system architecture
- Significant experience of working with large and complex datasets, including financial data.
- Significant experience of developing and delivering technical training for staff; acting as lead and mentor for all staff technical development
Desirable
- Experience of NHS Information provision, local and national requirements
- Experience of collating data and writing board reports
- Expert in Oracle data warehouse products
- Experience of report development and query optimisation including star schema design
- Experience with Oracle Exadata and Exalytics
- Experience of the whole project life-cycle and a structured project management methodology
Person Specification
Qualifications
Essential
- Masters level qualification in a relevant technical discipline such as computer science or relevant equivalent experience
Desirable
- Certified data management professional
- Project management qualification
- Qualification in Big Data Technologies
- Relevant Oracle qualification
Personal Qualities, Knowledge and Skills
Essential
- Understanding of the potential of data and the critical impact that quality data has across a complex organisation; a detailed understanding of data management practices, including knowledge of third party data cleansing, products and processes.
- Skilled negotiator able to develop relationships and manage stakeholders within the business and IT third parties
- Excellent understanding of data modelling and report development
- Significant knowledge of Business Intelligence and Data Warehouse methodology (FACT and Dimensions) and concepts including training others and architecting enterprise-wide analytical systems
- Detailed understanding of anonymising / pseudonymising highly sensitive data for analysis and reporting
- Data security
- High level understanding of Oracle OBIEE, including Answers, BI Admin tool and Web catalogue
- In-depth / expert knowledge of performance tuning and query optimisation techniques
- Strong analytical skills with good attention to detail
- Ability to analyse and document business reporting requirements with an understanding of the resulting technical implications
- Able to successfully lead teams in time sensitive initiatives
- Able to partner with cross-functional groups to accomplish defined business goals
- Strong multi-project management skills; experienced in organizing, prioritizing, planning, and executing multiple projects
- Able to effectively manage relationships with others within the organisation and with senior officials within the NHS and Department of Health
- Able to build collaborative environments, teaming cultures, and customer service mind-set
- Able to concentrate intensively, using significant discretion in decision making activities
- Excellent customer-facing skills, with the ability to present technology in a clear and understandable way to any audience
- Proactive and personally motivated
- Self-aware, flexible and adaptable
- Accurate with attention to detail
- Works effectively within a team environment
- Curious nature and effectively dives deep into material
- Focused on delivery
- Able to lead others, including the management of performance and delivery of outcomes, in non-line management relationships.
- Excellent communication and presentation skills with the ability to explain fundamental concepts including areas with highly complex and contentious subject matter to individuals at all levels of the organisation. Effective storytelling.
- Able to motivate, persuade and negotiate in non-line management relationships.
- Good at understanding requirements and checking back with sponsors that progress is on the right track
Desirable
- A good knowledge of freedom of information and data protection legislation
- Ability to produce system specifications
- Development of strategic plans
- Able to learn new technologies
Experience
Essential
- Significant experience of leading and managing teams to deliver data warehousing solutions in an operational environment
- Experience of policy development, and implementation, for effective data management
- Demonstrated leadership experience with a successful track record in building cross functional, virtual teams who are focused on information services provision
- Significant demonstrable Business Intelligence, Data modelling and Data Warehouse experience
- Significant experience of database design and development to deliver analytics and reporting
- Current expert knowledge and significant experience of using SQL and PLSQL and in writing advanced SQL (Oracle)
- Significant experience of data modelling
- Significant experience of requirements gathering and working with stakeholders to establish clear and realistic requirements
- Evidence of writing functional and technical specifications / system architecture
- Significant experience of working with large and complex datasets, including financial data.
- Significant experience of developing and delivering technical training for staff; acting as lead and mentor for all staff technical development
Desirable
- Experience of NHS Information provision, local and national requirements
- Experience of collating data and writing board reports
- Expert in Oracle data warehouse products
- Experience of report development and query optimisation including star schema design
- Experience with Oracle Exadata and Exalytics
- Experience of the whole project life-cycle and a structured project management methodology
Additional information
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
