Cloud Data Engineering Lead — BI & Data Lakes

Publicis Groupe ANZ; Chicago (IL); On-site; USD 112,000 - 161,000; Full time

Benefits offered by this job

Medical coverage

Dental

Vision

Disability insurance

401K

Parental and family care leave

Family forming assistance

Tuition reimbursement

Flexible time off

Job summary

Publicis Groupe ANZ is seeking an experienced Data Engineer to design and operate cloud-based data pipelines for health media analytics in the US market. You will monetize BI solutions, manage ETL processes, and collaborate with clients, sales, IT, and media teams to deliver scalable data products.

The role requires strong SQL, Python data wrangling, and experience with data warehousing across AWS/Azure/GCP, plus familiarity with Tableau or PowerBI for visualization.

Qualifications

• BS degree in CS/IT or related field.
• 5+ years designing and developing BI solutions.
• Solid understanding of database structures and ETL/warehouse principles.
• Strong communication and documentation skills.
• Proficient in SQL and Python data wrangling.

Responsibilities

• Create high performance data products by monetizing BI solutions and ETL tech.
• Collaborate with client, sales, IT, and media planning teams.
• Design and productionize data pipelines on cloud-based MPP stack (Azure/AWS), data lakes and multiple warehouses.
• Manage ETL/data feed, metadata, and database objects; optimize pipelines.
• Maintain data handling procedures and governance.
• Utilize Spark, Pandas, Python; work with Oracle/SQL Server/Postgres; leverage Tableau/PowerBI; operate on AWS/Azure/GCP.

Skills

Apache Spark

Pandas

Python

SQL

ETL

Data warehousing

Tableau

PowerBI

AWS

Azure

GCP

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle

SQL Server

PostgreSQL

Job description

Publicis Groupe ANZ is seeking an experienced Data Engineer to design and operate cloud-based data pipelines for health media analytics in the US market. You will monetize BI solutions, manage ETL processes, and collaborate with clients, sales, IT, and media teams to deliver scalable data products.

The role requires strong SQL, Python data wrangling, and experience with data warehousing across AWS/Azure/GCP, plus familiarity with Tableau or PowerBI for visualization.