Data Analyst I

Gupta Media•Boston, MA

18h•$70,000 - $85,000•Onsite

About The Position

Gupta Media is seeking a talented Data Analyst I to join their Strategy & Analytics team. This role will focus on reporting, tracking, data analysis, advertising strategy, and visualization. The analyst will support paid media analysts with internal reporting requests and provide clients with insights into their advertising campaigns. The ideal candidate is resourceful, enjoys detailed work, and is driven to solve technical challenges and improve existing processes.

Requirements

Ability to break down complex problems and analyze data in spreadsheets and datasets.
Strong technical toolkit including SQL, Excel, and Google Data Studio/Data Visualization.
Enjoy working with SQL on a day-to-day basis.
Technically curious and resourceful, with the ability to navigate and understand technical documentation.
Ability to communicate technical work and results clearly to a non-technical audience.
Bachelor's degree in a relevant field.
Minimum of 1 year of experience working with complex datasets.
Experience in a fast-paced environment.

Nice To Haves

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

Responsibilities

Design and maintain customized dashboards that transform data into clear, visual stories.
Translate complex performance media metrics into digestible, client-ready reports using Google Sheets, Excel, and PowerPoint.
Learn clients' businesses to align media strategy with business goals.
Identify advertising trends across projects to guide media buying decisions and optimize spend.
Collaborate across teams to ensure tracking and measurement frameworks are scalable, accurate, and best-in-class.
Act as a bridge between raw data and strategy.
Use understanding of concepts like LTV, ROAS, and Incremental Revenue to lead discussions with clients regarding media strategy and results.