Job summary
We are looking for an experienced data warehouse professional to join our team as Data Warehouse Manager. You will lead the development of the next phase of our established data warehouse, and be responsible for its ongoing management and maintenance. As an organised, highly skilled and adaptable individual you will lead a small team of developers and provide technical expertise to the wider Health Informatics team.
This is an exciting opportunity to apply your skills and knowledge to shape the future of the Trust's data environment as we work towards implementing a new EPR system.
Main duties of the job
- Planning, designing and delivering expansions to the existing data warehouse to incorporate new data sources
- Support the implementation of the Trust's new EPR system, through data migration and reconfiguration of the data warehouse
- Support the enhancement of the Trust's BI offering utilising SSAS and Power BI
- Manage and maintain existing data warehouse infrastructure to ensure continuous and reliable information systems availability
- Develop and implement procedures to improve the long term resilience and robustness of the data warehouse
- Provide management and professional leadership to the data warehouse development team
- Act as a technical lead across the Health Informatics department, and assist with support and development issues as required, using high levels of knowledge and experience
About us
Birmingham Women's and Children's NHS Foundation Trust is the first of its type in the UK. Our Trust was formed in February 2017 to drive forward our commitment to provide the highest quality, world-class physical and mental health care for our women, children and families.
Uniting our hospitals means more seamless care; more investment to make greater advances in our specialist treatment and world-leading neo-natal and fetal work. Importantly, it also gives us a greater voice in shaping the future of family-centred care.
Birmingham Children's Hospital is a UK leading specialist paediatric centre with an international reputation in several areas. Birmingham Women's Hospital is one of two dedicated women's hospitals in the UK, with the busiest single site maternity unit, delivering more than 8,200 babies a year offering a full range of gynaecological, maternity and neonatal care. Forward Thinking Birmingham (FTB) Mental Health Services are a unique, innovative community and inpatient mental health partnership. Alongside partners FTB offers care pathways of mental health assessment and treatment for young people aged 0-25 years old.
Our Trust is committed to creating the best place to work. We believe in promoting and enhancing inclusion, diversity and equality and encourage applications from all areas of the community, who meet the criteria for the role, regardless of age, gender identity, disability, race, religion or sexual orientation.
Job description
Job responsibilities
Please refer to the attached job description and person specification to view the full details for this opportunity at Birmingham Womens and Childrens NHS Foundation Trust.
When completing your application, please ensure you have evidenced how you meet the job description and person specification to include transferable experience, qualifications, skills along with professional registration details (if applicable).
Occasionally we receive a large number of applications for our roles and when that happens we sometimes bring the closing date forward, so please apply promptly to avoid disappointment.
Job description
Job responsibilities
Please refer to the attached job description and person specification to view the full details for this opportunity at Birmingham Womens and Childrens NHS Foundation Trust.
When completing your application, please ensure you have evidenced how you meet the job description and person specification to include transferable experience, qualifications, skills along with professional registration details (if applicable).
Occasionally we receive a large number of applications for our roles and when that happens we sometimes bring the closing date forward, so please apply promptly to avoid disappointment.
Person Specification
Qualifications
Essential
- Evidence of continuing professional development
- Degree level qualification or equivalent experience
Desirable
- Postgraduate qualification/training in relevant discipline or equivalent experience.
- Microsoft SQL DbA qualification
Skills, Knowledge and Competencies
Essential
- Advanced user of professional office software, including spreadsheets
- Creative and logical approach to investigating, analysing and solving complex problems
- Ability to understand and interpret highly complex system and data specifications
- Ability to identify, interpret and document complex user information requirements to produce system specifications
- Able to produce clear technical documentation
- Able to communicate effectively with technical and non-technical staff on highly complex subjects where there may be significant barriers to understanding
- Able to relate technical knowledge to real-world activities data is describing Able to supervise and motivate staff
- Advanced keyboard skills
Personal Skills/Abilities and Attributes
Essential
- Manage personal priorities in consultation with line manager
- Manage several strands of work projects simultaneously.
- Deal with and self-prioritise conflicting demands, reviewing and adjusting priorities to meet frequently changing needs.
- Deal with enquiries referring to other members of the team when necessary.
- Initiate and plan statistical work programmes and make adjustments to meet stakeholder requirements.
- Participate in formal objectives setting and performance appraisal process within the organisation.
- Taking a pro-active approach in the formulation of a personal development plan.
- Use a range of communication channels to build relationships, manage barriers to effective communication.
- Use everyday language with non-statistical professionals, taking responsibility for specifying requirements, providing advice and guidance on data and analytical matters; exploring solutions and analyses that are more complex using persuasion to determine the appropriate techniques used.
- Manage expectation; act as the first point of contact for stakeholder queries, escalating to more senior members of the team if appropriate.
- Communicate complex statistical information to stakeholders, which may require persuasive skills.
- Ability to work effectively with in a team.
- Confident, highly motivated and able to use own initiative.
- Ability to resolve problems effectively
- Significant attention to detail, given the nature of the role including the development of own software and data driven applications so need advanced concentration and highly developed analytical skills with a drive for accuracy
- A demonstrable understanding of equality, diversity and inclusion with evidence of personal impact in these areas
- Ability to travel across sites as required
Desirable
- Develop own skills and knowledge and provide information to others to help their development;
- Seek feedback from others about work to help identify own development needs to offer feedback promptly.
- Evaluate effectiveness of own learning/development opportunities and relate this to others.
- Identify development needs for own emerging work demands and future career aspiration.
- Offer help and guidance to others to support their development or to help complete their work requirements effectively.
- Coaching and skills transfer; communicate highly complex statistical matters with other statistical professionals.
- Keep abreast of related national information developments as part of continuous professional development
- Line Management and Team Development
- Conscientious and proven team worker with the ability to engage with people at all levels.
- Responsible for staff development through 1:1 training and supporting training sessions.
- Supervise trainee analysts or new colleagues offering advice and training on specialist health information management training including statistical analysis and concepts when required.
- Responsible for prioritising and allocating core and additional requests (within available resources) for analysis across team members.
Experience
Essential
- Highly developed specialist knowledge of business intelligence and data warehouse development, supported by significant relevant practical experience in developing and managing complex or large-scale data management functionality
- Clear understanding and detailed working knowledge of data structures and data warehousing techniques
- Demonstrable and substantial experience of writing and using complex T-SQL or SQL code in a practical setting
- Detailed working knowledge of MS SQL Server, including Integration, Analysis and Reporting Services (SSIS / SSAS / SSRS)
- Significant practical experience of using Microsoft Power BI or equivalent BI package
- Practical understanding of data security, data protection and confidentiality issues.
- Experience of using and adapting to a range of systems development tools.
- Experience of the full software development life cycle
- Systems development project planning
- Sound current technical appreciation of web technologies and application development tools and techniques
Desirable
- DAX/M/MDX programming skills
- Experience with the .NET Framework
- Skills in HTML, DHTML, JavaScript, Active Server Pages and CSS
- Experience with Cloud based technology (e.g. Azure)
Person Specification
Qualifications
Essential
- Evidence of continuing professional development
- Degree level qualification or equivalent experience
Desirable
- Postgraduate qualification/training in relevant discipline or equivalent experience.
- Microsoft SQL DbA qualification
Skills, Knowledge and Competencies
Essential
- Advanced user of professional office software, including spreadsheets
- Creative and logical approach to investigating, analysing and solving complex problems
- Ability to understand and interpret highly complex system and data specifications
- Ability to identify, interpret and document complex user information requirements to produce system specifications
- Able to produce clear technical documentation
- Able to communicate effectively with technical and non-technical staff on highly complex subjects where there may be significant barriers to understanding
- Able to relate technical knowledge to real-world activities data is describing Able to supervise and motivate staff
- Advanced keyboard skills
Personal Skills/Abilities and Attributes
Essential
- Manage personal priorities in consultation with line manager
- Manage several strands of work projects simultaneously.
- Deal with and self-prioritise conflicting demands, reviewing and adjusting priorities to meet frequently changing needs.
- Deal with enquiries referring to other members of the team when necessary.
- Initiate and plan statistical work programmes and make adjustments to meet stakeholder requirements.
- Participate in formal objectives setting and performance appraisal process within the organisation.
- Taking a pro-active approach in the formulation of a personal development plan.
- Use a range of communication channels to build relationships, manage barriers to effective communication.
- Use everyday language with non-statistical professionals, taking responsibility for specifying requirements, providing advice and guidance on data and analytical matters; exploring solutions and analyses that are more complex using persuasion to determine the appropriate techniques used.
- Manage expectation; act as the first point of contact for stakeholder queries, escalating to more senior members of the team if appropriate.
- Communicate complex statistical information to stakeholders, which may require persuasive skills.
- Ability to work effectively with in a team.
- Confident, highly motivated and able to use own initiative.
- Ability to resolve problems effectively
- Significant attention to detail, given the nature of the role including the development of own software and data driven applications so need advanced concentration and highly developed analytical skills with a drive for accuracy
- A demonstrable understanding of equality, diversity and inclusion with evidence of personal impact in these areas
- Ability to travel across sites as required
Desirable
- Develop own skills and knowledge and provide information to others to help their development;
- Seek feedback from others about work to help identify own development needs to offer feedback promptly.
- Evaluate effectiveness of own learning/development opportunities and relate this to others.
- Identify development needs for own emerging work demands and future career aspiration.
- Offer help and guidance to others to support their development or to help complete their work requirements effectively.
- Coaching and skills transfer; communicate highly complex statistical matters with other statistical professionals.
- Keep abreast of related national information developments as part of continuous professional development
- Line Management and Team Development
- Conscientious and proven team worker with the ability to engage with people at all levels.
- Responsible for staff development through 1:1 training and supporting training sessions.
- Supervise trainee analysts or new colleagues offering advice and training on specialist health information management training including statistical analysis and concepts when required.
- Responsible for prioritising and allocating core and additional requests (within available resources) for analysis across team members.
Experience
Essential
- Highly developed specialist knowledge of business intelligence and data warehouse development, supported by significant relevant practical experience in developing and managing complex or large-scale data management functionality
- Clear understanding and detailed working knowledge of data structures and data warehousing techniques
- Demonstrable and substantial experience of writing and using complex T-SQL or SQL code in a practical setting
- Detailed working knowledge of MS SQL Server, including Integration, Analysis and Reporting Services (SSIS / SSAS / SSRS)
- Significant practical experience of using Microsoft Power BI or equivalent BI package
- Practical understanding of data security, data protection and confidentiality issues.
- Experience of using and adapting to a range of systems development tools.
- Experience of the full software development life cycle
- Systems development project planning
- Sound current technical appreciation of web technologies and application development tools and techniques
Desirable
- DAX/M/MDX programming skills
- Experience with the .NET Framework
- Skills in HTML, DHTML, JavaScript, Active Server Pages and CSS
- Experience with Cloud based technology (e.g. Azure)
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
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).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
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).
Employer details
Employer name
Birmingham Women's and Children's NHS Foundation Trust
Address
Women’s site, Children’s site, Home Working
Birmingham
B15 2SQ
Employer's website
https://bwc.nhs.uk/ (Opens in a new tab)
.png){kind=logo}
