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 6,000 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.

Technical skills:

• 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

#LI-HR1

Diversity & Inclusion

Hogarth is an equal-opportunity employer. That means we believe in creating a truly inclusive culture that values diversity, equity and inclusion for everyone through our ideas, our people, how we behave and how we conduct ourselves.  We strive to recruit people from diverse backgrounds and support them to achieve long-term success. This not only makes Hogarth a better company and place to work, but an environment where everyone can give their point of view, experience connection, enjoy opportunity and feel a sense of belonging. 

We welcome applications from everyone, regardless of race, ethnicity, religion or belief, gender, gender identity, age, national origin, marital status, military veteran status, genetic information, sexual orientation, or physical or mental disability. As part of our commitment to making our hiring processes as equitable as possible, we are currently rolling out a policy which ensures that hiring managers review CVs only after they have been processed through an automated anonymisation system. This aims to ensure that all candidates are considered for interview based solely on their experience and what they can bring to the role. The solution, provided by MeVitae, scans and redacts CVs to reduce potential reviewer bias.

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

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.