Job summary
To be CWP's lead data modeller working in support of the role out of MAST (Management and Supervision Tool) and other Trust initiatives. Working closely with Clinical and Support Services to design, develop and support data structures, data flows and enable the design and build of technological reporting solutions and visualisations.
Using enhanced technical skills to model data enabling the development of clinical and corporate reporting dashboards, to present data as business information that will assist Clinical services in making strategic decisions, and help service managers to manage their services effectively based on the activity recorded in the Trust's clinical and non-clinical based systems which is processed by the data warehouse.
This Post is Fixed term: 12 months
Main duties of the job
Lead the technical design and development of data modelling solutions in support of role out of Management and Supervision Tool and other Trust initiatives, work with wider BI team to ensure that the models are interpreted correctly and built using the most appropriate data sources to reflect business requirements.
Enable the development of clinical and corporate reporting dashboards, to present data as business information that will assist managers in making strategic decisions, and help service managers to manage their services effectively based on the activity reported in the Trust's clinical and non-clinical based systems that is processed by the data warehouse.
Liaise with system expert users to gain understanding of system data and understand best and most appropriate method of data extraction
Liaise with system expert users to understand and agree business rules appropriate for specific solutions.
Create and maintain technical specifications, including source to target mappings, in support of developments which can be interpreted by Data Warehouse developer or 3rd party supplier.
Create and maintain reference data where required utilising process control and master data management principles across current system configurations and future developments
Work with BI team and manage the effective roll-out of reporting visualisations and solutions working within CWP's standard hardware/software offering
About us
CWP provides health and care services for local people, including mental health, learning disability, community physical health and all-age disability care - including the provision of three GP surgeries.
Our aim is to help people to be the best they can be, adopting a compassionate, person-centred approach to everything we do. We were recently rated as Outstanding for Caring by the Care Quality Commission with a Good rating overall.
We offer a variety of roles at all levels, so whether you are just starting out in your career or looking to use your skills and experience in a new role, CWP is the right employer for you.
CWP are committed to making our recruitment practices as inclusive as possible for everyone. We are committed to promoting equality and diversity and developing a culture that values differences.
To support this, we offer up to three weeks induction, dependent on role, with our Prepare to Care programme for all new starters. This aims to give you all the knowledge and guidance to help you grow and flourish with CWP.
We welcome applications from people who have direct experience of accessing our services.
Job description
Job responsibilities
Please download a copy of the job description for full details.
Recruitment selection processes are based on competence (see Person specification) and values.
CWP recruits people that can demonstrate the Trusts Values and Behaviours in their everyday life. Therefore, if you are invited to interview, you will be undertaking aValues Based Interview/Assessment,which explores not only what you do but how and why you do it.
Before applying, we encourage you to review the Trusts Values and Behaviours which are the 6 Cs Communication, Competence, Courage, Care, Compassion and Commitment. A Guide to completing your application form can be accessed on the right side of this page under the job description.
The Supporting Information Section in your application should therefore reflect your understanding of the Trusts Values and associated Behaviours. You will be expected to provide us with examples from work experience and/or personal life which demonstrate these values through your behaviour.
If you have a disability that meets the definition set out in the Equality Act 2010, and you can show that you meet the essential criteria described in the person specification for an available position, please answer YES to the question: Do you wish to be considered under the Guaranteed Interview Scheme?
Please inform the team if you have any special support needs to be considered as part of the interview and selection processes.
CWP is proud to be an accredited Veteran Aware organisation helping to provide and share best practice in NHS care for our armed forces community. As a veteran aware organisation, CWP is committed to delivering on the principles of the Armed Force Covenant and has a Silver award with the MOD Defence Employer Recognition Scheme (DERS).
The trust offers a Guaranteed Interview Scheme to any armed forces community applicants who meet the essential criteria for the post and encourages applications from armed forces reservists or cadet force adult volunteers.
Please note applicants will be required to pay for their DBS check. Costs are deducted from salary following appointment.You are encouraged to enrol for the DBS Update Service. A small annual fee of £13 per year applies.
New entrants to the NHS will commence on the minimum of the scale stated above.
Applicants are advised to apply early as if a large number of applications are received for this post we reserve the right to close the vacancy prior to the advertised date.
If you experience any technical difficulties or need help when making an application please contact our Recruitment Team on 01244 393100.
Good luck with your application. We hope to welcome you to Team CWP very soon.
Job description
Job responsibilities
Please download a copy of the job description for full details.
Recruitment selection processes are based on competence (see Person specification) and values.
CWP recruits people that can demonstrate the Trusts Values and Behaviours in their everyday life. Therefore, if you are invited to interview, you will be undertaking aValues Based Interview/Assessment,which explores not only what you do but how and why you do it.
Before applying, we encourage you to review the Trusts Values and Behaviours which are the 6 Cs Communication, Competence, Courage, Care, Compassion and Commitment. A Guide to completing your application form can be accessed on the right side of this page under the job description.
The Supporting Information Section in your application should therefore reflect your understanding of the Trusts Values and associated Behaviours. You will be expected to provide us with examples from work experience and/or personal life which demonstrate these values through your behaviour.
If you have a disability that meets the definition set out in the Equality Act 2010, and you can show that you meet the essential criteria described in the person specification for an available position, please answer YES to the question: Do you wish to be considered under the Guaranteed Interview Scheme?
Please inform the team if you have any special support needs to be considered as part of the interview and selection processes.
CWP is proud to be an accredited Veteran Aware organisation helping to provide and share best practice in NHS care for our armed forces community. As a veteran aware organisation, CWP is committed to delivering on the principles of the Armed Force Covenant and has a Silver award with the MOD Defence Employer Recognition Scheme (DERS).
The trust offers a Guaranteed Interview Scheme to any armed forces community applicants who meet the essential criteria for the post and encourages applications from armed forces reservists or cadet force adult volunteers.
Please note applicants will be required to pay for their DBS check. Costs are deducted from salary following appointment.You are encouraged to enrol for the DBS Update Service. A small annual fee of £13 per year applies.
New entrants to the NHS will commence on the minimum of the scale stated above.
Applicants are advised to apply early as if a large number of applications are received for this post we reserve the right to close the vacancy prior to the advertised date.
If you experience any technical difficulties or need help when making an application please contact our Recruitment Team on 01244 393100.
Good luck with your application. We hope to welcome you to Team CWP very soon.
Person Specification
Qualifications
Essential
- Educated to degree level in a relevant discipline or equivalent experience
Desirable
- Educated to master's degree level in database theory and design or equivalent experience
- Member of ASSIST, BCS, UKCHIP or other relevant professional body
Knowledge and Expertise
Essential
- Advanced-level skill in Microsoft SQL Server RDBMS
- Advanced-level skill in SQL/TSQL
- Advanced-level skill in SSIS and SSAS
- Knowledge of SSRS
- Advanced keyboard skills
Desirable
- Knowledge of the Data Academy data warehousing tool
- Advanced-level skill in SSRS
- Advanced-level skill in Qlikview / QlikSense
- Knowledge of Data Warehouse Modelling theories.
- Knowledge of development lifecycle
Experience
Essential
- Minimum of 3 years' experience designing, developing and implementing small to medium-sized IT systems.
- Experience of translating business requirements into information/system requirements.
Desirable
- NHS experience working in Informatics, within a Mental Health Trust
- Experience working in a business intelligence environment
Person Specification
Qualifications
Essential
- Educated to degree level in a relevant discipline or equivalent experience
Desirable
- Educated to master's degree level in database theory and design or equivalent experience
- Member of ASSIST, BCS, UKCHIP or other relevant professional body
Knowledge and Expertise
Essential
- Advanced-level skill in Microsoft SQL Server RDBMS
- Advanced-level skill in SQL/TSQL
- Advanced-level skill in SSIS and SSAS
- Knowledge of SSRS
- Advanced keyboard skills
Desirable
- Knowledge of the Data Academy data warehousing tool
- Advanced-level skill in SSRS
- Advanced-level skill in Qlikview / QlikSense
- Knowledge of Data Warehouse Modelling theories.
- Knowledge of development lifecycle
Experience
Essential
- Minimum of 3 years' experience designing, developing and implementing small to medium-sized IT systems.
- Experience of translating business requirements into information/system requirements.
Desirable
- NHS experience working in Informatics, within a Mental Health Trust
- Experience working in a business intelligence environment
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).
