Data Analyst

About the role

Gupta Media is seeking a talented Data Analyst I to join our Strategy & Analytics team. In this role, you will assist with reporting, tracking, data analysis, advertising strategy, and visualization needs. You will work internally to support paid media analysts with reporting requests and externally to provide clients with insights into their advertising campaigns.

Responsibilities

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

Requirements

• Bachelor’s degree in a relevant field.
• Minimum of 1 year of experience working with complex datasets, preferably in a fast-paced environment.
• Experience with marketing data or paid advertising is a plus.
• Strong technical toolkit, including SQL, Excel, and Google Data Studio/Data Visualization.
• Day-to-day experience with SQL and comfort working with large datasets or documentation.
• Technical curiosity and resourcefulness, with the ability to navigate and understand technical documentation (e.g., APIs, software, or platforms) to troubleshoot or build solutions.
• Experience with Marketing APIs, BigQuery, Snowflake, ETL tools (Rivery, Supermetrics), or Python is a significant plus.
• Ability to communicate complex technical work clearly to non-technical audiences without losing meaning.
• Inherently resourceful, with a problem-solving mindset and drive to research, test, and find solutions.

Work Environment

Gupta Media is an office-first organization.

Benefits

• Competitive health, dental, vision, and pet insurance.
• Flexible and Dependent Care Savings Accounts.
• 401(k) with up to 5% Safe Harbor contributions.
• Paid time off and paid family leave.
• Commuting and wellness stipends.
• Opportunities for professional development and career growth.

Pay

Base salary range: $70,000 - $85,000, depending on relevant experience, skills, and qualifications. This role is eligible for participation in our annual bonus plan based on company performance.