Senior Data Engineer

Job description

Company description Publicis Global Delivery (PGD); Publicis Groupe’s industry leading globally connected capability platform. Where talent, technology & operations combine to delivery amazing solutions for our clients. Expertise across Media, Data, Technology, Commerce & Production in all regions of the world. PGD is comprised of the best talent, and ways-of-working, which enables global scale, innovation and transformation, each day.

Culture, growth and wellbeing underline all aspects of Publicis Global Delivery. #WeArePGD Overview We are seeking a skilled Data Engineers with strong SQL abilities, familiarity with the AWS| GCP | Azure environments. Strong experience on ETL process. This role involves working with large amounts of data related to media metrics, such as impressions, clicks, spending, and others, in order to provide accurate data to clients.

The ideal candidate is self-directed with strong attention to detail and the ability to document his/her work. He or she should be able to answer technical questions appropriately and participate actively in meetings with our global clients.

Responsibilities

Maintain ETL reports. Ensure the quality of information for the client. Documenting the process through Jira/Confluence. Collaborate with internal and external stakeholders to resolve data-related issues. Establish strong communication and actively participate in meetings. Strong ability to evaluate new technologies and present findings to team. Contribute to client status and reporting calls, including presentation of reporting as required.

Develop subject matter expertise in ETL, API development, and Business Intelligence platforms. Clearly define project deliverables, timelines, and dependencies for junior team members, internal stakeholders and clients. Responsible for loading and validating data into the data warehouse from various source systems. Analyze, develop, fix, test, review and deploy functionality, and bug fixes in ETL data pipelines. Query tuning, diagnosis, and resolution of performance issues leveraging ELT and push-down if required.

Building Data mappings between Source to Target systems. Provides support for technical issues and ensuring system availability. Work with business customers to identify and develop additional data and reporting needs. Understand how business intelligence platform/data technologies work and offer the ability to explain technical concepts in ordinary terms (be technically savvy - understand the opportunities and limitations).

Establish and manage data integrations utilizing a taxonomy nomenclature to make recommendations for data visualization to showcase media performance through the use of Datorama or Tableau. Perform regular quality assurance/quality control checks on assigned client campaigns to ensure the data is processing accurately.

Qualifications

Strong SQL skills. Solid experience with PySpark and/or Python Experience with Databricks Experience: Approximately 5 years of experience Familiarity with cloud technologies CI/CD knowledge English proficiency.

Additional information Nice to have

AI knowledge