Data Analyst

3 Months ago • 1 Years + • Data Analysis

Job Summary

Job Description

The Data Analyst will join the Strategy & Analytics team to assist with reporting, tracking, data analysis, advertising strategy, and visualization needs. This role involves working internally with paid media analysts and externally with clients to provide insights regarding their advertising campaigns. The analyst will be responsible for maintaining customized dashboards, using advanced Excel and SQL, translating media metrics, and communicating insights through presentations. The role also involves learning clients' businesses, analyzing advertising trends, and engaging in client discussions to build trust and align media strategy with business goals.
Must have:
  • Advanced knowledge of SQL, Excel, and Google Data Studio.
  • 1+ year of experience with marketing data or paid advertising campaigns.
  • Bachelor's degree in a relevant field.
Good to have:
  • Experience with Marketing APIs, BigQuery, or cloud data warehouse tools.
  • Experience with ETL tools such as Rivery or Looker.
  • Experience with Python.

Job Details

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:

  • You 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.

    Similar Jobs

    Square - Graduate Electrical Engineer

    Square

    Bridgwater, England, United Kingdom (On-Site)
    2 Weeks ago
    zeta - Associate Director - Program Management

    zeta

    Hyderabad, Telangana, India (On-Site)
    1 Month ago
    Whalar - Community Manager

    Whalar

    New York, United States (On-Site)
    2 Weeks ago
    AECOM - Senior CAD Specialist

    AECOM

    Buffalo, New York, United States (On-Site)
    1 Month ago
    Rocket - Senior Technical Support Engineer

    Rocket

    Wisconsin, United States (Remote)
    1 Month ago
    Match Group - Product Data Analyst

    Match Group

    Tokyo, Japan (Hybrid)
    1 Year ago
    Temporal Technologies - Staff Software Engineer - Cloud Data Storage

    Temporal Technologies

    United States (Remote)
    1 Month ago
    Capgemini - Data Scientist

    Capgemini

    Pune, Maharashtra, India (On-Site)
    2 Months ago
    PhonePe - Site Reliability Engineer - Big Data

    PhonePe

    Bengaluru, Karnataka, India (On-Site)
    4 Weeks ago
    Nice - Senior Data Scientist Engineer

    Nice

    Pune, Maharashtra, India (Hybrid)
    1 Month ago

    Get notifed when new similar jobs are uploaded

    Similar Skill Jobs

    Open Systems Technologies - Maintenance Technician - Day Shift, 6:00am - 6:00pm

    Open Systems Technologies

    Peachtree City, Georgia, United States (On-Site)
    1 Week ago
    PwC - Tax Specialist – Senior Associate / New Manager

    PwC

    Napier, Hawke's Bay, New Zealand (On-Site)
    1 Year ago
    Zenoti - Senior Software Engineer (.NET)

    Zenoti

    Hyderabad, Telangana, India (On-Site)
    1 Month ago
    WebFX - React Developer

    WebFX

    Ann Arbor, Michigan, United States (On-Site)
    9 Months ago
    Clearwater Analytics - Implementations Project Manager

    Clearwater Analytics

    Boise, Idaho, United States (On-Site)
    1 Month ago
    Paytm - Product Management - Senior/Group Product Manager - Lending

    Paytm

    Noida, Uttar Pradesh, India (On-Site)
    5 Months ago
    truecaller - Senior IT-Operations Specialist

    truecaller

    Stockholm, Stockholm County, Sweden (On-Site)
    2 Months ago
    Interactive Brokers - Senior Platform Engineer

    Interactive Brokers

    Greenwich, Connecticut, United States (Hybrid)
    1 Month ago
    Trek - IT Security Operations Analyst

    Trek

    Haryana, India (On-Site)
    6 Months ago
    PwC - Senior Associate - Consulting - FS Strategy & Operations (Talent Pool)

    PwC

    Jakarta, Jakarta, Indonesia (On-Site)
    10 Months ago

    Get notifed when new similar jobs are uploaded

    Jobs in Boston, Massachusetts, United States

    EMA - Account Executive - Healthcare

    EMA

    United States (Hybrid)
    2 Months ago
    Spellbrush - Game Programmer (Unity)

    Spellbrush

    San Francisco, California, United States (On-Site)
    4 Months ago
    Apple - Generative AI, Machine Learning Engineer

    Apple

    Cupertino, California, United States (On-Site)
    2 Months ago
    VVater - Financial Controller

    VVater

    Austin, Texas, United States (On-Site)
    3 Months ago
    Open Systems Technologies - General Manager in Training

    Open Systems Technologies

    Houston, Texas, United States (On-Site)
    1 Month ago
    Lead Venture - Senior Financial Analyst

    Lead Venture

    Lake Oswego, Oregon, United States (Remote)
    1 Month ago
    Open Systems Technologies - Restaurant Manager

    Open Systems Technologies

    Burnsville, Minnesota, United States (On-Site)
    1 Week ago
    ElevenLabs - Global Business Development Lead

    ElevenLabs

    United States (Remote)
    2 Weeks ago
    Visual Concepts - Senior Server Engineer, NBA 2K

    Visual Concepts

    Novato, California, United States (On-Site)
    8 Months ago
    Meow Wolf - Area Sales Assistant Manager

    Meow Wolf

    Grapevine, Texas, United States (On-Site)
    1 Year ago

    Get notifed when new similar jobs are uploaded

    Data Analysis Jobs

    Go Fund Me - Staff Data Analyst

    Go Fund Me

    San Francisco, California, United States (Hybrid)
    1 Month ago
    Sleeper - Data Scientist

    Sleeper

    San Francisco, California, United States (Remote)
    2 Months ago
    Glean - Staff Data Engineer

    Glean

    Bengaluru, Karnataka, India (Hybrid)
    3 Weeks ago
    Ion - LCM Data Analyst

    Ion

    Mumbai, Maharashtra, India (On-Site)
    9 Months ago
    Iron Mountain - Data Entry Analyst

    Iron Mountain

    Toluca, State Of Mexico, Mexico (On-Site)
    1 Week ago
    Apple - Software Engineer - Strategic Data Solutions

    Apple

    Austin, Texas, United States (On-Site)
    2 Weeks ago
    CD PROJEKT RED - Data Scientist

    CD PROJEKT RED

    Warsaw, Masovian Voivodeship, Poland (On-Site)
    3 Months ago
    Super.com - Manager, Data Analytics

    Super.com

    Canada (Remote)
    5 Months ago
    Nasdaq - Data Operations Analyst

    Nasdaq

    Taguig, Metro Manila, Philippines (Hybrid)
    1 Year ago
    Publicis Groupe - Senior Data Engineer

    Publicis Groupe

    London, England, United Kingdom (Hybrid)
    2 Weeks ago

    Get notifed when new similar jobs are uploaded

    About The Company

    New York, United States (On-Site)

    New York, United States (Hybrid)

    Boston, Massachusetts, United States (On-Site)

    Boston, Massachusetts, United States (On-Site)

    Boston, Massachusetts, United States (On-Site)

    Boston, Massachusetts, United States (On-Site)

    Boston, Massachusetts, United States (On-Site)

    New York, New York, United States (On-Site)

    Boston, Massachusetts, United States (On-Site)

    Boston, Massachusetts, United States (On-Site)

    View All Jobs

    Get notified when new jobs are added by Gupta Media

    Level Up Your Career in Game Development!

    Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

    Job Common Plug