An exciting opportunity for an experienced Data Engineer to join the Engineering team working within the Digital & Product Department.Location: Chiswick (West London)Work Type: 3 days in office, 2 day from homeSalary: £80k - £100k dependent on experienceThe successful candidate will lead a team of 2 data engineers to design and create scalable data pipelines. This hands-on role involves discussing requirements, designing solutions, and coding to automate data ingestion, cleansing, and transformation.You'll collaborate with Products, Engineering, Data, and Business Analytics teams to understand data requirements and develop integration solutions for necessary migrations. The Data Engineer will support software developers, PowerBI developers, data analysts, and data scientists, ensuring a consistent and optimal data delivery architecture across projects. Self-direction and comfort in supporting multiple teams, systems, and products are essential.DUTIES & RESPONSIBILITIESUnderstand, build and develop ETL and data integration solutions using a wide array of technologies and data sourcesManage and update the Data Engineering ArchitectureAnalyse and organise raw data from different sourcesExplore ways to enhance data quality and reliabilityIdentify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, etc.Work with cloud-based infrastructure (Azure) for hosting data solutions and applicationsCollaborate with architects, data analysts and data scientists to help meet the business goalsSKILLS REQUIRED Previous experience as a data engineer (5+ years)Proven experience in development and maintenance of ETL/ELT processes within a medallion architectureGood experience in Data Modeling within a cloud-based data platformStrong experience with SQL Server and relational databasesGood knowledge of the Azure data engineering stack, including Azure Synapse and Azure Data LakeProgramming experience in Python, PySpark and T-SQLFamiliarity with the wider Azure Data Solutions such as Azure ML StudioPrevious experience with Azure DevOps and understanding of CI/CDAnalytical skills related to working with structured and unstructured datasetsExcellent written and verbal communication skillsExperience supporting and working with cross-functional teams in a dynamic environment