Data Engineer (Mid-level)

<div class="content-intro"><p><strong>About WPP Media</strong></p> <p>WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing platform, WPP Open – we help clients navigate change, capture opportunity, and deliver transformational growth. </p> <p>WPP Media is WPP's AI-driven media operating unit, bringing together media, data, and partnerships to deliver creative personalisation at scale. Connected through WPP Open and powered by Open Intelligence, clients see exactly where, how, and why their media investment is working.</p> <p>For more information, visit <a href="wppmedia.com">wppmedia.com</a>.</p></div><p><strong>Job Title:</strong> Data Engineer (Mid-Level)<br><strong>Company:</strong> WPP Media South Africa<br><strong>Location:</strong> Johannesburg, South Africa<br><strong>Reports To:</strong> Senior Data Specialist</p> <p><strong>Key Responsibilites:</strong></p> <p><strong>Data Engineering:</strong></p> <ul> <li>Design, develop and maintain scalable ELT/ETL pipelines using modern cloud technologies.</li> <li>Build and optimise data ingestion frameworks from first-party, second-party and third-party data sources.</li> <li>Develop and maintain robust data models that support analytics and reporting.</li> <li>Build and manage integrations using REST APIs, SDKs and cloud services.</li> <li>Develop reusable data transformation frameworks using dbt or equivalent tooling.</li> <li>Implement incremental processing, partitioning and performance optimisation techniques.</li> <li>Design and maintain data warehouse structures within BigQuery and other cloud environments.</li> <li>Ensure pipeline reliability through monitoring, alerting and automated testing.</li> <li>Troubleshoot production data issues and implement long-term solutions.</li> </ul> <p><strong>&nbsp;</strong><strong>Cloud Platform Engineering</strong></p> <ul> <li>Develop scalable cloud-native data solutions on Google Cloud Platform.</li> <li>Optimise BigQuery performance and manage cloud infrastructure costs.</li> <li>Build solutions using Cloud Functions, Cloud Run, Cloud Storage and Pub/Sub where appropriate.</li> <li>Implement secure access controls using IAM principles.</li> <li>Support infrastructure automation using Infrastructure-as-Code where applicable.</li> <li>Monitor platform performance and recommend improvements.</li> </ul> <p><strong>Data Quality &amp; Governance:</strong></p> <ul> <li>Implement automated data validation and quality assurance processes.</li> <li>Develop and maintain metadata, documentation, and data lineage.</li> <li>Support data governance frameworks and taxonomy standards.</li> <li>Ensure compliance with data privacy, security, and governance policies.</li> <li>Establish monitoring for data freshness, completeness, and accuracy.</li> </ul> <p><strong>Analytics Enablement</strong></p> <ul> <li>Build curated datasets that enable self-service reporting and analytics.</li> <li>Partner with Analytics Engineers, BI Developers and Data Analysts to deliver trusted datasets.</li> <li>Support dashboard development by providing clean, scalable, and well-modelled data.</li> <li>Develop reusable business logic and transformation layers.</li> <li>Assist with complex data investigations and root cause analysis.</li> </ul> <p><strong>Engineering Best Practices</strong></p> <ul> <li>Maintain source control using Git.</li> <li>Participate in code reviews and technical design discussions.</li> <li>Develop technical documentation for pipelines, architecture, and integrations.</li> <li>Contribute to CI/CD deployment processes.</li> <li>Continuously improve engineering standards and platform reliability.</li> <li>Research and evaluate emerging cloud and data engineering technologies.</li> </ul> <p><strong>Collaboration</strong></p> <ul> <li>Work closely with Media, Analytics, Strategy and Technology teams.</li> <li>Collaborate with platform vendors and technology partners.</li> <li>Support junior engineers through knowledge sharing and mentoring.</li> <li>Contribute to continuous improvement initiatives across the data practice.</li> </ul> <p><strong>Minimum Requirements</strong></p> <p>Qualifications</p> <ul> <li>Bachelor's Degree in Computer Science, Information Systems, Engineering, Data Science or a related quantitative discipline.</li> <li>Google Cloud Professional Data Engineer certification (preferred).</li> <li>Additional cloud or data engineering certifications are advantageous.</li> </ul> <p><strong>Experience</strong></p> <ul> <li>3–5 years' experience in Data Engineering or Analytics Engineering.</li> <li>Experience developing cloud-based data platforms.</li> <li>Experience building scalable data pipelines.</li> <li>Experience integrating APIs and third-party platforms.</li> <li>Experience working with modern data warehouses.</li> <li>Experience supporting business intelligence and analytics platforms.</li> <li>Experience within media, marketing technology or digital analytics is advantageous.</li> </ul> <p><strong>Technical Skills</strong></p> <p><strong>Programming</strong></p> <ul> <li>SQL (Advanced)</li> <li>Python</li> <li>REST APIs</li> <li>JSON</li> <li>Git</li> </ul> <p><strong>Data Engineering</strong></p> <ul> <li>dbt</li> <li>ETL / ELT</li> <li>Data Modelling</li> <li>Data Warehousing</li> <li>Incremental Processing</li> <li>Pipeline Orchestration</li> <li>Data Quality Frameworks</li> <li>Identity Resolution concepts</li> </ul> <p><strong>Cloud Platforms</strong></p> <ul> <li>Google Cloud Platform</li> <li>BigQuery</li> <li>Cloud Storage</li> <li>Cloud Functions</li> <li>Cloud Run</li> <li>Pub/Sub</li> <li>Cloud Composer (Airflow)</li> <li>IAM</li> </ul> <p>Advantageous:</p> <ul> <li>Snowflake</li> <li>AWS</li> <li>Azure</li> <li>Terraform</li> <li>Docker</li> </ul> <p><strong>Analytics and BI</strong></p> <ul> <li>Looker</li> <li>Looker Studio</li> <li>Power BI</li> <li>Tableau</li> <li>Google Analytics 4</li> <li>Adobe Analytics (advantageous)</li> </ul> <p><strong>Marketing Technology (Advantageous)</strong></p> <p>Experience integrating or working with data from:</p> <ul> <li>Google Ads</li> <li>Campaign Manager 360</li> <li>DV360</li> <li>Meta Ads</li> <li>TikTok</li> <li>AppsFlyer</li> <li>SA360</li> <li>Adverity</li> </ul> <p><strong>Knowledge</strong></p> <ul> <li>Modern Data Architecture</li> <li>Cloud Computing</li> <li>Data Governance</li> <li>Data Privacy</li> <li>Data Modelling</li> <li>Data Quality</li> <li>Data Observability</li> <li>CI/CD Principles</li> <li>Version Control</li> <li>Cost Optimisation</li> <li>Digital Marketing Ecosystem</li> <li>AI-enabled Data Engineering</li> </ul> <p><strong>Success Measures</strong></p> <p>The successful candidate will:</p> <ul> <li>Deliver reliable, scalable and secure data pipelines.</li> <li>Maintain high levels of data quality and platform reliability.</li> <li>Improve pipeline performance and reduce processing costs.</li> <li>Enable trusted reporting through well-modelled datasets.</li> <li>Deliver production-ready engineering solutions using best practices.</li> <li>Contribute to continuous improvements in the data platform.</li> <li>Produce clear technical documentation and reusable engineering assets.</li> </ul> <p><strong>Behavioural Competencies</strong></p> <ul> <li>Strong analytical thinking</li> <li>Problem solving</li> <li>Attention to detail</li> <li>Curiosity and continuous learning</li> <li>Ownership and accountability</li> <li>Collaboration and communication</li> <li>Adaptability</li> <li>Innovation</li> <li>Mentoring and knowledge sharing</li> </ul> <p><strong>Ideal Candidate</strong></p> <p>The ideal candidate is passionate about building scalable cloud data platforms and solving complex data integration challenges. They have strong SQL and Python skills, experience working with modern cloud technologies, and enjoy developing reliable, maintainable data products that enable analytics across the organisation.</p> <p>They are comfortable working with large-scale datasets, APIs, orchestration tools and cloud infrastructure, while collaborating with analysts, strategists and stakeholders to deliver high-quality data solutions. Experience within marketing technology, digital media or advertising ecosystems is advantageous but not essential.</p><div class="content-conclusion"><p></p> <p><span class="TextRun SCXW227196529 BCX8" lang="EN-CA" data-contrast="auto"><span class="NormalTextRun SCXW227196529 BCX8">Please read our <a href="https://www.wppmedia.com/pages/privacy-policy#:~:text=WPP%20Media%20Privacy%20Notice%20for%20Recruitment">Privacy Notice</a></span></span><span class="TextRun SCXW227196529 BCX8" lang="EN-CA" data-contrast="auto">&nbsp;<span class="NormalTextRun SCXW227196529 BCX8">for more information on how we process the information you provide.</span></span><span class="EOP SCXW227196529 BCX8" data-ccp-props="{&quot;201341983&quot;:0,&quot;335559739&quot;:0,&quot;335559740&quot;:276}">&nbsp;</span></p></div>