Senior Data Analyst

• 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.

• 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., * 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)

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

Pay: £39,080.65-£70,082.04 per year