Essence is a global advertising agency that blends data science, objective media and captivating experiences to build valuable connections between brands and consumers. The agency is more than 1100 people strong, manages over $3B in media spend and deploys campaigns in 71 markets via offices in Chicago, Delhi, London, Los Angeles, New York, San Francisco, Seattle, Singapore, Sydney and Tokyo.

About the role:

This role forms part of a globally distributed business intelligence team, whose objective is to ensure that one of our most important global accounts have access to the right data and insights in order to inform their marketing decisions.

The team's primary responsibility is to maintain a global Google Cloud based reporting solution, which automates the collection and transformation of disparate marketing data into a single source of truth. Not only does that mean running and maintaining the solution that already exists, but also continually improving it to incorporate new data sources, and to derive new insights, to support ever-evolving business demands.

As Data Engineer your primary responsibility will be to support a Senior Data Engineer to create and maintain underlying data infrastructure that provides the wider team with the data they need to provide timely, accurate and meaningful deliverables & reporting. In doing so you will gain a foundational understanding of cloud technology and key data engineering skills and knowledge to help you build a career in this fast evolving, and in demand, industry.

Some of the things we'd like you to do:

• Assist the development of technical solutions, in line with specifications, that collect, store and transform disparate data sources
• Assist the development and maintenance of automated jobs that ensure required data is made available in an efficient and scalable way as possible
• Assist the development and maintenance of data quality checks and procedures, helping account teams overcome data issues before they impact the quality of the reporting solution
• Support the translation of user requirements and business needs into technical specifications
• Become a proficient user of Google Cloud Platform and associated technologies, ensuring your work incorporates industry best practice
• Monitor automated jobs, troubleshooting data issues as-and-when they arise
• Support other members of the team responsible for "last mile" transformation and visualization of data within Google Data Studio reports and dashboards
• Provide hands-on support to users of reportion solutions, helping the wider team triage and respond to user queries in a timely manner
• Attend internal stakeholder meetings, presenting your solutions and providing updates on your work.
• Support the development strong working relationships with third-party data providers that we rely on for access to necessary data
  

Required:

• Previous experience working with data and technology
• Experience with programming and/or statistical languages (e.g. SQL, Python)
• Analytically minded, enabling you to understand and overcome technically complex challenges, and to tell compelling stories with data
• Strong organizational skills and attention to detail, including the ability to manage multiple tasks in a fairly autonomous way
• Strong spoken and written communication skills, ensuring your thoughts and needs are heard and understood
• An ability to demonstrate a passion for the digital marketing ecosystem, and an understanding of the role that data plays within it
• Delivers best results when working in a team environment, and an ability to partner effectively with people of varying degrees of technical capability

• FLEX - WFH
• BUPA
• Pension
• Lots

• 1st Stage - Face to Face (Digital) with Hiring Manager
• 2nd Stage - Technical Assignment/Assessment
• 3rd/Final Stage - Short Face to Face (Digital) with Hiring Manager + 1 Other