{"interviewQueryText":"What are some good interview questions in British English for the job description below?\n\n-------------------------------------------\n\nBI Project and Provider Collaborative Analyst with Cheshire and Wirral Partnership NHS Foundation Trust in Chester\n\n 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 a Values 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. 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. An applicant guide to help and support you through your recruitment journey can be accessed at the bottom of this page. Further help and support for completing your application can be accessed via our website https://www.cwp.nhs.uk/completing-application-guidance. If you need any further guidance to help you complete your application, contact our recruitment team via email cwp.recruitment@nhs.net or by calling 01244 393100. 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. An exciting opportunity has arisen for a Business Intelligence and Provider Collaborative Analyst to join the Cheshire and Wirral Partnership (CWP) Commissioning Team under the new Lead Provider Collaboratives (LPC); Cheshire and Merseyside CYPMHS Collaborative and the North West Adult Eating Disorder Collaborative. This is an exciting opportunity for a motivated and enthusiastic applicant to lead on data extraction, analytics and scrutiny of people accessing specialised mental health services as part of the LPCs. 50% of this role sits within the Commissioning Team at CWP who are striving to be innovative, collaborative and outcomes focused as a commissioning function and this role provides a cornerstone to achieve this. The other 50% will sit within the Business Intelligence team working on a range of new projects and the continual rollout of PowerBI. You will play a lead role within both the Business Intelligence and LPC teams in relation to data sourcing from the Trusts Enterprise Data Warehouse working closely with the Data Engineering and Modelling to design, develop and support data structures enabling the design and build of technological reporting solutions and visualisations. Educated to degree level with advanced level skills in Microsoft SQL Server RDBMS, advanced level skill in SQL/TSQL and PowerBI. For further details / informal chat contact: Andrew Haws Head of Information Management and Business Intelligence Email - a.haws@nhs.net 01244 393150 Duties: You will play a lead role in building effective relationships within the Trust and LPC and support the development of a continuous improvement culture, through the delivery of high-quality performance data and information. This is an important role, in which you will be responsible for data quality and benchmarking as well as ensuring information is reported accurately, consistently, and effectively for performance reporting and providing information that supports business decisions. You will be involved in analysis, ad hoc reporting, root cause analysis of key issues for the Trust, and production of various performance papers and reports.You will need to have excellent knowledge of data analysis and strong communication and interpersonal skills. You will need to be able to demonstrate proven experience working in an information-related role and in extracting information from a variety of systems. NHS information management experience would be an advantage but is not essential.Experience of using Microsoft SQL Server RDBMS and SQL/TSQL at an advanced level are essential, as well as a strong working knowledge of PowerBI. Experience and knowledge of Microsoft Reporting Services (SSRS) is desirable as well as Data Modelling and Development Lifecycle principle. You will provide information to Executive leads within the organisation consequently, excellent reporting and interpersonal skills are required, as is a professional approach. "}