Marketing Data Engineer: Azure, SQL & Dashboards

The Specialist Works; Greater London; On-site; GBP 60,000 - 95,000; Full time

Benefits offered by this job

9-day fortnight

Growth & wellbeing benefits

Job summary

The Specialist Works is seeking a data engineer to join our fast-moving data activation team. You will own ETL pipelines, ensure data integrity across Azure and Adverity, and write SQL queries to generate reporting outputs.

You will collaborate with head of digital delivery, clients, suppliers to deliver bespoke marketing intelligence. Experience in Python, SQL and cloud services is essential; background in media agency data is highly valued.

Qualifications

• 2-3 years of full-time Python and SQL experience.
• Experience working in a media agency, or with media and marketing data (digital and non-digital).
• Experience and understanding of how APIs extract data from various platforms.
• Experience briefing, designing and implementing ETL solutions end-to-end, from requirements gathering through to deployment.
• Experience with data orchestration tools (e.g. Airflow, Prefect) and building scalable data pipelines.
• Strong Git and collaborative development skills (e.g. GitHub, GitLab).
• Strong understanding of data fundamentals: MDM, data integrity best practices, auditing processes, automated validation.
• Cloud DevOps experience (e.g. Azure, GCP, AWS).
• Strong experience translating business and data needs into technical requirements.
• Ability to communicate technical concepts and requirements in non-technical language.
• Back-end development for visualisation and dashboarding products (Power BI, Tableau, Datorama). Experience with Adverity would be extremely valuable.

Responsibilities

• Own delivery of new and existing ETL pipelines, and data engineering projects for the agency and wider group.
• Work collaboratively with media teams and other business partners to make sure data is available and interpretable across the business.
• Provide client-facing support with onboarding and troubleshooting for our data solutions.
• Help shape the continuing evolution of our data ecosystem, bringing your experience to product design and architecture discussions, and collaborating to suggest, develop, design and write new solutions.
• Own work across various DevOps tasks, managing cloud infrastructure in support of our data solutions.
• Ensure adherence to data governance and data security best practices throughout our ecosystem.
• Be an internal champion for our data solutions, encouraging adoption and supporting smooth implementation.
• Work in a friendly but assertive way with colleagues, suppliers and clients to get things done to our standard.

Skills

Python

SQL

Data engineering

Cloud (Azure, GCP, AWS)

ETL

Data governance

APIs

CI/CD

Version control

Tools

Airflow

Prefect

Power BI

Tableau

Datorama

Adverity

Git

GitHub

GitLab

Azure

GCP

AWS

Job description

The Specialist Works is seeking a data engineer to join our fast-moving data activation team. You will own ETL pipelines, ensure data integrity across Azure and Adverity, and write SQL queries to generate reporting outputs.

You will collaborate with head of digital delivery, clients, suppliers to deliver bespoke marketing intelligence. Experience in Python, SQL and cloud services is essential; background in media agency data is highly valued.