Data-Driven BI Analyst | Power BI, SQL & Analytics

Hastings Direct; Cardiff; On-site; GBP 42,000 - 64,000; Full time

Benefits offered by this job

Flexible hybrid working

Annual bonus

Life assurance & pension

Mental wellbeing & health programmes

25 days annual leave

Job summary

Hastings Direct, a digital insurance provider in the UK, seeks a data & analytics professional to deliver accurate analysis, dashboards and reports that support underwriting decisions and profitability. You will build Power BI outputs, write SQL, reconcile data sources and translate business questions into actionable insights.

You will collaborate with analysts, data engineers and stakeholders, applying AI responsibly to improve delivery while upholding governance and quality standards.

Qualifications

• Experience delivering analysis, management information, reporting or business intelligence outputs.
• Strong analytical and problem-solving skills, with the curiosity to challenge assumptions and investigate why results have changed.
• Experience writing SQL and working with structured data.
• Experience using a BI or data visualisation tool, preferably Power BI.
• Ability to plan and structure analysis, validate outputs and deliver reliable work independently, while seeking input when risks, assumptions or priorities need clarification.
• Understanding of business KPIs and how analytical measures link to commercial or customer outcomes.
• Clear written and verbal communication, with the ability to explain technical or complex findings to non-technical audiences.
• Good judgement about when to work independently, when to collaborate and when to elevate risks or uncertainties.
• An interest in using AI responsibly to improve analytical delivery; practical experience is beneficial but not essential.

Responsibilities

• Deliver accurate, timely and insightful analysis, reports and dashboards that support underwriting decisions across portfolio performance, profitability, risk and customer outcomes.
• Monitor key performance indicators and profit drivers, identifying trends, risks, opportunities and emerging areas of focus.
• Move beyond reporting the numbers by investigating potential drivers and translating findings into clear, actionable insight.
• Develop, maintain and improve Power BI dashboards and recurring reporting, rationalising and automating outputs where appropriate so they remain relevant, reliable and easy to use.
• Write well-structured SQL and analytical code with clear documentation, reproducible logic and appropriate validation.
• Reconcile data sources and investigate discrepancies to support a consistent and trusted view of performance.
• Work with stakeholders to define requirements and translate business questions into analytical solutions.
• Present complex information in a clear and engaging way, using effective data visualisation and storytelling techniques.
• Use AI and automation responsibly where they improve the quality, speed or accessibility of analysis, while applying appropriate review and validation.
• Contribute to continuous improvement across data quality, reporting processes, analytical methods and team standards.
• Own tasks and deliverables, working autonomously while aligning priorities with team and departmental objectives.
• Collaborate with analysts, data engineers, BI specialists and business stakeholders to deliver effective outcomes.

Skills

Analytical thinking

SQL

Power BI

Data analysis

Communication

KPI understanding

Independent working

AI interest

Job description

Hastings Direct, a digital insurance provider in the UK, seeks a data & analytics professional to deliver accurate analysis, dashboards and reports that support underwriting decisions and profitability. You will build Power BI outputs, write SQL, reconcile data sources and translate business questions into actionable insights.

You will collaborate with analysts, data engineers and stakeholders, applying AI responsibly to improve delivery while upholding governance and quality standards.