Senior Data Engineer & Analytics Automation

Zenith; New York (NY); On-site; USD 73,000 - 113,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401(k)

Parental leave

Paid time off

Job summary

Zenith, a leading Publicis Groupe media agency in New York, seeks a Senior Analyst to transform complex media and audience data into actionable insights. You will leverage SQL and Python to build scalable analytical solutions and automate workflows.

Collaborate with Analytics, Strategy, Activation, and Data Science teams to answer business questions, maintain reusable datasets, and present findings to diverse audiences.

Qualifications

• 2+ years of experience in Analytics, Data Engineering, Marketing Analytics, or a related field.
• Advanced proficiency in SQL and Python.
• Strong experience manipulating, transforming, and analyzing large datasets.
• Experience building automated workflows, reusable analytical tools, and scalable data processes.
• Required experience working with digital media data and media taxonomies.
• Experience with PySpark and cloud-based data environments (Databricks, Snowflake, etc) preferred.

Responsibilities

• Develop complex SQL and Python-based solutions to prepare, transform, and analyze large media and audience datasets.
• Perform ad hoc analyses to answer business, client, and campaign performance questions.
• Build and maintain reusable datasets that support reporting, analytics, and strategic decision-making.
• Design and automate recurring analytical processes and workflows to improve efficiency and scalability.
• Work extensively with media taxonomies and reporting dimensions including channel, publisher, DSP, creative size, placement, audience, and daypart.
• Identify data quality issues and implement processes to improve consistency and reliability across datasets.
• Collaborate with stakeholders to translate ambiguous business questions into analytical approaches and recommendations.
• Present findings and insights to both technical and non-technical audiences.
• Document analytical methodologies, data definitions, and workflow processes to support long-term team scalability

Skills

SQL

Python

Data analysis

Tools

PySpark

Databricks

Snowflake

Job description

Zenith, a leading Publicis Groupe media agency in New York, seeks a Senior Analyst to transform complex media and audience data into actionable insights. You will leverage SQL and Python to build scalable analytical solutions and automate workflows.

Collaborate with Analytics, Strategy, Activation, and Data Science teams to answer business questions, maintain reusable datasets, and present findings to diverse audiences.