Data Engineer

HM Revenue and Customs; London; On-site; GBP 50,000 - 80,000; Full time

Job summary

An opportunity with a leading digital marketing agency in London for a Data Engineer, responsible for designing and building data pipelines that support automated reporting and analytics across various platforms. Candidates should possess strong Python skills and experience with cloud data warehousing and orchestration tools, thriving in a dynamic environment. This role emphasizes the importance of strong communication and problem-solving abilities.

Qualifications

• 3 years of experience in a similar role required.
• Proficient in modern cloud-based data warehousing and pipeline orchestration.
• Experience with advertising data and platform APIs preferred.

Responsibilities

• Design and develop data pipelines for automated reporting and analytics.
• Ensure data structures are efficient and intuitive for users.
• Create technical documentation and train non-technical users.

Skills

Python Development

SQL

Data Modelling

Troubleshooting

Communication

Data Extraction from APIs

Education

Degree in Computer Science or related STEM field

Tools

BigQuery

Airflow

DBT

Git

Terraform

GitHub Actions

Job description

The Media Image is an independent, global and agile full-funnel digital marketing agency. We are award-winning and proven across many markets and serve a broad spectrum of clients across the e-commerce, financial, iGaming, skincare, beauty and online grocery sectors in the US, UK and EMEA regions. We work by the values of Unity, Proactive Partnerships, Inclusive Collaboration, Data-Driven Excellence and Supporting Authenticity. We consider ourselves a market disruptor, providing best-in-class results with a unique approach.

About the Role

This role involves designing and building a unified platform to automate advertising data collection and processing. You will be instrumental in designing, developing and maintaining robust data pipelines that power automated reporting and analytics for advertising performance across multiple platforms and clients. Key responsibilities include data pipeline development, data warehousing & transformation workflow development. This role is ideal for someone with a passion for scalable data architecture, automation and cloud technologies. You will work closely with warehouse users to ensure data structures are intuitive, efficient and aligned with desired use-cases.

Role Requirements

• Degree in Computer Science or another related STEM field.
• 3 years of experience working in a similar role.
• Strong Python development skills, particularly for developing and testing data pipelines.
• Experience with cloud-based data warehousing (BigQuery preferred).
• Hands-on experience with orchestration tools (preferably Airflow).
• Proficient in SQL and data modelling best practices.
• Experience with DBT or other modern data transformation frameworks.
• Ability to use a version control system (e.g. git) for code management and collaboration.
• Proficiency in efficiently extracting data from third-party APIs.
• Strong troubleshooting, documentation and communication skills.
• Experience working with advertising data and platform APIs (Google Ads, Microsoft, Meta, etc.).
• Prior exposure to GCP-specific data tools.
• Experience setting up and maintaining CI/CD pipelines through GitHub Actions or other similar tools.
• Familiarity with Infrastructure as Code (Terraform or similar).
• Experience in building out automated testing suites to ensure proper reliability/functionality of the codebase.
• Experience creating technical documentation and conducting training sessions to help non-technical users adopt tooling.
• Knowledge of securing sensitive data, especially when dealing with third-party APIs.

About you

• Thrive in a dynamic, remote environment.
• High competency in Excel, Word and PowerPoint.
• Take initiative.
• Problem-solving attitude.
• Willingness to learn.
• Strong English communication skills, written and verbal.

Luxembourg Institute of Science and Technology (LIST)