Director, Data Engineering

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

Company description

CoLab is a fully integrated, cross-discipline team that provides best-in-class services in a fluid and modular way. With our clients at the center, we create brand movement at the speed of people’s lives by connecting real-time data with world-class creative, content, and media in service of growth and Return on investment.

CoLab is a "power of one" solution, encompassing data, media, and production. By drawing from across the vast Publicis Groupe network, we are uniquely positioned to deliver innovation and specialized skills to our clients, as well as enriching opportunities and inclusive benefits to our employees. We pride ourselves on combining the atmosphere of a startup company with the stability and experience of a global leader.

Overview

Our team is looking for a high-performing Director, Data Engineering who will be responsible for the design, development, implementation and on-going support of a data driven software platform. You enjoy and thrive in a fast-paced environment on multiple projects simultaneously, including both enhancements as well as new project development. The candidate must be a self-starter with a sense of urgency and a commitment to quality and professionalism.

Responsibilities

• Analyze complex and ambiguous business requirements and partner with product, analytics, and engineering teams to design scalable data solutions
• Design, develop, and optimize complex 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, user definefunctions, 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, User Defined Functions (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

Qualifications

• 7+ years of experience in Data Engineering with advanced SQL development writing complex queries, CTEs, window functions, stored procedures, and performance tuning.
• Strong experience with Snowflake as an enterprise data warehouse.
• Media Agency experience preferred
• Able to work independently and balance multiple tasks.
• High competency level in MS Office with specific strengths in Excel (knowledge of VBA a plus) and PowerPoint
• Adheres to deadlines
• Advanced SQL programming skills, Redshift preferred (creating views, stored procedures, functions, etc.)
• Experience with Databricks, Snowflake (creating views, stored procedures, functions, etc.)
• Experience building scalable data pipelines using Databricks and Apache Spark (PySpark).
• Experience with Delta Lake, Unity Catalog, and modern lakehouse architectures.
• Experience with Business Intelligence tools such as Tableau or Power BI.
• Experience integrating REST APIs and third-party data sources.
• Experience supporting analytics and data science teams.
• Experience with CI/CD pipelines and Git-based development workflows.
• Experience with cloud platforms (AWS, Azure, or GCP) is preferred, with AWS experience considered a plus rather than a primary requirement.
• Excellent data modelling skills and experience working with large data sets.
• Experience with digital media measurement and analytics
• Experience with machine learning principles and applications a plus
• Possession of excellent written, oral communication and presentation skills
• Proven experience managing or mentoring a team.

Additional information

Our Publicis Groupe motto "Viva La Différence" means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

• medical coverage
• dental
• vision
• disability
• 401K
• parental and family care leave
• family forming assistance
• tuition reimbursement
• flexible time off

If you require accommodation or assistance with the application or onboarding process specifically, please contact [e-mail].

All your information will be kept confidential according to EEO guidelines.

#LI-JL2

Compensation Range: USD $135,375.00 - USD $216,684.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 10/12/2026.