An exciting opportunity has arisen for a self-starting and enthusiastic individual to join our innovative and fast paced business intelligence team. We are looking to appoint a pro-active and dynamic individual with the confidence to engage with others across all levels of the organisation and wider health economy. Main duties of the job • To support the organisation with analysis and reporting on a wide range of topics and service areas, and to contribute to improving quality in respect of patient activity data that is captured by community services. • To use SQL and other Microsoft tools, to extract data from source systems and the MCH Data Warehouse and to produce analytic reports, visualisations and outline findings on a range of topics. • The post-holder will provide high quality, timely and accurate information to enable Medway Community Healthcare to provide effective patient services. About us So what else? • This is your chance to join a progressive and innovative service in a social enterprise that is patient and staff focused - youll even have the opportunity to become an MCH shareholder. • We encourage staff to get involved in exploring new ways of working and service development. • Well provide well established, in-service training, one to one supervision, and appraisals with regular support. • Youll be able to develop your skills in a friendly and supportive team. Would you like to work flexibly?In the NHS, we are reminded every day of how important work life balance is. As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us, for our patients and for you. Speak to us about how we might be able to accommodate a flexible working arrangement. The small print • Informal visits can be arranged on request. • We will offer you the choice of two pension schemes; the NHS Pension scheme and the scottish widows group pension scheme. • MCH encourages all staff to be double COVID vaccinated to protect themselves, their colleagues, their family and their patients. Job Purpose: • To develop and provide statutory and operational reports as well as wider information and analytical services to clinical services and to senior management • To manage and coach a team of analysts, prioritising workloads autonomously and responsible for meeting reporting deadlines • Key role in developing current and future reporting capabilities including: o Ensuring business intelligence partner is meeting development deadlines o Managing development of new data warehouse o Maximising efficiency and opportunities available through new analytical and reporting tools • To help develop a culture that improves quality in respect of data that is captured by community services • To implement and maintain reporting systems to provide assurance to business units and directorates, committees and the Board. • To make presentations to various staff groups on information management subjects as required. • Post holder will also support and assist in creating and implementing parts of the organisations Digital and Data strategies and delivery of business tools and projects such as capacity planning and local tariffs. Key result areas/Lead Responsibilities: • Day to day management of a team of analysts within the department • Co-ordinating and prioritising the work of the business intelligence team to ensure it meets a range of demanding deadlines for routine and ad hoc reports and data submissions. • Ensure the processes in the business intelligence team are streamlined, efficient, produce quality information and that the team delivers high quality business support to its customers. • Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change or investigation. • Help develop a culture of data quality and data driven decision making. • Advise and support service leads to help improve the accuracy and consistency of their activity recording and minimise data and information gaps. • Ensure appropriate action or escalation when there are persistent quality problems. • Build and maintain good working relationships with internal service leads and commissioning bodies. • Communicate effectively with a range of people with a range of IT knowledge and skill (both verbally and written in the provision of guidance documentation). • Supplier/stakeholder management including providers of business intelligence and data warehousing services. • Keep up-to-date with relevant legislation, policies and procedures, reporting technologies and communicate to relevant parties. • Provide advice on data reporting for tenders, mobilisation of new services and data for service redesign. • Support and assist in yearly contract refresh of activity and capacity planning data. • Lead actions and responses to queries arising from monthly Technical meetings including negotiating on contracted activity targets. • Creating and implementing parts of the organisations Digital and Data strategies and delivery of business tools and projects such as capacity planning and local tariffs. • To provide specialist advice in areas including but not limited to: o Information interpretation o Data analysis o Information reporting • Deputise at meetings, when required, for Associate Director of Business Intelligence Person Specification Qualifications & Experience Essential • Educated to degree level or relevant experience • Excellent IT skills with intermediate level knowledge of excel and Power BI • Knowledge of SQL and coding Desirable • Previous role as an analyst • Experience of SQL coding at intermediate level • Experience using SSRS/SSMS/SSAS Knowledge Essential • Knowledge of NHS data sources and information • Knowledge of NHS data protection and information governance Desirable • Experience working in the public sector, particularly healthcare • Clear understanding of NHS data sources and information flows Experience Essential • Experience of data analysis and manipulation • Experience of use of various IT systems • Experience of improving processed and/or reporting solutions Desirable • Experience using EPR systems • Experience using Power BI Practical and Intellectual skills Essential • Excellent communication and skills and a strong communicator • Ability to manage and prioritise conflicting and demanding workloads and deadlines • Excellent attention to details Desirable • Proactive and solution focused • Flexibility and willingness to perform adhoc duties as and when required to support the wider team • Understand expectations of stakeholders and recognise when issues/events may effect delivery MCH values Essential • Good understanding of MCH valuesd