Senior Data Engineer

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

Data Engineer – Data & Analysis

Digitas is a highly-caffeinated playground where brilliant minds come together to bring bold, award-winning ideas to life.

The Data & Analysis team uses data-driven insights to fuel strategic growth for clients. We believe that data should never exist in a vacuum; instead, it should be put to work to bring the best ideas and stories to our clients.

To help with this, we’re looking for an outstanding Data Engineer, someone who can analyze and process large data sets to enable analytical usage of data. Sound like you? Read on.

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 optimize data processing and storage.

· Build, manage and schedule existing data pipelines, trigger & validate successful/failed batch loads.

· Continuous improvement on enhancement of data quality and integrity.

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

· Manage, monitor & measure various performances such as data movement, data pipeline, queries, cluster by utilizing effective logging and monitoring services & reporting.

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

· Manage data storage structure, and leverage on Microsoft Azure platform for efficiency in data processing, data retention & data auditing strategy.

· Optimize data retrieval, develop dashboards, reports and other visualizations for stakeholders.

· 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.

· 5-7 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 working with big data and Hadoop ecosystem.

· 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