Senior Data Analyst

Role: Data Analyst Location: Milton keynes, UK Mode: Hybrid Type: Permanent/FTE Job Description: 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 contractContract 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)