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