Data Engineer: ETL/Databricks Cloud Pipelines

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

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.