About Us

City & County Healthcare Group is a family of care companies delivering domiciliary care, extra care, complex care and live-in care services across the UK. As an industry leader, we’re bound by a common set of values and principles in providing flexible, community-based care support of the highest standard that actively promotes the independence, dignity and choice for our clients and customers while promoting staff support and development.

The Role

This is a hybrid working role, working from home and spending a few days per month in our Altrincham office.  The BI Supervisor will be responsible for direct line management of three FTE involved in the full ETL process and reporting lifecycle. This role will require working directly with external parties and internal stakeholders to understand data requirements and reporting needs and translating those into full technical specifications to maintain data cubes and deliver reporting solutions.

Key Duties/Responsibilities

The successful candidate will work closely with the Head of Business Intelligence and Reporting to design and implement the BI strategy including running a range of MI/BI and reporting initiatives, running the BAU function, driving change through development of new reporting solutions, and answering all ad-hoc requests, as well as;

Design, develop, implementation and management of current and new ETL processes from various disparate data sources, systems and networks in order to deliver data cubes

Work with key stakeholders to understand business requirements and information needs.

Build, support and develop a BI team to produce high quality insight, analysis and support to the business.

Co-ordinate incoming projects and BAU new and change request to ensure that the team deliver on agreements and provide executive level communication on progress and providing recommendations on next steps

Manage incoming issues escalated from the helpdesk to ensure they are resolved within agreed SLAs

Provide coaching and development opportunities to the team.

Person specification

Expert knowledge of configuring, managing and deploying SQL Server

Export knowledge of workflow/ETL tools, including configuration (e.g., Alteryx, Data Factory)

Export knowledge of visualisation tools (e.g., Tableau, PowerBI)

Working knowledge of MS SharePoint and PowerApps and Dataverse.

Working technical knowledge of financial applications, MIS platforms, web-based applications and mobile device applications

Strong analytical and mathematical skills

Knowledge of software QA and UAT processes

Excellent stakeholder management skills

Excellent SQL and database skills

Strong technical skills to manage databases and reporting tools including configuration and system upgrades (e.g., Alteryx, Tableau, SQL) using manufacturers’ best practice.

Working knowledge of Prince 2 and / or Agile / Scrum Project Management methods

Commercial business acumen to supply effective analysis and recommendations.

Knowledge on designing project plans for system deployment and development

Knowledge of technical documentation methods and processes

Expert level knowledge of MS Excel and other productivity tools

Experience

Management, coaching and development experience of BI/MI teams.

Experience managing software QA and UAT teams and processes

Extensive practical knowledge in importing data and data blending/ manipulation (ETL) for use in reports and visualisations.

Experience with software change management and version control tools

Experience with workflow software (e.g., Alteryx, Data Factory)

Experienced in the design, development and deployment of MI, BI and reporting solutions (e.g., Tableau, PowerBI)

Experience with multiple large databases (structured and unstructured) including transactional replication.

Managing business and change requests.

Experience working on project presentations for external and internal audiences

Providing highly-effective subject matter expertise to both internal and external stakeholders, translating complex data findings into easily consumable stories that drive action

A track record of translating business processes into analytical tasks and initiatives to deliver comprehensive data analysis in complex analytical projects with the ability to communicate results in a clear and concise way                                                                        

This is a full-time permanent position, working from home with occasional days in the office in Altrincham or other office locations for meetings, with a fantastic company that encourages staff to reach their full potential. Continuous training and support will be provided, and you will have a fantastic Senior Management Team to work alongside to grow the business and support your own career development. 

City and County Healthcare Group is an equal opportunities employer