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
#LI-HR1
Inclusion and Impact
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 [email protected] 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.
What We Do
Born to make the best work, brilliantly.
We combine craft insight and technology to bring your creative work to life.
Hogarth was founded 15 years ago and has grown from a start-up to over 6000 people, across 35 cities worldwide and is now part of the WPP family. Our rapid growth continues to drive us forward making Hogarth an exciting place to work and a great place to achieve your career ambitions.
