Salary: £50K -£60K per annum Location: London Experience: 5+ Years Key Responsibilities Design, develop, and maintain robust ETL/ELT data pipelines using Python and PySpark Build and optimize data models and schemas for analytics and reporting Work extensively with Amazon Redshift for data warehousing, performance tuning, and query optimization Develop complex SQL queries for data transformation and analysis Integrate data from multiple sources (batch and streaming) into the data warehouse Ensure data quality, reliability, and scalability of data pipelines Collaborate with analytics, product, and engineering teams to understand data requirements Implement monitoring, logging, and error-handling mechanisms for pipelines Follow best practices for data security, governance, and compliance in AWS Required Skills andamp; Experience Strong experience in Python for data engineering and pipeline development Hands-on experience with PySpark/Apache Spark Advanced proficiency in SQL (query optimization, window functions, CTEs) Experience with AWS data warehousing tools, including:o Amazon Redshift andamp; RDSo AWS Glue, Lambda andamp; Airflowo Amazon S3, EventBridge andamp; Kinesis Solid understanding of data warehousing concepts (star/snowflake schemas, fact/dimension tables) Experience handling large-scale datasets and distributed processing Familiarity with version control systems (Git) Nice to Have Experience with Airflow or other workflow orchestration tools Knowledge of CI/CD ..... full job details .....