About the Role
Zenith is seeking a Data Engineer to design, build, and maintain scalable ETL and ELT pipelines. This role involves transforming large datasets using cloud-native technologies and SQL, ensuring the performance and reliability of the data platform, and collaborating with the data engineering team.
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.
Requirements
- 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 performance 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.
Skills
- ETL/ELT
- Databricks
- SQL
- Python
- Git
- Version Control
- CI/CD
- AWS
Experience Level
- 2+ years
Education Level
- Bachelor’s degree in Information Technology, Computer Science, Engineering, or a related field.
Salary/Compensations
- USD $73,150.00 - USD $112,554.00/Annually
Benefits
- Medical coverage
- Dental
- Vision
- Disability
- 401K
- Parental and family care leave
- Family forming assistance
- Tuition reimbursement
- Flexible time off
About the Company
- 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, Zenith has been at the forefront of media, helping to evolve and reshape the industry.
- Zenith is highly regarded as a true agency partner by many high-profile brands for its expertise across numerous categories and wide range of capabilities that are unparalleled in the industry.
- Clients hire Zenith for its track record of excellence in strategic planning, investment, and measurement.
- Zenith also has specialist offerings, including content, commerce, multicultural and future-proofed data capabilities.
Equal Opportunity
- Publicis Groupe motto “Viva La Différence” means we’re better together, and we believe that our differences make us stronger.
- 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.
- All your information will be kept confidential according to EEO guidelines.
- Veterans Encouraged to Apply.
