Data Analyst

Norton Blake; London; On-site; GBP 35,000 - 55,000; Full time

Job summary

A leading company is seeking a Data Analyst to enhance their data assets from their locations in Hoddesdon or Farringdon. You will design and maintain data warehouses while collaborating with teams to meet business needs. This role requires strong technical expertise in data transformation and modeling, with a supportive environment offering a competitive benefits package.

Benefits

Generous annual leave including an extra day off on your birthday

Private medical insurance

Pension scheme and life assurance

Cycle to Work scheme

Discounts on shopping and dining

Ongoing training and skills development

Enhanced family-friendly policies

24/7 Virtual GP and Employee Assistance Programme

Physical, mental, and financial wellbeing support

Qualifications

• Experience as a Data Analyst in Azure environment.
• Hands-on with Power BI and data modelling.
• Ability to work with stakeholders on data needs.

Responsibilities

• Design and maintain data warehouses and semantic models using SSMS and Power BI.
• Translate business requirements into data models.
• Ensure data model integrity and performance.

Skills

Data Transformation

Data Modelling

SQL Server Management Studio

Power BI

Education

Degree in a relevant field

Tools

Power BI

Azure

Job description

Data Analyst

Overview

We are seeking a skilled and proactive Data Analyst to manage and enhance data assets within our presentational layer.

This role is central to the maintenance and development of our data warehouse and the creation of effective data marts and semantic models that support reporting and business intelligence.

Based in either Hoddesdon or Farringdon, this position requires strong technical expertise in data transformation, data modelling, and warehouse development, alongside the ability to collaborate with cross-functional teams and communicate clearly.

Key Responsibilities:

• Design, develop, and maintain scalable and efficient data warehouses, data marts, and semantic models using SQL Server Management Studio (SSMS) and Power BI
• Work closely with internal teams to understand business requirements and translate them into data models
• Validate data models through Power BI reports and support data quality initiatives
• Apply a deep understanding of business logic to develop meaningful and reliable data structures
• Monitor performance, identify and resolve issues, and ensure ongoing reliability and integrity of data models

About You

• Proven experience as a Data Analyst within an Azure environment in a medium or large organisation
• Strong knowledge of data transformation, modelling principles, and data warehouse/mart architecture
• Hands-on experience with Power BI and semantic model development
• Ability to work effectively with stakeholders and understand their data needs
• Degree in a relevant field or equivalent professional experience
• Azure data certifications are desirable but not essential

What We Offer

We offer a supportive and forward-thinking work environment, along with a competitive benefits package designed to recognise and reward your contribution:

• Competitive salary
• Generous annual leave, including an extra day off on your birthday
• Private medical insurance
• Pension scheme and life assurance
• Cycle to Work scheme
• Discounts on shopping, dining, and more
• Ongoing training and skills development opportunities
• Enhanced family-friendly policies
• 24/7 Virtual GP and Employee Assistance Programme
• Physical, mental, and financial wellbeing support