Insight Analyst

Harnham; Leicester; On-site; GBP 30,000 - 50,000; Full time

Job summary

A major UK retail organisation is seeking an Insight Analyst to join their Finance Analytics function. The role involves modernising data infrastructure and delivering insights through data modelling, SQL, and analytics engineering. Responsibilities include designing data models, optimizing SQL queries, and building Power BI dashboards. Candidates should have strong stakeholder engagement skills and be comfortable in a fast-paced environment. Experience with Databricks and Python for data analysis is preferred.

Qualifications

• Hands-on experience in data modelling and analytics engineering.
• Proficient in SQL for data extraction and transformation.
• Ability to build and maintain dashboards in Power BI.

Responsibilities

• Design and develop robust data models using Databricks.
• Write and optimise complex SQL queries for data validation.
• Build and maintain Power BI dashboards for finance reporting.
• Use Python for analysis and data profiling.
• Translate business requirements into actionable insights.
• Implement data quality checks for reliability.
• Support self-service analytics and data literacy.

Skills

Data modelling

SQL

Analytics engineering

Databricks

Power BI

Python (Pandas/Numpy)

Stakeholder engagement

Data analysis

Job description

This is an opportunity to join a major UK retail organisation undergoing a significant transformation of its finance data landscape; sitting within a high-impact Finance Analytics function, you’ll work on modernising data infrastructure and delivering insight across core operational areas. You’ll be part of a collaborative team working closely with both Finance and Analytics, helping to shape how data is structured, accessed, and used across the business

THE ROLE

This is a hands-on Insight Analyst role with a strong focus on data modelling, SQL, and analytics engineering principles. You’ll act as a key builder of analytical datasets, working within a modern data stack (including Databricks) to deliver clean, reliable data for reporting and insight generation. Alongside this, you’ll support finance teams by analysing trends, identifying opportunities, and helping stakeholders make better decisions

Key Responsibilities:

• Design and develop robust data models using Databricks (Medallion Architecture)
• Write and optimise complex SQL queries for data extraction, transformation, and validation
• Build and maintain Power BI dashboards to support finance reporting
• Use Python (Pandas/Numpy) for deeper analysis, automation, and data profiling
• Translate business requirements into analytical outputs and actionable insights
• Implement data quality checks to ensure accuracy and reliability
• Support the move toward self-service analytics and improved data literacy

YOUR SKILLS & EXPERIENCE

• Databricks (preferable, not essential)
• Strong stakeholder engagement and communication skills
• Comfortable working in a fast-paced, evolving environment