Data Analyst

Working closely with the Head of Analytics and a small technical team, you’ll play a hands-on role in improving the quality, structure and usability of data across the business. Initially, the focus will be on data cleansing, reconciliation and modelling, with opportunities to contribute to forecasting and predictive analytics as the data environment develops., * Data Quality & Remediation: Cleaning, standardising and validating data from multiple source systems, identifying inconsistencies and ensuring information is accurate and reliable.

• Data Modelling: Developing robust analytical data models, including dimensional modelling and star schemas, to support reporting and downstream analytics.
• Identity Resolution: Identifying and reconciling duplicate records across systems, using techniques such as fuzzy matching to create more consistent and reliable datasets.
• Data Warehousing: Supporting the development of the Snowflake data environment, helping ensure data is structured, accessible and ready for analysis.
• Reporting & BI: Building analytical outputs and Power BI dashboards that provide stakeholders with clear visibility of business performance.
• Forecasting & Predictive Analytics: Contributing to models that forecast occupancy, operational performance and resource requirements, helping the business make more informed decisions.
• Advanced Analytics: Supporting emerging initiatives around resident risk modelling, wellbeing indicators and the use of AI to extract structured information from documents.

This is a varied role suited to someone who enjoys getting into the detail of complex datasets, solving data problems and translating analysis into practical business outcomes.

• Strong SQL skills and experience working with complex datasets.
• Proficiency in Python, particularly for analytical modelling and predictive analytics.
• Experience in data cleansing, data quality, reconciliation and standardisation.
• A good understanding of data modelling principles, ideally including star schemas and dimensional modelling.
• Experience with Power BI or similar visualisation tools.
• Exposure to Snowflake or Databricks would be highly advantageous.
• An interest in forecasting, predictive modelling and applying analytics to real-world business challenges.
• A STEM-related degree is essential.

You’ll be curious, pragmatic and comfortable working in a small team where you’ll need to take ownership, get hands-on and contribute across a range of analytical projects.

• Salary of £55,000-£65,000

The business operates a growing portfolio of care homes, supporting residents and their families through high-quality care services. With significant amounts of information held across multiple systems, the organisation is investing in modernising its data environment, improving data quality and creating a more connected view of its operations. The business is transitioning towards a modern data platform using Snowflake, creating opportunities to develop new analytical capabilities, improve reporting and introduce predictive models that support both commercial and operational decisions.