Marketing Data Analyst II

The Marketing Data Analyst II will join the Strategy & Analytics team, blending marketing savvy with technical fluency to solve complex business problems. This role focuses on connecting performance data to strategic insights, sitting at the intersection of analytics, advertising, and client services. Key responsibilities include implementing tracking, building data models for forecasting, developing scalable reports using SQL and various data sources, and presenting actionable insights to clients. The ideal candidate will have experience with marketing data, GTM, GA4, CRMs, and a strong understanding of advertising metrics and optimization.

Must Have

• Implement and troubleshoot web and campaign tracking.
• Build data models for strategic decision-making.
• Translate business objectives into measurable KPIs.
• Develop scalable reports and dashboards.
• Write complex SQL queries for data extraction.
• Integrate data from marketing APIs, ad platforms, CRMs.
• Present complex insights to clients and stakeholders.
• Shape media strategy with actionable recommendations.
• Collaborate with brand and agency stakeholders.
• Minimum 2 years experience with marketing/advertising data.
• Bachelor’s degree in Computer Science, Marketing, or related.
• Proficiency in GTM, GA4, and CRMs.
• Fluency in SQL.
• Experience with marketing APIs and advertising metrics.
• Strong instincts in budget pacing, bidding, and CRO.
• Comfortable with ambiguous problem-solving.

Good to Have

• BigQuery experience

Gupta Media was founded 20 years ago on the idea that advertising could create huge leverage in our client's business. Our early work was focused on the entertainment industry, specifically live events (Boston Calling, among others) and recorded music (Sony Music, Universal Music & Disney are all clients). We have dramatically grown our work with big brands and subscription services (Amazon, Fender) and sports franchises (LA Galaxy, Washington Commanders). We have a global client base with a growing local roster across B2B and B2C brands across campaign, content and branding assignments.

We’re looking for a Marketing Data Analyst II to join our Strategy & Analytics team—someone who brings a blend of marketing savvy and technical fluency, thrives on solving ambiguous business problems, and knows how to connect the dots between performance data and strategy. This role sits at the intersection of analytics, advertising, and client services.

What You’ll Do

Analytics Infrastructure & Tracking

• Implement and troubleshoot web and campaign tracking using Google Tag Manager, GA4, and custom conversion setups across platforms like Shopify, ticketing systems, and CRMs.
• Ensure accurate event tracking and attribution to support campaign insights.

Data Strategy & Modeling

• Build models that empower strategic decision-making, including forecasting tools to guide daily budget pacing, conversion rate benchmarks, and ROAS expectations.
• Translate business objectives into measurable KPIs and reporting frameworks.

Data Analysis & Reporting

• Develop scalable reports and dashboards using tools like Looker Studio, Excel, and Google Sheets.
• Write complex SQL queries to extract, clean, and analyze large datasets.
• Integrate data from marketing APIs, ad platforms, and CRM systems into clean, usable formats.

Client-Facing Insights

• Present complex ideas and insights clearly and confidently to both clients and internal stakeholders, including non-technical audiences.
• Help shape media strategy by translating campaign performance into actionable recommendations.
• Work across brand and agency stakeholders to align on goals, test strategies, and optimize spend.

Who You Are

• You have 2+ years of experience working with marketing or advertising data, ideally in a fast-paced agency or brand environment with a strong performance marketing focus
• You’ve got a Bachelor’s degree in Computer Science, Marketing, or a related field
• You know your way around GTM, GA4, and CRMs, and can spot tracking issues before anyone else
• You’re fluent in SQL and can comfortably wrangle data from multiple sources (BigQuery experience is a plus)
• You’ve worked directly with marketing APIs and understand advertising metrics like LTV, CAC, ROAS, and incrementality
• You have strong instincts around budget pacing, daily bidding decisions, and conversion rate optimization
• You’re comfortable working in ambiguous problem spaces and love turning data into clarity

At Gupta Media, we work hard every day to be better at all that we do — and that includes fostering a diverse and inclusive community that encourages and respects a broad range of backgrounds, experiences and ideas. Join us and help us find the next great idea.

Gupta Media is an office-first organization.