Strategy & Analytics

Data Analyst

Gupta Media is looking for a 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. Advanced knowledge of Excel is a requirement, and 1-2 years of experience managing paid advertising campaigns or working in digital advertising is preferred.

Responsibilities:

  • Reporting
    • Comfort with Excel, Powerpoint, Google Data Studio, Google Docs and Google Sheets is required. 
      • Maintaining customized dashboards in Google Sheets and Excel that are updated on a daily/weekly cadence. 
      • Generating pivot tables and other visualizations that summarize thousands of lines of data. 
      • Prefer candidates with experience in translating performance media metrics into a coherent, digestible reports for client ad campaigns.
    • Assist with the creation of Power Point/Google Slide decks.
  • Strategy
    • Understand advertising trends within a single project and across multiple projects to help guide media buying strategy. 
    • Learn client’s business and align the media strategy with business goals. Understand concepts like LTV, ROAS and Incremental Revenue.
    • Discuss strategy with clients to gain trust and shareholder buy-in on media strategy and results.

Requirements:

  • Bachelor’s Degree or higher.
  • 2-3 years of experience as a data analyst or comparable position. 
  • Excellent written and verbal communication skills. 
  • Excel, Powerpoint, Google Data Studio, Google Docs and Google sheets.
    • Nice-to-have: Tableau, Python, SQL, ETL Services
  • An absolute love for data. You have no problem tearing apart a problem, and living inside a spreadsheet to find the answer to any question.
  • Driven, motivated, enthusiastic attitude. You want to take on challenges, and you are excited to find the solution in the most effective way possible.

About The Agency

Gupta Media is an agency with three specialties – media buying, creative services and technology solutions. We do our best work when all three are working in unison. Our client roster includes brands like Amazon, Red Bull, Movember and Fender, music festivals like Boston Calling, The Governor’s Ball and Afropunk, and record labels like Sony Music, Universal Music and Warner Music Group.

We pride ourselves on being innovative, competitive and disruptive in the digital space. Due to this, we’ve organically grown to dominate our target industries. Now, we want to apply what we already know to other industries.

Interested? Please send us your resume and cover letter.

Apply Now