Data Analyst

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 (Amazon, Fender) and sports brands (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 are on the hunt for a talented Data Analyst 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 as well as externally to provide clients with insights regarding their advertising campaigns.

If you are excited by the opportunity to improve reporting for our clients and our analysts, are able to communicate effectively to understand what tools will help solve a problem, and then work collaboratively to design a solution that’s scalable, accurate and easy-to-use, we want to talk to you.

Who You Are:

• Y ou have a true love for data. You have no problem tearing apart a problem and living inside a spreadsheet or data set to find the answer to any question.


• You have advanced knowledge of SQL, Excel, and Google Data Studio/Data Visualization tools, and enjoy working with SQL on a day-to-day basis.


• Experience with Marketing APIs, BigQuery or other cloud data warehouse tools (AWS, Snowflake, Databricks), ETL tools (such as Rivery, Looker, Supermetrics), and/or Python is a plus.


• You have a bachelor’s degree in a relevant field and at least 1 year of experience working with marketing data and/or paid advertising campaigns, preferably in a fast-paced agency environment or team structure.
  

What You’ll Do:

Reporting:

• Maintain customized dashboards in Google Sheets and Excel on a daily/weekly cadence.


• Use Advanced Excel, SQL, and Google Data Studio/Visualization Tools to generate pivot tables and other visualizations summarizing thousands of lines of data.


• Translate performance media metrics into clear, digestible reports for client advertising campaigns.


• Communicate insights effectively through Google Slides or PowerPoint decks.

Strategy:

• Learn our clients’ businesses and align media strategy with their business goals.


• Analyze advertising trends within a single project and across multiple projects to guide media buying strategy.


• Apply your background in paid media and/or digital advertising, including understanding concepts like LTV, ROAS, and Incremental Revenue.


• Engage in discussions with clients to build trust and gain stakeholder buy-in on media strategy and results.

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.