Job Description

Data Analyst

PCD270008

Location: Remote (UK) with ad hoc travel to West Midlands
Engagement Type: Contract (6 months)
Day Rate: £500 per day (via Umbrella)
IR35: Via Umbrella (IR35 applies)
Start: ASAP

Position Overview

• Data Analyst required to support a transformation programme modernising data services on AWS within a MACH-aligned architecture.
• Remote-first role, with occasional onsite attendance in the West Midlands for key sessions and delivery checkpoints.
• You’ll help deliver scalable data pipelines, dependable data models and analytics-ready datasets to support domain data services.

What You’ll Deliver

• Scalable ETL/ELT pipelines ingesting data from multiple sources, including RESTful APIs and cloud data stores.
• High-quality data models with clear definitions, strong integrity controls and compliance-ready documentation.
• Profiling outputs, transformation logic, and reconciliation evidence to support migration and ongoing data quality improvement.
• Optimised queries and performant datasets to support reporting and downstream consumption.
• Clear documentation, knowledge transfer material, and continuous improvement recommendations.

Core Activities

• Build and maintain automated data pipelines, using SQL, Python and AWS services to ingest, transform and load data reliably.
• Perform data discovery and profiling to identify gaps, anomalies, duplication and quality issues across source datasets.
• Design and maintain logical and physical models, ensuring consistency, integrity and suitability for operational and reporting use cases.
• Work within an Agile delivery team to support domain data services, collaborating with engineers using Python/Java and AWS tooling.
• Support data migration tasks including mapping, validation, reconciliation, defect triage, cutover preparation and stabilisation.
• Produce reporting datasets and support stakeholders with data interpretation, definitions and data quality insights.
• Improve performance through indexing, query tuning, transformation optimisation and efficient storage/layout strategies.
• Ensure data handling aligns to privacy and security requirements, including access control considerations and audit-friendly artefacts.
• Contribute to documentation, delivery runbooks, training material and ways-of-working improvements.

Experience & Skills Profile

• Strong experience (typically 5+ years) as a Data Analyst or similar, with advanced SQL capability.
• Hands-on AWS experience across data services such as S3, Redshift and RDS, plus relational engines (MySQL, PostgreSQL).
• Strong data modelling capability, including schema design, integrity controls and best practice approaches for analytics datasets.
• Demonstrable performance optimisation experience, including indexing strategies and query tuning for large datasets.
• Proficiency in Python for automation and data processing; working knowledge of Java in engineering delivery contexts.
• Comfortable working in Agile teams, delivering iteratively and collaborating across multi-disciplinary stakeholders.
• Familiarity with MACH principles and how data services support API-first, cloud-native architectures.
• Strong communication and presentation skills, able to explain data issues and insights clearly to varied audiences.

Nice to Have

• AWS certification(s).
• Experience supporting microservices-based data products and API-driven integration.