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

Requirements

• 2+ years of experience in Analytics, Data Engineering, Marketing Analytics, Media 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.

Preferred

• Experience with PySpark and cloud-based data environments (Databricks, Snowflake, etc) preferred.

Benefits

• medical coverage
• dental
• vision
• disability
• 401K
• parantal and family care leave
• family forming assistance
• tuition reimbursement
• flexible time off