Data Analyst I

Gupta Media•Boston, MA

16h•Onsite

About The Position

Gupta Media was founded over 25 years ago on the idea that advertising could create huge leverage in our clients' businesses. Our work initially focused on the entertainment industry, specifically live events and recorded music (SXSW, Sony Music, Universal Music, and Disney Music Group are all clients). We have grown to include global brands (Amazon, Sophia Learning), major sports franchises (X Games, Florida Panthers, Washington Commanders, Cleveland Cavaliers, Women’s Tennis Association), as well as public sector institutions (City of Boston, Massachusetts Office of Travel and Tourism). We are on the hunt for a talented Data Analyst I to join our Strategy & Analytics team to assist with reporting, tracking, data analysis, advertising strategy, and visualization needs. In this role, you will work internally to assist paid media analysts with reporting requests and externally to provide clients with insights into their advertising campaigns. The ideal candidate is inherently resourceful. We need someone who enjoys the "instruction manual" level of detail and views a technical hurdle as a problem to be solved rather than a roadblock. When you encounter a gap in your knowledge, you have the drive to research, test, and figure out the answer. We want someone who doesn't just want to run reports, but wants to build a better, faster version of them.

Requirements

Tear apart complex problems and live inside spreadsheets, data sets, or documentation to find the answer to any question.
Strong technical toolkit, including SQL, Excel, Google Data Studio/Data Visualization.
Enjoy working with SQL on a day-to-day basis.
Technically curious and resourceful.
Natural ability to navigate and understand technical documentation—whether it’s for an API, a piece of software, or a new platform—and use it to troubleshoot or build new solutions.
Communicate with clarity. Ability to take deep-dive technical work and explain the logic, the solution, and the results to a non-technical audience without losing the meaning.
Bachelor’s degree in a relevant field.
Minimum of 1 year of experience working with complex datasets, preferably in a fast-paced environment.
Authorized to work in the US for at least 3 years.

Nice To Haves

Experience with Marketing APIs, BigQuery, Snowflake, ETL tools (Rivery, Supermetrics), or Python is a significant plus.
Experience with marketing data or paid advertising is a plus.

Responsibilities

Design and maintain customized dashboards that transform thousands of lines of data into clear, visual stories.
Translate complex performance media metrics into digestible, client-ready reports via Google Sheets, Excel, and PowerPoint.
Learn our clients’ businesses inside and out to align their media strategy with overarching business goals.
Identify advertising trends across projects to help guide media buying decisions and optimize spend.
Collaborate across teams to ensure our tracking and measurement frameworks are scalable, accurate, and best-in-class, acting as a bridge between raw data and strategy.
Use your understanding of concepts like LTV, ROAS, and Incremental Revenue to lead discussions with clients, gaining trust and shareholder buy-in on media strategy and results.