Marketing/Advertising Data Analyst

3x/week onsite in Hoboken, NJ Contract to Jan 31st plus possible extensions, potential conversion to full time employee Must Haves: • 3+ years of relevant analytical experience, in media, marketing analytics, or consumer insights (agency, brand, publisher, or research side) • Background in media reporting types and campaign performance metrics • Proficiency in SQL for querying large datasets and optimizing data workflows • Expertise in dashboarding tools like Tableau or Power BI • Advanced Excel skills • Strong communication and presentation skills to bridge technical insights with non-technical stakeholders • Ability to identify insights, deep dive into data, and translate findings into actionable recommendations Plusses: • Experience with retail media platforms (e.g., Lowe’s, Best Buy, Amazon, Petco, Meta) • Python for data manipulation, modeling, and exploratory analysis • Exposure to social media marketing • Experience with Google Cloud Platform (GCP) or equivalent cloud environments Job Description: Our top retail client is seeking a Marketing Analyst to join their Media Insights Team, supporting strategic decision-making for their beverage portfolio. This role requires a unique blend of technical expertise and strategic thinking. The ideal candidate will be comfortable working with advanced analytics tools like Python and SQL to build predictive models and uncover consumer behavior trends, while also being able to interpret media performance drivers, attribution results, and translate insights into actionable recommendations for stakeholders. They should be adept at connecting analytical outputs to broader business impact, client use cases, and optimization strategies. Strong communication skills are essential, as this role serves as a bridge between data science and business teams, helping to translate complex data into clear, compelling narratives that inform marketing decisions. • Building predictive models and analyzing consumer behavior trends using Python and SQL • Managing scalable data pipelines and hosting analytical workflows on Google Cloud Platform (GCP) • Developing Tableau dashboards to automate reporting and visualize key insights • Evaluating marketing impact by comparing campaign performance and analyzing cross-channel behavior for customers like Pepsi, Red Bull, etc. • Interpreting attribution results and articulating media performance drivers to stakeholders • Delivering actionable insights that inform client use cases and guide future campaign optimization