BI Supervisor

Job Description

Salary: Competitive starting salaryReference: 036/01/23About UsCity & 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, were 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 RoleThe BI Supervisor will be responsible for direct line management of two FTE involved in the full ETL processes and reporting lifecycle. This role will require working directly with external parties and internal stakeholders to understand data requirementsand reporting needs and translating those into full technical specifications to maintain data cubes and deliver reporting solutions.Key Duties/ResponsibilitiesThe 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 developmentof 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 in Altrincham 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 togrow the business and support your own career development.City and County Healthcare Group is an equal opportunities employer.