Senior Data Engineer

Zenith

Chicago (IL)

On-site

USD 87,210 - 137,195

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical coverage

Tuition reimbursement

Flexible time off

Job summary

A leading media agency is seeking a Manager, Data Engineer to enhance data models and write code for complex data sets. The ideal candidate will possess 2-3 years of experience with Databricks and expertise in advanced SQL coding. This role involves leading a team, optimizing data processes, and ensuring deliverable quality. Employees enjoy a comprehensive benefits package, including medical coverage, generous leave, and tuition reimbursement. Join a diverse team committed to excellence and innovation in data engineering.

Qualifications

2 to 3 years of experience in Databricks.
Advanced SQL coding and query optimization.
1+ years of Python coding experience.
Ability to lead other Data Engineers.
Excellent communication skills in professional settings.
Digital media experience in a data-centric role.

Responsibilities

Write application and database code based on business requirements.
Design, develop, and enhance data models.
Modify and improve data engineering processes.
Work on performance tuning and optimization.
Estimate and plan development work, track task progress.
Mentor and support team members.

Skills

Advanced SQL coding

Databricks

Python coding

Excellent communication skills

Customer service skills

Job description

Manager, Data Engineer

Zenith is a full-service media agency with capabilities and expertise across all channels and disciplines. Zenith is part of Publicis Media, the #1 media buying network in the Americas and #2 globally. As “The ROI Agency,” Zenith’s expertise lies in driving real, tangible business outcomes, not just media metrics, that will have a measurable effect on our clients’ business. Every investment we make has an ROI mindset—not just for our clients, but for our agency at large. We’re focused on driving the maximum value for our people, our capabilities and our media investments for some of the world’s leading brands.

Overview

As a Manager of Data Engineering, you will be focused on writing code and assembling large, complex sets of data using various technologies. You will be a part of the data processing team, focused on code optimization, in addition to other day-to-day responsibilities.

Responsibilities

Write application and database code based on business requirements or user stories, architectural requirements, and existing code using both Databricks and AWS Redshift.
Design, develop, and enhance data models in Databricks and AWS Redshift.
Modify and improve data engineering processes to handle ever larger, more complex, and more types of data sources and pipelines.
Work as part of the data processing team on performance tuning and optimization, query optimization, index tuning, caching, buffer tuning, and data archiving strategies.
Estimate and plan development work, track and report on task progress, and deliver work on schedule.
Ensure all deliverables are high quality by setting development standards, adhering to the standards, and participating in code reviews.
Mentor, support and manage team members.
Keep up to speed on new and emerging technologies and products of interest to our clients.

Qualifications

2 to 3 yrs of experience in Databricks.
Advanced SQL coding (must), tuning, and query optimization, especially within cloud-based data warehouses Amazon Redshift.
1+ years of Python coding experience.
Ability to lead other Data Engineers.
Excellent communication skills. Ability to speak and write professionally.
Excellent customer service skills. Ability to service clients, partners, and internal stakeholders by understanding their needs, translating those needs into creative solutions, and delivering on those solutions with diligence and a sense of urgency.
Ability to handle multiple responsibilities simultaneously in leadership and contributing to tasks “hands‑on”.
Demonstrated ability to quickly learn and adapt to new technologies and coding techniques.
Digital media experience, particularly experience working in ad‑tech industry with a data‑centric role.

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, 401(k), as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan and in our 401(k) plan once certain criteria have been met.

If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com.

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

The application deadline for this posting is 1/26/2026.

Compensation Range

$87,210–$137,195 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Compensation will be determined based on the skills, qualifications, and experience of the applicant, and the Company reserves the right to modify this pay range at any time.

Seniority Level