Hogarth is the Global Content Experience Company. Part of WPP, Hogarth partners with one in every two of the world’s top 100 brands including Coca-Cola, Ford, Rolex, Nestlé, Mondelez and Dyson. With a breadth of experience across an extensive range of sectors, Hogarth offers the unrivaled ability to deliver relevant, engaging, and measurable content across all channels and media - both established and emerging. The number of channels at our fingertips; the need for speed; and the drive for mass personalisation, all mean that brands need different solutions.  Our global team of over 7,500 craft and technology experts brings together creative, production and innovation to help clients navigate this exciting and ever-changing world of today’s content experience.

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients and communities. Working at WPP means being part of a global network of more than 100,000 talented people dedicated to doing extraordinary work for our clients. We operate in over 100 countries, with corporate headquarters in New York, London and Singapore. WPP is a world leader in marketing services, with deep AI, data and technology capabilities, global presence and unrivalled creative talent. Our clients include many of the biggest companies and advertisers in the world, including approximately 300 of the Fortune Global 500. Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow.  

Technical skills:

  • Should have 6+ years of hands-on experience in Data engineering
  • Excellent command over ETL tools covering Snowflake, Azure Data Lake, Databricks and Azure Data Factory
  • Good command over writing Python Scripts for custom build data ingestion
  • Proficient in SQL scripts (Stored procedure, Views, Functions, Joins)
  • Experience with Snowflake
  • Experience with DBT (for ETL transformation logic)
  • Experience with FIVETRAN (for data ingestion)
  • Good understanding of data warehouse fundamentals and principles, database modelling knowledge and experience • Experience utilizing data pipelines and connectors across different source systems
  • Experience with cloud data integration tools and services related to Fivetran, DBT or similar data ingestion and data transformation tools
  • Experience working Git version control, preferably GitHub
  • Professional IT related education or equivalent (university) education (e.g., B.E/BTech/MCA/MSC) in a relevant subject, preferably in Computer Science is a preferred
  • Experience working as ETL/ELT developer or a Data engineer

Requirements for the role:

  • Analyse and organize raw data, providing datasets and sources for business reporting requirements
  • Implement data quality rules to enhance data reliability • Understand business needs and objectives
  • Conduct complex data analysis and data modelling, interpreting trends and patterns
  • Collaborate with data scientists and Reporting engineers to help resolve the reporting and Analytics needs
  • Provide expertise and leadership in the development of new products, services, and processes from a Data Engineering technical perspective.
  • Work independently adhering to high technical standards, taking ownership of projects ensuring they conform to departmental standards before going to QA.
  • Work effectively within an agile, deadline-driven production process to complete project development with rapid, iterative cycles.
  • Liaise with Team Leaders, Product and Project Managers to ensure projects are taken from creation to completion - on time and on budget.
  • Provide accurate estimates for existing and new projects alike.
  • Be an integral part of the code review process, providing constructive feedback against code produced by other team members.
  • Ensure good communication is maintained with other team members/departments throughout project life cycles.
  • Write clear, clean, and concise scripts, SQL and transformation logic
  • Fix bugs and transformation problems rapidly
  • Use lateral thinking and investigative techniques to solve challenges across various technical streams.
  • Participate in the ongoing development, adoption and promotion of Data Engineering standards
  • Investigate and participate in discussions with team members about best practices and help identify optimal technical solutions
  • Actively contribute to departmental learning and standards within the team environment through involvement in presentations/demonstrations and participate in the continual drive for collaboration and knowledge sharing amongst the team
  • Keep abreast of the latest trends and emerging technologies within the Data Engineering community and continually develop skill

Impact and Inclusion

WPP is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

Please contact careers@hogarth.com if you need the job advert or form in another format.

Data

We rely on legitimate interest as a legal basis for processing personal information under the GDPR for purposes of recruitment and applications for employment. 

When you click the "Submit Application" button at the bottom of this page, this will send all the information you have added to Hogarth WW. Before you do this, we think it's a good idea to read through our Privacy statement. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.

Apply for this Job

* Required
resume chosen  
Dropbox
(File types: pdf, doc, docx, txt, rtf)
Cancel
cover_letter chosen  
Dropbox
(File types: pdf, doc, docx, txt, rtf)
Cancel
Demographic questions - Philippines

At Hogarth, we are an equal opportunities employer.  We believe in creating a dynamic work environment that values diversity, equity and inclusion.  We strive to recruit from a diverse slate of candidates and foster an environment which provides the right conditions for long term success. We welcome all applications regardless of race, colour, religion or belief, gender, gender identity, age, national origin, marital status, genetic information, sexual orientation and physical or mental disability. 

To help us hold ourselves accountable for progress and monitor our efforts, we invite you to answer the following questions.  You are not required to answer these questions, they are entirely voluntarily and will not be viewable as part of your application or candidate profile.  If you choose to answer, please know that all data is stored separately and used in aggregate for reporting purposes. 

What is your ethnicity? (Select one) *









What is your gender identity? (Select one) *





Do you identify as transgender? (Select one) *



How old are you? (Select one) *








How would you describe your sexual orientation? (Select one) *






What is your religion? (Select one) *









Do you consider yourself to have a long-term health condition, impairment or disability? (Select one) *





Enter the verification code sent to to confirm you are not a robot, then submit your application.

This application was flagged as potential bot traffic. To resubmit your application, turn off any VPNs, clear the browser's cache and cookies, or try another browser. If you still can't submit it, contact our support team through the help center.