Job summary
Business Intelligence Data Analyst Apprentice
Minimum Wage for Age Full time positionFixed Term for 17 Months
An exciting and innovative development opportunity has arisen within the Information Department based at Tameside and Glossop Integrated Care NHS FT which is committed to developing its information capability to help support effective decision making.The goal of the department is to collect and deliver accurate and timely service level analytics Trust-wide and provide actionable information solutions supporting service provision, performance monitoring, service improvement, routine self-service reporting, ad-hoc analysis and statutory reporting.
Main duties of the job
The post of the Business Intelligence Data Analyst Apprentice will embark on a 17-month apprenticeship course learning all the relevant skills to playing a pivotal role to supporting the Trust-wide strategic Data Warehouse and reporting/dashboard solutions in Microsoft Power BI. Reporting to the Head of Business Intelligence and working alongside the Senior Developers you will play a key part in developing, maintaining and extending the current dashboards and self-service reports to meet the detailed and varied information and reporting needs of the organisation.
About us
Tameside and Glossop Integrated Care NHS Foundation Trust serves a community of 250,000 people across Tameside & Glossop. We provide a range of services both within the hospital and across our community for both adults and children.Our vision is to improve health outcomes for our population and influence wider determinants of health through collaboration with our health & care partners.
We have a clear set of values & behaviours which we expect all of our staff to demonstrate:
- Safety
- Care
- Respect
- Communication
- Learning
We believe that the best organisations are those that reflect the communities they serve. We are therefore seeking to improve the diversity of our workforce to make it truly representative of our local population.
We actively encourage applications irrespective of race, age, disability, sex, gender reassignment, gender identity or expression, sexual orientation, religion or belief, marriage & civil partnership, or pregnancy or maternity. Recognising those communities that are underrepresented within our workforce, we would particularly welcome applications from Black, Asian & minority ethnic candidates, LGBTQ+ people & Disabled people.
Benefits include; flexible working, 27-33 days annual leave plus bank holidays, sick pay, NHS Pension Scheme, free eye tests and health checks, gym discount, free bicycle loan scheme, salary sacrifice car scheme, support with stress, bereavement, relationships, finance, and much more.
Job description
Job responsibilities
The successful candidate will need to undertake an apprenticeship programme of study which will be delivered by QA. This is a Level 4 course titled Data Analyst Including Power BI.
This post will be set within the Business Intelligence team, which is part of the Corporate Information Department and will be working collaboratively with other colleagues.
Data Warehouse - Design, code, test and implement efficient T-SQL scripts, Views and Stored Procedures, as part of Data Warehouse development.
- Help support, when necessary the monitoring of performance of the Data Warehouse. Highlight any issues to the Senior BI Developers.
- Developing the Data Warehouse to fulfil the requirements of a Business Intelligence System.
- Ensure all information outputs of the Data Warehouse are accurate, fit for purpose and delivered to the appropriate timescales.
- Ensure that documentation is developed and maintained for the Data Warehouse.
- Working with other aspects of SQL Server namely SSDT and to develop new data sources using Python and maintain existing ones.
Report Developer - Design and develop sophisticated and interactive reports from data held within the various Trust IT systems including the extraction of data from current non-DW systems.
- Provide support in the use of IT systems; undertake data analysis using T-SQL, and develop automated reports using SSRS (SQL Server Reporting Services) and visualisation dashboards using Power BI.
- Develop drill-through reports to meet user requirements to replace (on an automated basis) the need for some existing manual reports.
- Interrogate live information systems as appropriate and maintain and interrogate stand-alone databases for the production of information reports which are not supported by the Trusts PAS
- To ensure thorough documentation and change control processes are in place, accessible and maintained for all processes and developments
Ensure that patient confidentiality is respected by adhering to documented procedures that support the Caldicott principles and the Data Protection Act.
Develop and maintain effective relationships with colleagues across the Trust
Contribute to a strong, motivated and highly-effective Corporate Information Team
Learning is one of our core values and behaviours here at Tameside and Glossop.
Our Education, Training and Development Departments key objectives are to offer both mandatory and essential training and development opportunities for all staff groups. We provide paid mandatory training and a protected training budget with a strong focus on investing in the continued professional development of our colleagues to ensure that they can achieve their full potential.
Upon joining our Trust, all new starters receive a comprehensive induction package. Throughout your employment we provide annual appraisal meetings, regular 1:1s and staff wellbeing conversations to establish with our employees any areas of development.
Our passionate team lead the way in helping staff with further training and career development opportunities within every department and at every level of our organisation. Ensuring you receive the progression opportunities and training you want from your NHS career.
Job description
Job responsibilities
The successful candidate will need to undertake an apprenticeship programme of study which will be delivered by QA. This is a Level 4 course titled Data Analyst Including Power BI.
This post will be set within the Business Intelligence team, which is part of the Corporate Information Department and will be working collaboratively with other colleagues.
Data Warehouse - Design, code, test and implement efficient T-SQL scripts, Views and Stored Procedures, as part of Data Warehouse development.
- Help support, when necessary the monitoring of performance of the Data Warehouse. Highlight any issues to the Senior BI Developers.
- Developing the Data Warehouse to fulfil the requirements of a Business Intelligence System.
- Ensure all information outputs of the Data Warehouse are accurate, fit for purpose and delivered to the appropriate timescales.
- Ensure that documentation is developed and maintained for the Data Warehouse.
- Working with other aspects of SQL Server namely SSDT and to develop new data sources using Python and maintain existing ones.
Report Developer - Design and develop sophisticated and interactive reports from data held within the various Trust IT systems including the extraction of data from current non-DW systems.
- Provide support in the use of IT systems; undertake data analysis using T-SQL, and develop automated reports using SSRS (SQL Server Reporting Services) and visualisation dashboards using Power BI.
- Develop drill-through reports to meet user requirements to replace (on an automated basis) the need for some existing manual reports.
- Interrogate live information systems as appropriate and maintain and interrogate stand-alone databases for the production of information reports which are not supported by the Trusts PAS
- To ensure thorough documentation and change control processes are in place, accessible and maintained for all processes and developments
Ensure that patient confidentiality is respected by adhering to documented procedures that support the Caldicott principles and the Data Protection Act.
Develop and maintain effective relationships with colleagues across the Trust
Contribute to a strong, motivated and highly-effective Corporate Information Team
Learning is one of our core values and behaviours here at Tameside and Glossop.
Our Education, Training and Development Departments key objectives are to offer both mandatory and essential training and development opportunities for all staff groups. We provide paid mandatory training and a protected training budget with a strong focus on investing in the continued professional development of our colleagues to ensure that they can achieve their full potential.
Upon joining our Trust, all new starters receive a comprehensive induction package. Throughout your employment we provide annual appraisal meetings, regular 1:1s and staff wellbeing conversations to establish with our employees any areas of development.
Our passionate team lead the way in helping staff with further training and career development opportunities within every department and at every level of our organisation. Ensuring you receive the progression opportunities and training you want from your NHS career.
Person Specification
Qualifications
Essential
- Level 3 (A-Level) in relevant IT/Computing
- GSCE English and Maths (6 and above) or Level 2 functional skills equivalent
Experience
Essential
- Able to demonstrate a track record of achievement in database and report development
Desirable
- Experience in implementing database solutions
- Experience of setting up, and maintaining old and new extracts into a Data Warehouse
Knowledge
Essential
- Understanding of Business Intelligence dashboard/reporting, and design
- Understanding of GDPR, FOI, Information Governance and Caldicott Guidance
Desirable
- Thorough understanding of NHS performance targets and timescales
- Experience in the use of SQL Server 2016 (including SSDT and SSRS). Proficient use of T-SQL.
- Experience in Microsoft Power Platform and SharePoint
- Microsoft Power BI skills to develop highly sophisticated visualisation reports/dashboards.
- Using Python to develop automated routines to import data from various sources
Skills and Abilities
Essential
- Excellent communication and presentation skills - both oral and in writing
- Strongly pro-active and solution oriented and Technically innovative
- Proven ability to manage and interpret complex numerical data
- Qualities of perseverance, flexibility, determination and adaptability
- Ability to motivate/influence others to achieve.
Person Specification
Qualifications
Essential
- Level 3 (A-Level) in relevant IT/Computing
- GSCE English and Maths (6 and above) or Level 2 functional skills equivalent
Experience
Essential
- Able to demonstrate a track record of achievement in database and report development
Desirable
- Experience in implementing database solutions
- Experience of setting up, and maintaining old and new extracts into a Data Warehouse
Knowledge
Essential
- Understanding of Business Intelligence dashboard/reporting, and design
- Understanding of GDPR, FOI, Information Governance and Caldicott Guidance
Desirable
- Thorough understanding of NHS performance targets and timescales
- Experience in the use of SQL Server 2016 (including SSDT and SSRS). Proficient use of T-SQL.
- Experience in Microsoft Power Platform and SharePoint
- Microsoft Power BI skills to develop highly sophisticated visualisation reports/dashboards.
- Using Python to develop automated routines to import data from various sources
Skills and Abilities
Essential
- Excellent communication and presentation skills - both oral and in writing
- Strongly pro-active and solution oriented and Technically innovative
- Proven ability to manage and interpret complex numerical data
- Qualities of perseverance, flexibility, determination and adaptability
- Ability to motivate/influence others to achieve.
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).
