Director, Data Engineering: Lead Snowflake & Spark Pipelines

Publicis Groupe ANZ; New York, Northern (NY, KY); Hybrid; USD 135,000 - 217,000; Full time

Benefits offered by this job

Medical coverage

Dental

Vision

Disability

401K

Parental and family care leave

Tuition reimbursement

Flexible time off

Job summary

Publicis Groupe is seeking a Director, Data Engineering to lead design and delivery of a data-driven software platform across Snowflake, Databricks, PySpark and Delta Lake, coordinating product, analytics and engineering teams.

The role requires strong SQL, data modeling, BI tooling experience, cloud platforms, and the ability to mentor a team while ensuring data quality and scalable architectures.

Qualifications

• :7+ years of Data Engineering experience with advanced SQL and performance tuning.

Responsibilities

• Analyze complex business requirements and design scalable data solutions with product, analytics, and engineering teams.
• Design, develop, and optimize SQL transformations and data pipelines in Snowflake and Databricks using Delta Lake and PySpark.
• Collaborate with frontend engineers to design or modify schema for optimal software performance.
• Advanced database administration and development including stored procedures, UDFs, triggers and ELT/ETL packages using PySpark, SQL, and Python for large-scale data processing, as well as security and roles.
• Develop advanced Snowflake database objects including: Stored Procedures, UDFs, Views, Tasks, Streams, Dynamic Tables.
• Design scalable data models (fact/dimension, star schema, normalized) to support reporting, analytics, and downstream applications.
• Uphold quality standards and create monitoring tools to ensure high fidelity data.
• Optimization and tuning of existing stored procedures to improve performance.
• Troubleshoot database issues, identify root causes, and implement optimal solutions.
• Extract, transform, and load data from multiple data sources using languages and tools such as Python and AWS Glue.
• Design, Build, Test, Debug, Monitor, and Troubleshoot ETL and software processes in Python.
• Recommend solutions to existing or anticipated issues.
• Analyze ambiguous business requirements and partner with product team to provide a strategic solution.
• Have the confidence to work cross-functionally with various departments including business stakeholders and technical personnel to exchange ideas.
• Reviewing and improving existing solutions and collaborating with teams to integrate new solutions.
• Recommend solutions to existing or anticipated issues.
• Serve as an escalation point for any issues that may arise.
• Ability to follow implementation standards, develop documentation and transfer of knowledge

Skills

Advanced SQL development

Team leadership / mentoring

Data modeling

Independent worker

Communications skills

Excel (advanced)

Tools

Snowflake

Databricks

Python

SQL

Delta Lake

Unity Catalog

Tableau/Power BI

REST APIs

AWS

Git / CI/CD

Spark / PySpark

Job description

Publicis Groupe is seeking a Director, Data Engineering to lead design and delivery of a data-driven software platform across Snowflake, Databricks, PySpark and Delta Lake, coordinating product, analytics and engineering teams.

The role requires strong SQL, data modeling, BI tooling experience, cloud platforms, and the ability to mentor a team while ensuring data quality and scalable architectures.