Lead Data Engineer

Company Description

Publicis Media is a social marketing and dynamic content center of excellence, specializing in connecting brands to consumers in real-time, social environments.

• Design, build, and maintain scalable ETL and ELT pipelines based on business requirements, user stories, and architectural standards.
• Assemble, transform, and manage large, complex datasets using cloud-native technologies (AWS, Databricks, Amazon Redshift) and SQL-based processing.
• Design and maintain relational data models to support analytics, reporting, and downstream consumption.
• Lead performance, reliability, and scalability efforts across the data platform, including monitoring, tuning, and optimization of pipelines and workloads.
• Develop and maintain Databricks solutions leveraging Spark, Delta Tables, and managed workflows (jobs, orchestration).
• Implement data governance and access controls using Unity Catalog and platform best practices.
• Use Git-based version control to manage code, support peer collaboration, and enable CI/CD workflows.
• Lead and support data platform migrations into Databricks, including legacy warehouse modernization and pipeline refactoring.
• Mentor and train junior data engineers through code reviews, technical coaching, and knowledge sharing.
• Create clear, accurate, and maintainable technical documentation.
• Participate in an on‑call rotation and provide escalation support for production issues as needed.

• Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field.
• 6 + years of experience in data engineering or a related role.
• Strong hands‑on experience with ETL/ELT frameworks and cloud data platforms (e.g., Databricks, AWS Glue, Amazon Redshift).
• Strong experience with relational databases and advanced SQL, including schema design, joins, window functions, performance tuning, and query optimization—particularly in Amazon Redshift or comparable cloud data warehouses.
• Proficiency in Python for data processing, automation, and pipeline development.
• Deep hands‑on experience with Databricks, including Spark optimization, Delta Tables, and Unity Catalog.
• Experience migrating data pipelines and workloads into Databricks from legacy or cloud data warehouse platforms.
• Databricks certifications (e.g., Data Engineer Associate or Professional) are a plus.
• Proficiency with Git and version control best practices in a collaborative development environment.
• Proven ability to lead a small engineering team.
• Excellent communication skills, with the ability to clearly explain technical concepts to technical and non‑technical stakeholders.
• Strong customer service mindset with the ability to translate business needs into reliable, scalable data solutions.
• Highly organized, self‑motivated, and able to manage multiple priorities in a fast‑paced environment.
• Digital media or ad‑tech experience, especially in data‑centric roles, is a plus.

Our benefits package includes medical coverage, dental, vision, disability, 401(k), parental and family care leave, tuition reimbursement, and flexible time off.

Compensation Range: $112,000–$135,000.

We will provide accommodations or assistance with the application or onboarding process if needed. All your information will be kept confidential according to EEO guidelines.