Data Engineer – Data & Analysis

Company Description

About Publicis Groupe

Publicis Groupe, known for its world-renowned creativity, best in class technology, digital and consulting expertise, is the world’s third largest communications group in the world. With more than 80,000 people in over 100 countries, the Groupe has four Solution hubs: Creative with Publicis Communications, Media with Publicis Media, Digital business transformation with Publicis Sapient, and Health & Wellbeing with Publicis Health.

Since 2014 and the acquisition of Sapient, Publicis Groupe has undergone a profound transformation by scaling a new model connecting data, creativity and technology. We have continued on that journey with the 2019 acquisition of Epsilon to further scale our data led offering and provide true momentum to our clients own transformation.

This model, with a country led approach, is called the “Power of One” and gathers all the capabilities of the Groupe under one roof, putting clients at the core of the organisation.

It breaks down the silos between Publicis Communications, Publicis Media, Publicis Sapient, and Publicis Health making them work seamlessly and efficiently to help clients transform marketing and business at scale.

Never has our vision and drive for Power of One been as demonstrable as in the role of the Global and Regional Client lead. The Publicis Groupe is a brand led organisation powered by data driven global Practices and has our clients at the absolute core of our business. The role of a RCL is essential for driving growth, for understanding and leading our clients own transformation through delivering the true scale our agencies capabilities. A RCL sets the vision, builds a culture of collaboration and curates a team of experts from our whole Groupe to deliver on that promise. They are true leaders with responsibility for revenue, profitability and leading the relationship with our clients. We could not be more committed to delivering excellence and we articulate our approach to that as the following;

Clients Come First; The entire Publicis Groupe transformation was designed to put clients at the center of all we do. Their needs and objectives drive the solutions we provide in order to help them win and grow.

We are Seamless; We have created the powerful role of the Regional Client Leader. One person who acts as one point of access and one point of accountability to tap an 80,000-deep pool of talent - free from silos, legacy, and convention.

We are Frictionless; We have unified P&Ls and removed all operational barriers that enable true collaboration.

We are Modular; The core benefit of our new organization is not only in the depth and range of capability but, more importantly, in our ability to configure situationally; the ability to configure around individual client needs and an open architecture to plug & play world class partners when needed. Modularity is critical as it enables a future proof way for this organization support innovation now and keep pace the changes that show no sign of stopping.

We are United; By fusing together our creative, intelligence, and technology expertise, we are able to provide clients with transformative ideas and consumer experiences, unlike any other agency or holding company in the marketplace.

Job Description

What you’ll do:

As a Data Engineer, you’ll build the strategic and tactical foundation for data-driven marketing efforts. You’ll work to achieve client goals through proper management and transformation of client data.

Day-to-day, your role includes:

· Assessing, formulating and implement data management framework/solution based on client’s request

· Design database schema to optimized data processing and storage

· Managing existing data pipelines and identify ways to enhance data quality and integrity

· Design and apply privacy and regulatory requirements on PII related data and manage access

· Manage performance and access of database

· Build data models to ensure data validation and clean-up for new data set onboarding

· Manage and enhance Microsoft Azure platform for efficiency in data processing

· Communicating with clients regularly on scheduled deliverables and ad-hoc requests

· Manage operations of scheduled data ingestion and processing

Qualifications

We’re looking for strong, impactful work experience, which typically includes:

· A four-year college degree

· 3-5 years overall experience in data engineering

· At least 3 years of experience with SQL, Data Design, Data Architecture and managing a database

· Hands on experience with managing large data sets and ETL experience

· Experience with designing and rollout of data schema

· Experience working with Microsoft Azure and SQL Workbench

· Good communication skills and able to with internal and external stakeholders at a variety of levels

· Experience with Google Big Query, Google Analytics, Google Tag Manager, Python, SFMC and Javascript is a plus

· Experience working with PII and marketing related data is a plus

· Comfortable in a fast-paced and deadline-driven environment

· Passion for data and technology

Additional Information

Our employee benefits package comprises the following:

👉 Generous leave entitlements, including birthday leave, rest day and family care leave.

👉 Office closure for World Mental Health Day 10th October.

👉 Additional Company closure for all 4 major festive Celebrations

👉 Cashless comprehensive medical coverage, including access to a panel clinic, dental and optical care.

👉 Life and personal accident insurance and group hospitalization and surgery.

👉 A hybrid working schedule and with Friday disconnects.

👉 Rest Relax & Recharge - office closure last week of December every year.

👉 Phone Allowance