This role is to support the Head of BI and Analytics, IT colleagues, and other colleagues in delivering our Digital, Data and Technology strategy to radically simplify and support our teams across the organisation by providing insights and trends through data that make their job easier and improve the quality of care we provide.

Key Responsibilities

• Develop dashboards, visualizations, and reports that present complex data in easy-to-understand ways to help stakeholders quickly grasp important trends, insights and performance outliers
• Create and manage data models to ensure the data used in reports and dashboards is accurate, relevant, and structured in a way that supports data analysis
• Oversee the extraction, transformation, and loading (ETL) processes for data from various sources, cleaning and consolidating it into a usable format.
• Work closely with organisational stakeholders to understand their data needs and challenges, helping to gather requirements, providing advice on how data can be used to achieve business objectives, and developing BI solutions to meet those needs.
• Develop or work from agreed specifications and/or directly with users, to create meaningful and usable reports and dashboards
• Assist with the development and delivery of training, ensuring end users understand how to use new tools and resolve any issues they may encounter
• Liaise with internal database and application experts to ensure timely, accurate and complete provision of information
• Ensure the accuracy, completeness, and reliability of the data used for analysis.
• Follow and help implement data governance policies and practices.
• Stay up to date with the latest trends and technologies in BI, data analytics, and data visualisation to improve our BI capabilities continuously.
• Act as a key interface between the IT Team and the wider business
• Act as a champion for IT solutions, helping to drive engagement, adoption, understanding and development of new systems and processes
• Help raise the overall IT and Data Literacy of the organisation
• Identify risks of current processes and find opportunities to improve them

Skills, Experience and Qualifications

• Proven experience as a BI Developer
• Highly skilled in building reports and dashboards in one or more recognized technologies such as (preferred): Power BI including DAX, or SSRS
• Experience in operating in an Azure reporting / Data Warehouse environment
• Experience with ETL tools and processes.
• Experience with Alteryx is desirable but not essential
• Experience in database management and data modeling, with a good knowledge of SQL
• Ability to communicate clearly across a range of stakeholders including technical experts, Senior Management, Group Support teams and non-technical/operational users
• Ability to gather, summarise and disseminate information effectively
• Ability to present information both verbally, visually (for example in presentations) and in written form
• Ability to work with both defined specifications but also with other colleagues collaboratively to define the specification of dashboards, reports and data analyses
• Excellent team-working skills
• Problem-solving mindset
• Determination and tenacity to see things through to completion
• Ability to prioritise and administer multiple competing tasks
• Knowledge of IT systems, architecture and methodologies
• Organised, methodical, thorough and logical approach
• Understanding of GDPR legislation and the UK’s data protection act