Data Engineer

Zenith; New York, Northern (NY, KY); Hybrid; USD 73,000 - 113,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

Zenith, a leading Publicis Groupe media agency in New York, is seeking a data engineer to design and maintain scalable ETL/ELT pipelines using AWS and Databricks. You will transform large datasets, optimize data flows, and collaborate with analytics teams to enable accurate reporting.

The role requires strong SQL, Python, Databricks knowledge, and Git proficiency, plus effective communication and a customer-focused mindset. This is an on-site position in New York with comprehensive benefits.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field.
• Strong hands-on experience with ETL/ELT tools and frameworks.
• Strong experience with relational databases and advanced SQL (2+ years).
• Experience with Python for data processing, automation, or pipeline development.
• Working knowledge of Databricks (Spark, notebooks, jobs, Delta tables).
• Proficiency with Git and version control in a team environment.
• Excellent communication skills to explain technical concepts.
• Strong customer service mindset with urgency and accountability.
• Highly organized and able to manage multiple priorities.
• Digital media or ad tech experience is a plus.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines.
• Assemble and manage large datasets using AWS, Databricks, and SQL.
• Design relational data models to support reporting and analytics.
• Ensure performance and reliability of the data platform.
• Collaborate on performance tuning and code quality standards.
• Develop and maintain Databricks workflows ( notebooks, jobs, orchestration ).
• Use Git for version control and CI/CD workflows.
• Estimate, plan, and deliver development work on schedule.
• Create clear technical documentation.
• Participate in on-call rotation and production support.

Skills

ETL/ELT tools

SQL

Python

Databricks

Git

Communication skills

Customer service mindset

Education

Bachelor's degree

Tools

Databricks

Job description

Company description

Zenith is one of Publicis Groupe’s largest media agencies, spanning 95 markets globally with US offices in New York, Burbank, Chicago, Atlanta and Detroit. For more than 30 years, we have been at the forefront of media, helping to evolve and reshape the industry. We are highly regarded as a true agency partner by many high-profile brands for our expertise across numerous categories and wide range of capabilities that are unparalleled in the industry. Clients hire us for our track record of excellence in strategic planning, investment, and measurement. We also have specialist offerings, including content, commerce, multicultural and future-proofed data capabilities.

Responsibilities

• 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) and SQL-based processing.
• Design and work extensively with relational data models to support reporting, analytics, and downstream consumption.
• Ensure performance, reliability, and scalability of the data platform, including monitoring and optimizing data pipelines and feeds.
• Collaborate with the data engineering team on performance tuning, query optimization, and code quality standards.
• Develop and maintain data workflows in Databricks, including notebooks, jobs, and orchestration.
• Use Git-based version control to manage code, collaborate with peers, and support CI/CD workflows.
• Estimate and plan development work, track progress, and deliver high-quality solutions on schedule.
• Create clear, accurate, and maintainable technical documentation.
• Participate in on-call rotation and support production incidents as needed.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field.
• Strong hands-on experience with ETL/ELT tools and frameworks with databricks
• Strong experience working with relational databases and advanced SQL, including schema design, joins, window functions, performance tuning, and query optimization (2+ years).
• Experience with Python for data processing, automation, or pipeline development.
• Working knowledge of Databricks (Spark, notebooks, jobs, Delta tables preferred).
• Proficiency with Git and version control best practices in a collaborative development environment.
• Excellent communication skills, with the ability to clearly explain technical concepts to both technical and non-technical audiences.
• Strong customer service mindset, with experience translating business needs into effective data solutions and delivering with urgency and accountability.
• 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.

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.

Veterans Encouraged to Apply.

Compensation Range: USD $73,150.00 - USD $112,554.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. Temporary roles may also qualify for participation in our 401(k) plan after eligibility 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/17/2026.