Senior Data Analytics Engineer: Media & Automation

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

Job summary

Zenith seeks a Senior Analyst to transform complex media and audience data into actionable insights. You will wrangle data with SQL and Python, build reusable datasets, and automate recurring analytics workflows for cross-functional teams.

You will collaborate with Analytics, Strategy, Activation, and Data Science to answer business questions, present findings to diverse audiences, and document methodologies for scalability. Strong communication and problem-solving are essential.

Qualifications

• 2+ years in Analytics, Data Engineering, Marketing Analytics, or related field.
• Advanced proficiency in SQL and Python.
• Experience manipulating, transforming, and analyzing large datasets.
• Experience building automated workflows, reusable analytical tools, and scalable data processes.
• Experience with digital media data and media taxonomies.
• Knowledge of PySpark and cloud data environments (Databricks, Snowflake) preferred.
• Strong problem-solving skills and ability to work independently in ambiguous environments.
• Excellent communication and presentation skills.

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 wrangling

Large datasets

Media analytics

PySpark

Cloud data

Problem-solving

Presentation

Tools

Databricks

Snowflake

Job description

Zenith seeks a Senior Analyst to transform complex media and audience data into actionable insights. You will wrangle data with SQL and Python, build reusable datasets, and automate recurring analytics workflows for cross-functional teams.

You will collaborate with Analytics, Strategy, Activation, and Data Science to answer business questions, present findings to diverse audiences, and document methodologies for scalability. Strong communication and problem-solving are essential.