[Hiring] Insight Analyst @City and County Healthcare Group Ltd

Role 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.

• Define the data needed to answer business questions.
• Design reporting-facing Gold schemas within the organisation’s Microsoft Fabric medallion architecture.
• Provide testable requirements to Data Engineering.
• Validate datasets and turn them into reports and insights.
• Follow standards set by the Data Manager and Governance Lead.

Key Duties and Responsibilities

• Understand business needs and measures.
• Lead stakeholder workshops and discovery sessions.
• Agree consistent definitions, filters, and business rules with data owners.
• Use prototypes and feedback to refine reporting requirements.
• Create management information and reporting using governed datasets.
• Build Power BI semantic models, dashboards, and management reports.
• Identify repetitive spreadsheets and manual reports for automation.
• Document reporting logic, data assumptions, and limitations.
• Design reporting data and specify engineering work.
• Specify source data, mappings, transformations, and quality checks.
• Work with the technical data team to improve datasets and processes.
• Use SQL to investigate datasets and identify trends.
• Carry out one-off analysis for projects and important decisions.
• Explain findings to stakeholders, including limitations and assumptions.
• Support users and assure quality by responding to business queries.
• Reconcile outputs to agreed sources and investigate data quality issues.
• Apply access, privacy, documentation, and reporting standards.

Qualifications

• Advanced Power BI skills in semantic modelling, DAX, report design, and performance.
• SQL proficiency and familiarity with other BI platforms.
• Ability to define measures and business rules.
• Strong stakeholder skills and confidence leading requirements sessions.
• Knowledge of Microsoft Fabric and medallion warehouse architecture.
• Ability to design Gold layer schemas and write clear requirements for Data Engineering.
• Extensive hands-on Power BI experience, including dashboards and reports.
• Experience leading stakeholder sessions to elicit requirements.
• Experience working with data engineers or platform teams.
• Relevant data, analytics or business information qualification, or equivalent practical experience.

Benefits

• Thorough training and opportunities for self-directed learning.
• Support for career development within the branch or wider CCH Group.
• Benefits package including wellbeing resources and financial advice.
• Up to 14% discount at over 40 retailers including Tesco and John Lewis.
• 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.
• Occupational Maternity Pay & Adoption Pay.
• Occupational Paternity Pay (subject to terms and conditions).
• Death in Service Payment (subject to terms and conditions).
• Occupational Sick Pay (subject to terms and conditions).