Job summary
Do you love working with complex information? Do you have a knack for turning data into solutions? If so, we at NHS Business Services Authority (NHSBSA) have just the opportunity for you! We're on the lookout for a Data Warehouse and BI Developer to join our team. This is your chance to see how the NHS can help you take the next step in your career!
Are you well-versed in ETL processing and database design? Do you enjoy mentoring and developing colleagues in their current roles? If you're answering yes to these questions, then you're just the person we need! You'll join our Data Warehouse team, leading work on the design, development, testing, and production of ETL processes of Workforce systems into the data warehouse. You'll be working with high-volume, complex, health-related data sets in an exciting and challenging environment using the latest cloud technologies.
What's in it for you?
27 days leave (increasing with length of service) plus 8 bank holidays
Flexible working (we are happy to discuss options such as compressed hours)
Generous NHS Pension Scheme with 23.7% employer contribution
Hybrid working model (we are currently working largely remotely)
Career development
Active wellbeing and inclusion networks
NHS Car lease scheme
Access to a wide range of benefits and high street discounts!
Main duties of the job
As our new BI Developer, you'll be responsible for leading the development and maintenance of data warehouses across our business services. You'll use your advanced expertise in data management to take business requirements and translate these into data repositories that drive the delivery of business intelligence. You'll be responsible for the full development lifecycle of reporting, database, data integration, cube, and data warehousing solutions from scratch. This role requires significant technical expertise in using Oracle products.
You'll determine how data from internal systems used to deliver NHSBSA services are brought into the warehouse and will provide expert advice to ensure that warehouse requirements are included in all future systems developments. You'll provide leadership in transitioning from local reporting mechanisms to using advanced business intelligence tools.
You'll take forward the Information Services vision through delivering strategic data solutions for the NHSBSA that enables provision of accurate and reliable information to the NHS, government, and other external bodies.
About us
Here at the NHS Business Services Authority (NHSBSA), what we do matters.
We manage the NHS Pension scheme, process prescription payments and much more. Our services are used by NHS organisations, contractors and the public: we take pride in being part of something so meaningful, that touches millions of lives.
Just as we design our services around the needs of our customers, we place our people at the heart of our organisation. That's why when you join us, you'll be empowered and given the right support to help your career grow.
As one of the UK's Best Big Companies to work for, we're all connected to our values: Collaborative, Adventurous, Reliable and Energetic. We care about our people, our purpose, and your progress.
We strive to offer a fantastic colleague experience, where every voice is heard, and every colleague is supported and respected. Wellbeing, diversity and inclusion is at the centre of this, so when you join us, you can connect with our Lived Experience Networks who help us to bring our authentic selves to work.
We welcome applications from people of all backgrounds and circumstances. We are committed and proud to be a flexible employer and will endeavour to offer a working pattern that suits you wherever possible, whether that be hybrid working, flexible hours, job sharing and more.
Ready to join us on our journey to be a catalyst for better health? Apply today and see where the NHSBSA can take you.
We are people connected to care.
Job description
Job responsibilities
In this role, you are accountable for:
Key responsible individual for the development of data warehouse services across the NHSBSA to enable the implementation of effective business intelligence.Provide expertise in integrating and optimising structured and/or unstructured data using highly complex database products, technologies, and methods. Typical examples of the deliverables are database designs, information models (logical, physical and dimensional), data migration plans, and data warehouse repositories.Responsible for data mapping, detailed data analysis and metadata analysis; creating and maintaining mapping documents and technical documentation.Responsible for analysis of highly complex and sensitive data within the data warehouse and the investigation of new data sources. Providing expertise in combining transaction data from the NHSBSA with data from external sources such as NHS England, NHS Digital, DWP and Public Health England.Responsible for designing and implementing the OBIEE BI Repository (RPD) at the physical, business model and presentation layers to meet business requirements, including SQL/PLSQL queries, Data Modelling, and Star Schema design.Co-ordination and delivery of agreed reporting requirements within the data warehouse, together with planning and scheduling of work plans for staff in Information Services and for the management of staff delivering projects to ensure that targets are achieved.Responsible for negotiating priorities for delivering changes to information and data structures with business and programme managers.Responsible for developing policies for ETL development and implementation, based on best practice to deliver optimum performance.Ensure data warehouse security is designed, developed, implemented and maintained in line with recognised best practice.Monitor and optimise the performance of the data warehouse systems and the accuracy of the reported data. Oversee the disaster recovery environment.Solve complex problems for key service users to deliver business intelligence requirements. Work with requirement owners to define and clearly document business reporting requirements, issues and challenges, including technical implications.Lead on the delivery of integration of information systems into the warehouse from across the NHSBSA, developing plans to replace manual reporting processes within services.Develop clear plans for data warehouse development, mapping out proposed improvements and resources required. Ensure that upgrades and enhancements to the data warehouse and associated software are properly planned and implemented to agreed quality standards.Build business cases to gain approval for data ware house development, to include forecasting costs, resources and timescales.Maintain an understanding of NHSBSA strategic direction, technical capabilities, IT architecture strategy, and business support initiatives.Take responsibility for own professional development and engage in the organisation appraisal system positively to identify personal training and development opportunities.Be a point of expert advice for senior stakeholders on the capabilities and complexities of the data warehouse, and manage expectations over data warehouse deliverables.
In addition to the above accountabilities, as post holder you are expected to:
Undertake additional duties and responsibilities in line with the purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Encourage an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Follow NHSBSA policies, procedures, and protocols as they apply to your role.
Working relationships
Responsible to: Information Standards Manager/ Information Services Manager (Data management and acquisition)
Key relationships and connections:ClientsCustomersStrategic PartnersSenior Managers
Job description
Job responsibilities
In this role, you are accountable for:
Key responsible individual for the development of data warehouse services across the NHSBSA to enable the implementation of effective business intelligence.Provide expertise in integrating and optimising structured and/or unstructured data using highly complex database products, technologies, and methods. Typical examples of the deliverables are database designs, information models (logical, physical and dimensional), data migration plans, and data warehouse repositories.Responsible for data mapping, detailed data analysis and metadata analysis; creating and maintaining mapping documents and technical documentation.Responsible for analysis of highly complex and sensitive data within the data warehouse and the investigation of new data sources. Providing expertise in combining transaction data from the NHSBSA with data from external sources such as NHS England, NHS Digital, DWP and Public Health England.Responsible for designing and implementing the OBIEE BI Repository (RPD) at the physical, business model and presentation layers to meet business requirements, including SQL/PLSQL queries, Data Modelling, and Star Schema design.Co-ordination and delivery of agreed reporting requirements within the data warehouse, together with planning and scheduling of work plans for staff in Information Services and for the management of staff delivering projects to ensure that targets are achieved.Responsible for negotiating priorities for delivering changes to information and data structures with business and programme managers.Responsible for developing policies for ETL development and implementation, based on best practice to deliver optimum performance.Ensure data warehouse security is designed, developed, implemented and maintained in line with recognised best practice.Monitor and optimise the performance of the data warehouse systems and the accuracy of the reported data. Oversee the disaster recovery environment.Solve complex problems for key service users to deliver business intelligence requirements. Work with requirement owners to define and clearly document business reporting requirements, issues and challenges, including technical implications.Lead on the delivery of integration of information systems into the warehouse from across the NHSBSA, developing plans to replace manual reporting processes within services.Develop clear plans for data warehouse development, mapping out proposed improvements and resources required. Ensure that upgrades and enhancements to the data warehouse and associated software are properly planned and implemented to agreed quality standards.Build business cases to gain approval for data ware house development, to include forecasting costs, resources and timescales.Maintain an understanding of NHSBSA strategic direction, technical capabilities, IT architecture strategy, and business support initiatives.Take responsibility for own professional development and engage in the organisation appraisal system positively to identify personal training and development opportunities.Be a point of expert advice for senior stakeholders on the capabilities and complexities of the data warehouse, and manage expectations over data warehouse deliverables.
In addition to the above accountabilities, as post holder you are expected to:
Undertake additional duties and responsibilities in line with the purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Encourage an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Follow NHSBSA policies, procedures, and protocols as they apply to your role.
Working relationships
Responsible to: Information Standards Manager/ Information Services Manager (Data management and acquisition)
Key relationships and connections:ClientsCustomersStrategic PartnersSenior Managers
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- Expert knowledge of Business Intelligence and Data Warehouse methodology (FACT and Dimensions) and concepts
- Expert knowledge of Oracle OBIEE, including: Answers, BI Admin tool and Web catalog
- Expert knowledge of data warehouse and Weblogic security models
- Excellent understanding of data modelling, report development, performance tuning and query optimisation techniques
- A thorough understanding of databases and data types
- Writing complex functional and technical specifications
- Strong analytical skills with good attention to detail
- Ability to analyse and document business reporting requirements with an understanding of the resulting technical implications
- 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
- Able to direct activity to drive the best outcomes for the business with the resources available
- Able to lead others, including the management of performance and delivery of outcomes, in non-line management relationships
- Able to formulate plans which cover a range of complex activities including target setting and prioritisation of activities
- 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
- Excellent problem solving skills
- Able to understand business processes in the context of using data from business systems
- Fluent and effective communicator at all levels
- Skilled negotiator able to develop relationships and manage stakeholders within IT, the business and IT third parties
- Proactive and personally motivated
- Self-aware, flexible and adaptable
- Accurate with attention to detail
- Commitment to continuing professional development
- Works effectively within a team environment
- Curious nature and effectively dives deep into material
- Focused on delivery
- 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
- Previous significant demonstrable expertise in Business Intelligence, Data modelling and Data Warehouse repositories
- Expert in Oracle database development and experience of working with later versions of Oracle databases to deliver analytics and reporting
- In depth knowledge of creating OBIEE repositories.
- Current expert knowledge and experience of using SQL and PLSQL
- Expertise in writing advanced SQL (Oracle)
- Significant experience of data modelling, report development and query optimisation including star schema design
- Track record of working across an organisation's business applications and databases, extracting and consolidating different data streams
- Experience of ETL development and best practice to deliver optimum performance
- Understanding of available data sources within a business and how these can be extracted and combined for the benefit of the organization
- Experience of requirements gathering and working with stakeholders to establish clear and realistic requirements.
Desirable
- Experience of NHS Information provision, local and national requirements.
- Experience of collating data and writing board reports
- Experience with Oracle Exadata and Exalytics
- Experience operating in an analyst capacity in a technical environment
- Experience of the whole project life-cycle and a structured project management methodology
Qualifications
Essential
- Postgraduate level qualification in a relevant technical discipline or relevant equivalent experience, supported by specialist training and relevant study
Desirable
- Postgraduate degree in computer science with a mathematics or statistics qualification or equivalent
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- Expert knowledge of Business Intelligence and Data Warehouse methodology (FACT and Dimensions) and concepts
- Expert knowledge of Oracle OBIEE, including: Answers, BI Admin tool and Web catalog
- Expert knowledge of data warehouse and Weblogic security models
- Excellent understanding of data modelling, report development, performance tuning and query optimisation techniques
- A thorough understanding of databases and data types
- Writing complex functional and technical specifications
- Strong analytical skills with good attention to detail
- Ability to analyse and document business reporting requirements with an understanding of the resulting technical implications
- 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
- Able to direct activity to drive the best outcomes for the business with the resources available
- Able to lead others, including the management of performance and delivery of outcomes, in non-line management relationships
- Able to formulate plans which cover a range of complex activities including target setting and prioritisation of activities
- 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
- Excellent problem solving skills
- Able to understand business processes in the context of using data from business systems
- Fluent and effective communicator at all levels
- Skilled negotiator able to develop relationships and manage stakeholders within IT, the business and IT third parties
- Proactive and personally motivated
- Self-aware, flexible and adaptable
- Accurate with attention to detail
- Commitment to continuing professional development
- Works effectively within a team environment
- Curious nature and effectively dives deep into material
- Focused on delivery
- 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
- Previous significant demonstrable expertise in Business Intelligence, Data modelling and Data Warehouse repositories
- Expert in Oracle database development and experience of working with later versions of Oracle databases to deliver analytics and reporting
- In depth knowledge of creating OBIEE repositories.
- Current expert knowledge and experience of using SQL and PLSQL
- Expertise in writing advanced SQL (Oracle)
- Significant experience of data modelling, report development and query optimisation including star schema design
- Track record of working across an organisation's business applications and databases, extracting and consolidating different data streams
- Experience of ETL development and best practice to deliver optimum performance
- Understanding of available data sources within a business and how these can be extracted and combined for the benefit of the organization
- Experience of requirements gathering and working with stakeholders to establish clear and realistic requirements.
Desirable
- Experience of NHS Information provision, local and national requirements.
- Experience of collating data and writing board reports
- Experience with Oracle Exadata and Exalytics
- Experience operating in an analyst capacity in a technical environment
- Experience of the whole project life-cycle and a structured project management methodology
Qualifications
Essential
- Postgraduate level qualification in a relevant technical discipline or relevant equivalent experience, supported by specialist training and relevant study
Desirable
- Postgraduate degree in computer science with a mathematics or statistics qualification or equivalent
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).