Job Description

Role: Data Analyst

Location: Milton keynes, UK

Mode: Hybrid

Type: Permanent/FTE

:

Key Responsibilities:

Design, develop, and schedule

SQL views

and manage workflow orchestrations (e.g., Airflow DAGs) for reliable, automated execution. Build and maintain

ETL pipelines

using

AWS Glue

to extract data from GCP (BigQuery, GCS) and load into PostgreSQL securely and efficiently. Monitor, troubleshoot, and resolve

pipeline incidents

, performing root cause analysis and documenting resolutions. Architect, develop, and govern

reusable data products

, ensuring FAIR compliance and robust access controls. Translate business requirements into

technical designs

, including data models, architecture diagrams, and specifications. Optimize

ETL pipelines, SQL logic, and workflows

for performance, scalability, and efficiency. Lead migration from

hh360 to BigQuery

, ensuring phased, validated, and seamless data transfer.

Key Skills & Qualifications:

Strong experience in

SQL, Airflow, AWS Glue, BigQuery, GCS, and PostgreSQL

. Proven expertise in

ETL pipeline design, data product creation, and workflow orchestration

. Solid

problem-solving, analytical, and stakeholder management skills

. Experience in

data migration, performance optimization, and governance

.
Job Types: Permanent, Fixed term contract
Contract length: 12 months

Pay: 39,080.65-70,082.04 per year

Experience:

Data transfer from Google Cloud Platform to PostgreSQL: 3 years (required) Develop & Schedule SQL Views via DAGs: 2 years (required) Workflow orchestrations: 2 years (required) Cross?Platform ETL with AWS Glue: 3 years (required) Develop, deploy, and maintain: 3 years (required) Extract data from GCP : 1 year (required) Monitor, Troubleshoot & Resolve Incidents: 3 years (required) Design, Build, & Govern Data Products: 3 years (required) Translate Requirements into Technical Designs: 3 years (required) ETL pipelines, SQL logic, and data workflows: 2 years (required) Lead Migration from hh360 to BigQuery: 3 years (required) * BigQuery: 2 years (required)