Lorien
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.
To apply for this job please visit www.reed.co.uk.
Make this application stronger
Use these quick checks before applying so your CV, interview preparation and job search are better matched to this vacancy.
Before you apply
Check the key details and make sure the role matches what you are looking for.
- Review the job title, company, location, salary and working pattern if provided.
- Check the skills, experience or qualifications requested by the employer.
- Make sure the commute, hours and contract type are realistic for you.
Tailor your CV
For IT Jobs, highlight the most relevant skills, experience and achievements linked to this type of work. Keep it honest, clear and focused on what the employer is asking for.
Use the CV Builder or browse Career Advice.
Prepare for interview
If your application is successful, prepare simple examples that show your motivation, strengths and suitability.
Keep searching smarter
Do not rely on one application. Keep searching similar roles and set up alerts so new vacancies reach you faster.