Back to jobs

Insight Analyst

Manchester, England, United Kingdom

Actively hiring, first seen by us 3 days ago
Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Run stakeholder workshops to define decisions, measures and reporting needs

  • Build Power BI semantic models, dashboards and management reports

  • Design Gold-layer reporting schemas and specify work for Data Engineering

  • Use SQL to investigate data, find trends and exceptions, and test assumptions

  • Reconcile outputs to agreed sources and investigate data quality issues

From the employer’s posting
Lead stakeholder workshops and discovery sessions to understand how different parts of the organisation operate
Use governed datasets to build Power BI semantic models, dashboards and management reports
Design reporting-facing Gold schemas and semantic structures in Fabric
Use SQL to investigate datasets, identify trends and exceptions, answer questions and find issues that need further investigation.
Reconcile outputs to agreed sources, investigate data quality issues

What you’ll bring

All qualifications

Core experience

  • Ability to define measures and business rules and test results against source data.
  • Experience leading stakeholder sessions to elicit requirements, agree measures and present insight.
  • Knowledge of Microsoft Fabric and medallion warehouse and lakehouse architecture, including Bronze, Silver and Gold layers.
  • Experience working with data engineers or platform teams to resolve source and quality issues.
  • Ability to design Gold layer schemas and write clear, testable requirements for Data Engineering.
Qualification wording
Ability to define measures and business rules and test results against source data.
Experience leading stakeholder sessions to elicit requirements, agree measures and present insight.
Knowledge of Microsoft Fabric and medallion warehouse and lakehouse architecture, including Bronze, Silver and Gold layers.
Experience working with data engineers or platform teams to resolve source and quality issues.
Ability to design Gold layer schemas and write clear, testable requirements for Data Engineering.

About City and County Healthcare Group

Through our national network of branches and specialist teams, we help people live independently in their own homes, supporting a range of needs from elderly care to complex health conditions.

In the employer’s words · Read in context

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Oct 8, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

City and County Healthcare Group is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Power BI
Where the posting names them
Analyse and explain - Use SQL to investigate datasets, identify trends and exceptions, answer questions and find issues that need further investigation. - Carry out one-off analysis for projects, investigations and important decisions; test assumptions and provide evidence for recommendations.
Knowledge and Skills - Advanced Power BI skills in semantic modelling, DAX, report design and performance, with SQL proficiency and familiarity with other BI platforms. - Ability to define measures and business rules and test results against source data.
Create management information and reporting - Use governed datasets to build Power BI semantic models, dashboards and management reports, and equivalent outputs in other BI platforms. - Bring together governed information from different systems and databases to give users a clearer view of business performance.
Experience - Extensive hands-on Power BI experience, including dashboards, reports and semantic models. - Experience leading stakeholder sessions to elicit requirements, agree measures and present insight.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

The Insight Analyst combines business analysis of data with the design and delivery of trusted reports and dashboards. The role works with stakeholders to define the decisions they need to make, agree measures and business rules, and turn reliable data into clear reporting and actionable insight.

The role defines the data needed to answer business questions, designs reporting-facing Gold schemas within the organisation’s Microsoft Fabric medallion architecture and gives testable requirements to Data Engineering. Data Engineers build and operate repeatable pipelines and governed datasets. The analyst validates those datasets and turns them into reports and insight, following standards set by the Data Manager and Governance Lead.


This role reports to the Group Data and Governance Manager.

 

Key Duties and Responsibilities

Understand business needs and measures

  • Lead stakeholder workshops and discovery sessions to understand how different parts of the organisation operate and elicit the decisions, questions and measures that reporting must support.
  • Agree consistent definitions, filters and business rules for key measures with data owners so teams work from the same information.
  • Use prototypes, demonstrations and feedback to refine reporting requirements and acceptance criteria.

Create management information and reporting

  • Use governed datasets to build Power BI semantic models, dashboards and management reports, and equivalent outputs in other BI platforms.
  • Bring together governed information from different systems and databases to give users a clearer view of business performance.
  • Identify repetitive spreadsheets and manual reports that can be replaced with reliable, automated reporting.
  • Document reporting logic, data assumptions, refresh behaviour, ownership and limitations; support adoption and appropriate self-service use.

Design reporting data and specify engineering work

  • Design reporting-facing Gold schemas and semantic structures in Fabric, defining the grain, dimensions, measures, relationships and business rules required for reporting.
  • Specify source data, mappings, transformations, quality checks, refresh needs and acceptance criteria for Data Engineering to build repeatable datasets and pipelines; validate delivery against the specification.
  • Work with the technical data team to improve the datasets, structures and processes that underpin business reporting.

Analyse and explain

  • Use SQL to investigate datasets, identify trends and exceptions, answer questions and find issues that need further investigation.
  • Carry out one-off analysis for projects, investigations and important decisions; test assumptions and provide evidence for recommendations.
  • Explain what the numbers show to stakeholders, including uncertainty, limitations and assumptions behind the analysis.
  • Suggest ways the organisation can make better use of its data over time.

Support users and assure quality

  • Respond to business queries about data and reporting, including definitions, discrepancies, report behaviour and access; resolve within the role’s remit or route to the appropriate owner.
  • Reconcile outputs to agreed sources, investigate data quality issues and feed recurring defects or improvements into reporting and engineering backlogs.
  • Apply agreed access, privacy, documentation and reporting standards, and raise risks to the Data Manager and Governance Lead.

Qualifications

Knowledge and Skills

  • Advanced Power BI skills in semantic modelling, DAX, report design and performance, with SQL proficiency and familiarity with other BI platforms.
  • Ability to define measures and business rules and test results against source data.
  • Strong stakeholder skills and confidence leading requirements sessions, challenging assumptions and explaining findings to non-technical audiences.
  • Knowledge of Microsoft Fabric and medallion warehouse and lakehouse architecture, including Bronze, Silver and Gold layers.
  • Ability to design Gold layer schemas and write clear, testable requirements for Data Engineering.

Experience

  • Extensive hands-on Power BI experience, including dashboards, reports and semantic models.
  • Experience leading stakeholder sessions to elicit requirements, agree measures and present insight.
  • Experience working with data engineers or platform teams to resolve source and quality issues.

Qualifications

Relevant data, analytics or business information qualification, or equivalent practical experience.

Additional Information

Why choose us?

We offer thorough training and the opportunity to develop through self-directed learning, coaching conversations, e-learning modules and access to further qualifications and courses. You’ll have the support to develop your career, either within your branch or the wider CCH Group. We’ll also empower you to feel proud of the impactful and meaningful work that you do.

We’ll reward you with a benefits package that includes wellbeing resources, financial advice and up to 14% discount at over 40 retailers including Tesco, John Lewis and many more.

We will also offer you:

  • 22 Days Holiday (increasing to 25 days after 3 years’ service) plus bank holidays and your birthday off!
  • Opportunity  post probation period to buy up to 5 days annual leave at the start of each year
  • Occupational Maternity Pay & Adoption Pay
  • Occupational Paternity Pay*
  • Death in Service Payment*
  • Occupational Sick Pay

*Subject to terms and conditions and qualifying period

We see extraordinary achievements happen every day thanks to the talent and commitment of our people. We want to transform the care industry by working smarter, using innovative tech and driving forward positive change. As the largest care company in the UK, we have the size and success to offer you a world of career opportunity, choice and security. Join us on our journey.

CCH Group is an Equal Opportunities Employer.

Company Description

Insight Analyst
Full-Time / Remote

About CCH Group
CCH Group (City & County Healthcare Group) is one of the UK’s leading providers of community-based social care services. Through our national network of branches and specialist teams, we help people live independently in their own homes, supporting a range of needs from elderly care to complex health conditions. At CCH Group, we are committed to putting care first for both our clients and our teams.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Manchester, England, United Kingdom

Insight Analyst Full-Time / Remote About CCH Group
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.