Job summary
Are you a data enthusiast with the skill to find solutions? Do you thrive in a role that can make a real difference? If so, we at the NHS Business Services Authority (NHSBSA) have the perfect opportunity for you! We're on the lookout for a Data Warehouse ETL 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 skilled in database and data warehouse technologies? Do you have knowledge of ETL processing and database design? If so, you're just what we need! You'll join our Data Warehouse team, handling the development, testing, and productionisation of ETL processes 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 do we offer?
- 27 days leave (increasing with length of service) plus 8 bank holidays
- Flexible working (we're happy to discuss options such as compressed hours)
- Flexi time
- Hybrid working model (we're 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
As a key member of our team, you'll support the sourcing, extracting, transforming, loading, and providing access for data within the NHSBSA's data warehouse(s). You'll use your expertise to provide highly complex data to drive the development of business intelligence and insight. You'll be an expert in data from within the NHSBSA and will liaise with data experts from partner organisations.
You'll provide expertise and specialist advice to IT and business service colleagues to ensure data are extracted from a wide range of business systems and transformed for loading in the data warehouse. You'll advise, and develop plans, with project and data analytics teams to deliver data requirements to improve information, data analysis and reporting. You'll investigate and resolve data issues and anomalies between data sets.
You'll develop and deliver plans to manage appropriate access to data within the data warehouse and data analytics environments so that data security and integrity are maintained. You'll use a range of manual and automated data movement tools and techniques and will work with very large datasets containing data which contains highly sensitive information.
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:1. Provide expertise in making available, integrating, and optimising structured and/or unstructured data using database products,technologies, and methods.2. Provide expertise in refining and transforming data.3. Provide and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing andworking with these data sets are understood by users before permitting access to the data in the warehouse.4. Liaise with Senior Managers and strategic partners to gain access to data and provide assurance that data is appropriately controlled withinthe NHSBSA data warehouse.5. Contribute to and review policies and procedures for data access, identifying and implementing improvements ensuring data security andintegrity at all times.6. Agree priorities for bringing in data and develop plans with project managers to ensure that when data are changed as a result of businesssystem changes, the changes can also be implemented in the data warehouse.7. Responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, havebeen tested by approving test plans and reviewing results of testing. Coordinate work with testers.8. Prepare and update technical documentation for the data entering the data warehouse. Ensure that physical data are reviewed for updatesto data dictionaries and gaps in metadata are rectified.9. Analyse, investigate and resolve complex queries to identify data trends and quality issues. Share information with IT managers, informationgovernance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes ofdata issues. Recommend improvements to data management.10. Responsible for positively achieving team and personal objectives in accordance with business plan and strategic direction.11. Coordinate work with the team that manages access to the information reports and reporting tools available from the data warehouse forexternal users.12. Responsible for reviewing and assisting with updates to the ETL technical products, making recommendations for replacement of datawarehouse technology.In addition to the above accountabilities, as post holder you are expected to:Undertake additional duties and responsibilities in line with the overall purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Foster an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Comply with NHSBSA policies, procedures and protocols as they apply to your role.Working relationshipsResponsible to: Data Warehouse & BI Manager / Data Warehouse Lead Architect / Data Warehouse BI DeveloperKey relationships and connections: Data management and acquisition team, Customers, Strategic Partners, Senior Managers
Job description
Job responsibilities
In this role, you are accountable for:1. Provide expertise in making available, integrating, and optimising structured and/or unstructured data using database products,technologies, and methods.2. Provide expertise in refining and transforming data.3. Provide and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing andworking with these data sets are understood by users before permitting access to the data in the warehouse.4. Liaise with Senior Managers and strategic partners to gain access to data and provide assurance that data is appropriately controlled withinthe NHSBSA data warehouse.5. Contribute to and review policies and procedures for data access, identifying and implementing improvements ensuring data security andintegrity at all times.6. Agree priorities for bringing in data and develop plans with project managers to ensure that when data are changed as a result of businesssystem changes, the changes can also be implemented in the data warehouse.7. Responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, havebeen tested by approving test plans and reviewing results of testing. Coordinate work with testers.8. Prepare and update technical documentation for the data entering the data warehouse. Ensure that physical data are reviewed for updatesto data dictionaries and gaps in metadata are rectified.9. Analyse, investigate and resolve complex queries to identify data trends and quality issues. Share information with IT managers, informationgovernance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes ofdata issues. Recommend improvements to data management.10. Responsible for positively achieving team and personal objectives in accordance with business plan and strategic direction.11. Coordinate work with the team that manages access to the information reports and reporting tools available from the data warehouse forexternal users.12. Responsible for reviewing and assisting with updates to the ETL technical products, making recommendations for replacement of datawarehouse technology.In addition to the above accountabilities, as post holder you are expected to:Undertake additional duties and responsibilities in line with the overall purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Foster an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Comply with NHSBSA policies, procedures and protocols as they apply to your role.Working relationshipsResponsible to: Data Warehouse & BI Manager / Data Warehouse Lead Architect / Data Warehouse BI DeveloperKey relationships and connections: Data management and acquisition team, Customers, Strategic Partners, Senior Managers
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- Knowledge of Oracle data types and Data Definition Language (DDL)
- SQL skills
- Scripting
- UNIX - Linux/Solaris
- Data governance and data quality
- Extract, Transform and Loading of large datasets
- Oracle database privileges
- Oracle Datapump and SQLLoader
- Able to formulate plans which cover a range of activities including prioritisation of activities
- Able to concentrate using discretion in decision making activities
- Confident at presenting information
- Able to communicate complicated issues in a clear manner to individuals at all levels of the organisation
- Excellent problem solving skills
- Sound analytical ability
- Attention to detail
- An attitude to get things done with speed and effectiveness
- A self-starter who enjoys finding solutions that combine multiple tools and skills sets
- Proactive and personally motivated
- Self-aware, flexible and adaptable
- Commitment to continuing professional development
- Enjoys working as part of a team
Desirable
- Oracle RDBMS objects
- Oracle Developer
- SQLServer, DB2, UDB
- Encryption and pseudonymisation techniques
- Managing data in Oracle Endeca
- Creation and Maintenance of a Data Dictionary
- Able to learn new technologies and quickly grasp complex problems
- Curious nature and effectively dives deep into material
Experience
Essential
- Understand of ETL technology
- Working with large and complex datasets
- Manipulating and loading large datasets
- Programming skills related to data manipulations within a database environment
- Preparing and reviewing policies e.g. for data access
- Identifying, planning and prioritising changes
- Reviewing and maintaining technical documentation
Desirable
- Working with Oracle Exadata or Exalytics
- Experience of using machine learning
- Data analysis to provide business intelligence
Qualifications
Essential
- IT related Degree or a subject requiring high levels of numeracy plus significant demonstrable experience developing and/or supporting IT systems
Desirable
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- Knowledge of Oracle data types and Data Definition Language (DDL)
- SQL skills
- Scripting
- UNIX - Linux/Solaris
- Data governance and data quality
- Extract, Transform and Loading of large datasets
- Oracle database privileges
- Oracle Datapump and SQLLoader
- Able to formulate plans which cover a range of activities including prioritisation of activities
- Able to concentrate using discretion in decision making activities
- Confident at presenting information
- Able to communicate complicated issues in a clear manner to individuals at all levels of the organisation
- Excellent problem solving skills
- Sound analytical ability
- Attention to detail
- An attitude to get things done with speed and effectiveness
- A self-starter who enjoys finding solutions that combine multiple tools and skills sets
- Proactive and personally motivated
- Self-aware, flexible and adaptable
- Commitment to continuing professional development
- Enjoys working as part of a team
Desirable
- Oracle RDBMS objects
- Oracle Developer
- SQLServer, DB2, UDB
- Encryption and pseudonymisation techniques
- Managing data in Oracle Endeca
- Creation and Maintenance of a Data Dictionary
- Able to learn new technologies and quickly grasp complex problems
- Curious nature and effectively dives deep into material
Experience
Essential
- Understand of ETL technology
- Working with large and complex datasets
- Manipulating and loading large datasets
- Programming skills related to data manipulations within a database environment
- Preparing and reviewing policies e.g. for data access
- Identifying, planning and prioritising changes
- Reviewing and maintaining technical documentation
Desirable
- Working with Oracle Exadata or Exalytics
- Experience of using machine learning
- Data analysis to provide business intelligence
Qualifications
Essential
- IT related Degree or a subject requiring high levels of numeracy plus significant demonstrable experience developing and/or supporting IT systems
Desirable
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).
