Data Engineer (Media experience)
Publicis Groupe · Bogotá
Company descriptionPublicis Global Delivery is the talent powerhouse of Publicis Groupe, the largest global communications group. We make sure to hire, boost and develop the best people worldwide to deliver outstanding work for the most prominent clients within the Groupe.
In LATAM, we are over 3.000 passionate employees that love to push boundaries and drive innovative solutions. If you are a risk-taker and love to develop intrepid ideas, PGD is the place for you.
We Move People, and People Move Us!
Overview
This role puts you at the heart of an innovative way of working within Publicis Groupe. It does require fast thinking, highly collaborative, and positive energy, but it will be gratifying for the right person.
As a Data Engineer on the Data Operations team, you are responsible for managing data workflow automation processes. You will be part of a team responsible for developing and delivering our GCP platform. You will support end-to-end workflows while actively collaborating with different internal stakeholders to assess data needs.
Responsibilities
- Drive and advance existing end-to-end workflow processes
- Take ownership of proper data governance and conduct data quality checks in collaboration with teams
- Prepare documentation for workflow automation and new pipeline development
- Drive the audit process automation to ensure accuracy and efficiency
- Utilize ETL tools to extract data from data sources, filter, and transform the data for use in reporting and analysis (BigQuery, Python, GCP)
- Develop, deliver, and maintain the BigQuery data lake
- On-board new data sources to the data lake
- Collaborate with the project management team for key data operation projects
Qualifications
Must have skills
- Hands-on experience with Python programming.
- Experience developing ETL solutions and data engineering workflows.
- Strong SQL and database experience.
- Experience with BigQuery.
- Working knowledge of Google Cloud Platform (GCP).
- Ability to create scripts, stored procedures, and manage data pipelines.
- Basic knowledge of the advertising/marketing industry and digital marketing metrics.
- Experience using Campaign Manager (CM360) or understanding its functionality.
- Proficiency in Excel.
Nice to have
- Experience building Data Studio / Looker Studio reports.
- Knowledge of Alteryx or other ETL-related tools.
- Familiarity with additional digital advertising platforms beyond Campaign Manager.
- Experience with social media advertising platforms and related tools.
- Knowledge of SA360 (Search Ads 360).
- Broader understanding of digital marketing platforms and marketing performance metrics.
- Advanced Excel expertise beyond core requirements.
- Drive and advance existing end-to-end workflow processes
- Take ownership of proper data governance and conduct data quality checks in collaboration with teams
- Prepare documentation for workflow automation and new pipeline development
- Drive the audit process automation to ensure accuracy and efficiency
- Utilize ETL tools to extract data from data sources, filter, and transform the data for use in reporting and analysis (BigQuery, Python, GCP)
- Develop, deliver, and maintain the BigQuery data lake
- On-board new data sources to the data lake
- Collaborate with the project management team for key data operation projects
Must have skills
- Hands-on experience with Python programming.
- Experience developing ETL solutions and data engineering workflows.
- Strong SQL and database experience.
- Experience with BigQuery.
- Working knowledge of Google Cloud Platform (GCP).
- Ability to create scripts, stored procedures, and manage data pipelines.
- Basic knowledge of the advertising/marketing industry and digital marketing metrics.
- Experience using Campaign Manager (CM360) or understanding its functionality.
- Proficiency in Excel.
Nice to have
- Experience building Data Studio / Looker Studio reports.
- Knowledge of Alteryx or other ETL-related tools.
- Familiarity with additional digital advertising platforms beyond Campaign Manager.
- Experience with social media advertising platforms and related tools.
- Knowledge of SA360 (Search Ads 360).
- Broader understanding of digital marketing platforms and marketing performance metrics.
- Advanced Excel expertise beyond core requirements.
More jobs at Publicis Groupe · Data & Analytics jobs in Bogota