About the company
At the Motability Foundation, we fund, support, research and innovate so that all disabled people can make the journeys they choose. We oversee the Motability Scheme and provide grants to help people use it, providing access to transport to hundreds of thousands of people a year. We award grants to other charities and organisations who provide different types of transport, or work towards making transport accessible. We also carry out ongoing research, in partnership with disabled people and key stakeholders, to inspire innovations that continue to champion accessible transport for all.
The Data Services Team helps the Foundation make better use of trusted, governed and accessible data, supporting MI, reporting, insight, governance and delivery of the Foundation’s Data Strategy.
Responsibilities
- Act as the Data Services business partner across the Foundation, collaborating with teams to understand analytical needs, defining requirements and translating business questions into clear analytical approaches
- Design and develop trusted Power BI reports, dashboards, semantic models and reusable datasets, including star schemas, DAX measures, KPIs, calculation logic and documented business rules
- Introduce AI in a practical, responsible and well-governed way, identifying opportunities to improve analysis, automate routine tasks and support better decision-making
- Help establish one version of the truth by creating consistent definitions, trusted measures, governed models and reliable reporting outputs across Data Services
- Use Microsoft Fabric, Power BI and related tools to prepare, model, validate and analyse data, improving data quality, reporting reliability and insight
- Apply statistical, predictive and machine learning techniques where appropriate to identify patterns, forecast trends, support segmentation, evaluate impact and generate practical recommendations
- Train and mentor other members of the Data Services Team in advanced Power BI and the practical use of AI, helping build team capability, confidence and consistent ways of working
- Apply an automation mindset to streamline repeatable reporting, data preparation, validation and analytical processes
- Train and support key stakeholders to use reports and dashboards effectively, helping them interpret outputs, apply filters and use insight confidently in day-to-day decision-making
- Work collaboratively with IT, Insight and Evaluation, Finance, Governance, Data Protection, Change and Transformation, and other teams to deliver joined-up data products and insight
- Define and promote Power BI, data modelling and governance standards, including documentation, validation, accessibility, metadata, lineage, security and appropriate use of sensitive data
Requirements
- Experienced in data science, analytics, business intelligence, data modelling or a similar analytical role
- Highly proficient in Power BI, with extensive hands-on experience designing, building and publishing reports, dashboards, semantic models, reusable datasets, DAX measures, KPIs and calculation logic
- Highly proficient in Power BI data modelling for reporting and analytics, including star schemas, fact and dimension modelling, semantic layer development, performance optimisation and report best practice
- Experience using AI tools or techniques to support analysis, insight generation, automation, data science activity or improved ways of working
- Strong data storytelling skills, with the ability to turn complex analysis into clear narratives, visuals and practical recommendations for different audiences
- Experience analysing complex datasets and applying statistical, predictive or segmentation models to produce practical insight
- Experience using relevant analytical or data science software such as Power Query, Excel or similar tools to clean, transform, analyse and model data
- Experience working with stakeholders to gather requirements, clarify business questions and translate these into analytical outputs
- Good understanding of data quality, validation, documentation, governance, confidentiality and data protection
- Strong written and verbal communication skills, including the ability to explain findings clearly to non-technical audiences
Conditions
- Salary between £55,000 to £61,000 per annum, dependent on experience
- Hours: 37.5 hours per week, Monday to Friday
- Based 3 days a week at our office in Harlow, 2 days a week working from home
- Free minibus service to/from Harlow Town Train Station as well as free parking and EV charging on site