Data Analyst I

About the role

Gupta Media is seeking a Data Analyst I to join its Strategy & Analytics team in Boston. You will support paid‑media analysts and clients by turning raw advertising data into actionable insights, reports, and visual dashboards.

Key responsibilities

• Design, build, and maintain custom dashboards that translate large data sets into clear visual stories.
• Produce client‑ready reports using Google Sheets, Excel, PowerPoint, and data‑visualisation tools.
• Assist paid‑media analysts with ad‑hoc reporting requests and data extraction.
• Learn clients’ business objectives to align media strategies with overall goals.
• Identify trends across campaigns and recommend optimization opportunities.

Required profile

• Strong analytical mindset with the ability to dissect complex problems using spreadsheets and data sets.
• Resourceful and self‑motivated; enjoys researching technical documentation to solve hurdles.
• Clear communicator who can explain technical findings to non‑technical audiences.
• Bachelor’s degree in a relevant field and at least 1 year of experience handling complex datasets.
• Experience with marketing data or paid‑advertising environments is a plus.

Required skills

• SQL
• Excel
• Google Data Studio (or similar data‑visualisation tools)
• Data Visualization
• Marketing APIs
• BigQuery
• Snowflake
• Rivery
• Supermetrics
• Python (preferred)