Data Analyst

We are creating a new Data Analyst role to accelerate our digital-first reporting ambitions across the organisation. You will partner with all departments and services to design, build and sustain self-service reporting and automated insight, primarily via Power BI, connected to our operational systems across Microsoft Dynamics 365 (eCase), Finance & Operations (HR System), and Business Central (Finance & Payroll), and integrated with the broader Microsoft 365 / Power Platform suite. Main Duties: o Establish a digital-first reporting structure: define common metrics, data standards, and consistent visuals; create reusable dataflows and certified datasets. o Design and deliver reliable Power BI datasets, models and reports that provide timely, actionable insight for leaders and frontline teams. o Own and evolve core dashboards and reporting pipelines o Connect and integrate data from Dynamics 365, F&O, Business Central, SharePoint/OneDrive and other approved sources o Implement refresh and validation controls. o Automate and orchestrate data processing with Power Query, DAX, and Power Automate o Contribute to lightweight ETL patterns aligned to Kibble's ICT controls. o Enable the organisation by running show-and-tells, producing user guides and delivering training to deliver self-service capability while promoting safe, ethical data use. o Ensure quality and compliance with apply role-based access, least-privilege principles and data protection best practice o Advise and assist with the design and implementation of new datasets and electronic systems, 1. This job outline reflects the main tasks and responsibilities discharged by the postholder at the present time, however, Kibble reserves the right to alter or amend the content of this job outline to reflect changes to the job or services provided, while maintaining the overall character and level of responsibility for the post.

2. Notwithstanding any information or statement described within this job outline, all duties must be carried out in a way that promotes equality of opportunity, dignity, and respect for all individuals and which is consistent with Kibble's stated policy on equal opportunities.
3. The successful candidate will be subject to PVG Scheme Membership. Having previous convictions will not automatically disbar you from working at Kibble (with the exception of offences against children or other vulnerable groups) and every case is taken on an individual basis.
4. Appointments will be subject to a probationary period.

o Proven experience designing, modelling and publishing Power BI solutions (including DAX, Power Query, data modelling, row-level security, refresh). o Hands-on integration experience with Microsoft 365 and Power Platform (e.g., Power Automate, Dataverse, SharePoint). o Working knowledge of Dynamics 365 and Business Central data structures, connectors and APIs. o Competent SQL skills and comfort working with relational data. o Strong stakeholder engagement, with the ability to translate questions into analytical products that influence decisions. Desired: o Experience of Azure data services including Data Factory, Synapse/SQL, Azure Functions or Logic Apps o Experience of Python, R and JavaScript o Data governance experience including cataloguing/lineage, data dictionaries, metadata standards, and GDPR-aware practices. o DevOps & version control experience o Experience of developing user enablement. i.e. creating playbooks, "how-to" videos, and short training sessions o Visualization craft: accessibility, colour-safe palettes, and narrative data storytelling for non-technical audiences. Key Competencies Respectful o Willing to listen and understand others and maintain credibility in your role and for Kibble o Support others and gain trust, positive and enthusiastic o Develop people by helping staff individually and as groups so that they may perform the best they can Essential Responsive o Creative, delivers practical solutions, and flexible to meet others needs o Willing to examine own values, principles, and assumptions. o Learns from own experiences o Motivates others by establishing clear direction and standards; providing opportunities for participation; motivating others by giving encouragement, recognition and personal support for their efforts and achievement Essential Reliable o Well organised, copes well under pressure, takes ownership, proactive and goal focused o Transparent and open, keeps others informed, acts and is sensitive to people's needs o Co-ordinates tasks

Kibble is the specialist provider of services for at risk children and young people across the UK. Many of the young people the organisation cares for have experienced significant trauma in their lives and we provide a safe, stable environment that is both nurturing and therapeutic. With a robust support network and wide range of integrated services, we offer young people opportunities and encourage them to believe in themselves, feel a sense of belonging, and realise their own self-worth.