Data analyst - Lorien Impellam

Data Analyst

Location: Edinburgh or Manchester (Hybrid - 1 day onsite per week, Wednesdays)
Type: Contract

Overview

We're looking for a highly data-focused Data Analyst to support the development of data products within a modern AWS-based architecture. This role is centred on deep data analysis and discovery (70%), alongside logical data modelling (30%), helping shape how raw data is standardised, structured, and consumed.

You'll work closely with engineering teams, translating business needs into technical user stories and supporting the evolution of scalable data solutions.

Key Responsibilities

Data Analysis & Discovery (70%)

• Conduct detailed data discovery across multiple datasets, identifying structure, quality, and relationships
• Investigate and interrogate data to uncover insights and anomalies
• Work hands-on with SQL to query and analyse large datasets
• Support data grouping, profiling, and exploration activities
• Collaborate with stakeholders to define data requirements and translate these into actionable outputs
• Contribute to the creation and refinement of data products

Data Modelling (30%)

• Develop and maintain logical data models (LDM)
• Map and align data structures to Federated Data Models (FDM)
• Support data standardisation processes, particularly from raw data sources
• Work closely with architecture and engineering teams on data product architecture
• Ensure consistency and best practice across data modelling and design

Technical Environment & Experience

• Strong SQL skills (essential)
• Experience working with AWS (including S3 buckets)
• Exposure to data product architecture
• Understanding of raw data ingestion and standardisation
• Experience collaborating with data engineering / extract engineering teams
• Ability to write and refine technical user stories

Skills & Profile

• Highly analytical with a strong focus on data investigation and discovery
• Comfortable working in data-heavy, complex environments
• Strong understanding of logical data modelling principles
• Ability to bridge the gap between business needs and technical delivery
• Proactive, detail-oriented, and confident working with ambiguous datasets

Additional Information

• Hybrid working: 1 day per week onsite (Wednesday) in either Edinburgh or Manchester
• Flexible engagement options available
• Fast-paced, delivery-focused environment

Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.