Data Engineer | Fast Growth Digital Media Agency | London

Job DescriptionAbout the jobRole: Data EngineerLocation: London, UK (Hybrid)Harmonic is delighted to partner with a cutting-edge central London fast-growth media agency, in its search for a Data Engineer. They are looking for someone with proven experience in the development, maintenance, and testing of data pipelines and most importantly passionate about all things data!To hit the ground running in this role, you will possess solid data warehousing experience, ideally with cloud-based data storage systems such as Google Cloud Platform (GCP), Azure, or AWS.Imagine being at the forefront of a media revolution, where data is the key to unlocking unprecedented insights.This agency is experiencing explosive growth, and as it accumulates vast amounts of data from diverse sources, the role of Data Engineer becomes absolutely pivotal to its ongoing success.Job Responsibilities:Design, develop, and implement scalable and efficient data pipelines to extract, transform, and load (ETL) data from various sources into the data warehouseCollaborate with cross-functional teams to understand data requirements and ensure the pipelines meet business needsContribute to the construction and optimisation of an Azure-based data warehouse, ensuring it aligns with industry best practices and scalability requirements.Work closely with architects and database administrators to design and implement a robust and scalable data architectureContinuously optimise ETL processes for better performance, efficiency, and reliabilityImplement and maintain data quality checks and validation processes to ensure accuracy and completeness of data within the data warehouseDevelop and execute testing strategies for data pipelines to identify and rectify anomaliesSkills and experience:Proficiency in ETL tools such as Azure Data Factory, Apache NiFi, Talend, or similar tools for designing and managing data pipelinesExperience with Azure SQL Data Warehouse or similar cloud-based data warehousing solutionsKnowledge of data warehousing concepts, star schema, and snowflake schema designStrong programming skills in languages such as Python, SQL, and optionally Java or Scala for scripting and data manipulationHands-on experience with Azure services, including Azure Blob Storage, Azure SQL Database, Azure Databricks, and Azure Data Lake StorageProficiency in working with relational databases (e.g., SQL Server, Azure SQL Database) and understanding of database optimisation techniquesExperience in designing and implementing data modelsSalary: £55,000 - £65,000 + BenefitsInterested? Please get in touch with [email protected]!At Harmonic, we are dedicated to fostering an inclusive and equitable workplace. We actively welcome applications from individuals of all backgrounds and assure you that every candidate will be thoughtfully considered for the roles we represent, without regard to race, religion, gender expression, disability, or sexual orientation.