Insights & Analytics Intern (Summer 2027)

Horizon Media; New York (NY); Hybrid; USD 28,000 - 41,000; Full time

Job summary

Horizon Media invites ambitious undergraduates to join the Summer Intern program in a hybrid set‑up (NY or LA) with three days in the office. This full‑time paid internship runs mid‑June to mid‑August 2027, totaling 40 hours per week, and offers exposure to media planning, analytics, and client work.

You’ll participate in trainings, work on an intern project, and gain hands‑on experience with Excel, PowerPoint, SQL/Python/R, and Tableau.

Qualifications

• A currently enrolled undergraduate student in an associates or bachelor's program.
• Interest in media, advertising, research, and/or analytics.
• Analytical thinker able to tell stories with data.
• Comfort with Excel and PowerPoint for campaign support.
• Support DEI & Belonging initiatives and teamwork.

Responsibilities

• Participate in meetings and trainings to learn media strategies.
• Support discipline-specific tasks and intern project execution.
• Assist with data gathering, analysis, and reporting for campaigns.
• Collaborate with cross-functional teams to contextualize insights.

Skills

Analytical thinking

Data storytelling

Excel

PowerPoint

Media analytics

DEI advocacy

Education

Undergraduate student

Tools

SQL

Python

R

Tableau

Excel

PowerPoint

Job description

Horizon 2027 Summer Intern

If you’re curious about the intersection of marketing and tech, are passionate about learning, and are ready to launch your career, we want you to join us this summer!
Full-Time Paid Summer Internship (40 hours/week)
Internship Dates: mid-June – mid-August 2027
Location: Hybrid (NY or LA), three days in office

Who We Are
Horizon Media, founded in 1989 by Bill Koenigsberg, is recognized as one of the most innovative marketing and advertising firms. We are headquartered in New York City, with offices in Los Angeles and Toronto. A leader in driving business solutions for marketers, Horizon is known for its highly personal approach to client service.Renowned for its incredible culture, Horizon is consistently named to all the prestigious annual Best Places to Work lists published by Fortune, AdAge, Crain’s New York Business, and Los Angeles Business Journal. Together we are building a place of belonging.
At Horizon, we understand the value that different perspectives can bring to our clients and culture, so we strive for an environment where our employees feel welcomed, safe, and empowered. We value YOU and believe that your authentic voice and unique perspective allows us to create a more rewarding culture, and experience, together.
Our simple recipe for success? We hire talented people (thinkers, doers, dreamers, makers), challenge them, and give them every opportunity to grow.

What is Media:

Media is the business side of advertising. What good is a great ad campaign if the right people don’t see or experience it? We media enthusiasts ensure that the brands we work with connect with the right people, at the right time, in the right place.

Why Media:

Professionals in this industry come from various backgrounds, but at least one thing they have in common is their passion for media. They love that media is the intersection of strategy, technology, analytics, innovation, and creativity.

Job Summary

What You’ll Do:

• Meetings / Trainings – 25%

• Discipline specific tasks – 35%

• Intern project – 20%

• Organization – 10%

• Administrative – 10%

What You’ll Learn:

• An understanding of strategy and execution of media campaigns

• An overview of the media ecosystem, including Horizon Media’s approach to client service and cutting-edge work product

• The makeup and functions of our various departments

• How we partner with our clients to support their business through robust marketing strategy, advertising plans, and media activations

• The ins and outs of both syndicated and proprietary media research tools and systems

• A quantitative and qualitative understanding of research, media plan cost exercises, competitive studies, media reporting, and key media considerations when building media plans (i.e., demographics, target audiences, key sales seasonality, geography, media channel selection)

• Knowledge of Microsoft Office (primarily Excel and PowerPoint) to help support media campaign efforts

• How to partner with fellow interns to create and present a final intern project to the agency

• So much more through our Media trainings, field trips, and relationships with your manager and mentor

Who You Are:

• A currently enrolled student in an undergraduate program (associates or bachelors)

• Interested in media, advertising, research, and/or analytics

• An analytical thinker with excellent math skills and a love for telling stories using data

• An experienced Excel and/or PowerPoint guru

• An advocate and supporter of DEI & Belonging

• Able to work onsite in our New York or Los Angeles office locations at your own expense for the full duration of the internship

Preferred Skills & Experience

• Write and leverage SQL, Python, and/or R to gather, clean, and manipulate data for analysis and reporting.

• Build and maintain custom Tableau dashboards to translate complex data into clear, actionable insights for internal and external stakeholders.

• Analyze data in multiple formats — including dashboards and raw datasets — to surface insights, evaluate performance, and recommend optimizations.

• Assist in statistical modeling and marketing performanceanalysis to support media planning and buying decisions.

• Help compile client‑facing reports showcasing campaign impact on media and brand goals.

• Collaborate with cross‑functional teams and external partners to contextualize media performance and strengthen storytelling for clients.

• Use automation and technology to streamline recurring deliverables and improve team efficiency and scalability.

• Lead an assignment focused on improving the team’s analytical accuracy, efficiency, or infrastructure, applying best practices and fresh perspectives.

Certificates, Licenses and Registrations
N/A
Physical Activity and Work Environment
N/A

The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties and skills required of personnel so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer.