Financial Pricing & Planning Intern - Media

Client Reference Code: 189266
INTERNSHIP REQUIREMENTS

• This position is part of our Summer Paid Internship Program.
• Internship will last between June and August. Approximately 10 weeks.
• Must have at least a 3.0 GPA or greater
• You must currently be enrolled in an educational institution and be returning in the Fall.

Spectrum Reach is the advertising sales division of Charter Communications, Inc. The company offers custom solutions for the modern media landscape utilizing national cable networks, internet advertising and promotional events supported by marketing, research and award-winning creative services. Spectrum Reach applies insightful research to understand consumer behavior and build targeted, multi-screen media plans personalized for each customer.

With offices in 41 states and 147 markets, Spectrum Reach covers over 27 million households throughout the country. From traditional commercial advertising to exciting new possibilities in interactive media and multi-screen solutions, Spectrum Reach’s consultative team brings advertisers effective, efficient ways to turn our audiences into their customers.

SUMMARY

The Planning, Pricing and Inventory Intern, part of the Planning, Pricing and Inventory (PPI) team, supports local linear inventory planning and special projects in support of the PPI senior management team.

The intern will support the PPI team with data analysis, key performance indicator (KPI) design and implementation, construction of pricing and analytical models, exploration of new potential packaging approaches, and support for PPI’s eight workgroups.

MAJOR DUTIES AND RESPONSIBILITIES

Data Analysis

With guidance from PPI senior management team, critically evaluate linear pricing and inventory data to determine performance levels, identify patterns and trends and develop guidance for markets. Summarize findings for PPI team and participate in performance discussions with Sales, Finance and PPI personnel.

KPI Design and Implementation

Work with PPI senior management team to develop, design and implement key performance measures around linear pricing and inventory utilization. Socialize measures with Sales, Finance and PPI personnel and assist Reporting & Analysis workgroup in designing frequency-based reporting for both standalone use and eventual use in Salesforce.com.

Construction of Pricing and Analytical Models

Work with Pricing Analytics & Tools workgroup to develop sophisticated quantitative modeling for linear pricing to incorporate not only simple characteristics of demand (viewership) and supply (quantity discounts/available inventory), but also to include aspects of perishable inventory valuation (e.g., time-based changes in valuation based on remaining days to availability position). Contribute thinking to appropriate balance in pricing control among base rate card design, packaging variants, proposal valuation and time-based discounting.

Exploration of New Packaging Approaches

Work with Inventory Planning workgroup to critically evaluate current linear grid designs and allocation strategies across the full Spectrum Reach footprint. Work with PPI content workgroups, Sales and Marketing leaders to investigate and socialize potential new approaches to inventory packaging to maximize yield.

Workgroup Support

In addition to coordination activities listed above, support PP’s 8 workgroups in identifying current Spectrum Reach best practices, developing recommendations for revenue and service improvement, and coordinating change management across the PPI process.

Four of these workgroups are focused on improving content-related results:

• News - improve support of our owned and operated news and information networks, as well as national news and information networks, such as Fox News, CNN and The Weather Channel;
• Sports - improve support of our owned and operated sports networks, as well as RSNs and national sports networks, such as ESPN, Fox Sports One and NBC Sports Network;
• Political - improve support of our political advertising process, including internal coordination, development/enhancement of clear procedural documentation and training, improving NCC interfacing, improving reporting, etc.;
• Tune-In - improve support for our tune-in category, including support for multi-market proposals and placement, clarifying sub-interconnect (e.g., IC less DTV) inventory planning and ensuring consistency in pricing of tune-in proposals and orders

Another four of these workgroups are focused on improving internal processes and capabilities:

• Pricing Analytics & Tools - improve the PPI process and toolset for pricing analysis and predictive modeling and ensure that outbound systems that will touch inventory systems (e.g., programmatic, small business portal, etc.) are properly coordinated and reflect PPI philosophy;
• Reporting & Analysis – develop user-friendly, automated report sets appropriate for PPI personnel, field Finance, Sales leadership (all levels) and senior management;
• Inventory Planning – develop best practices for inventory allocation, typing and management and establish consistent practices for packaging across the SR footprint;
• Training & Development - improve processes for training/knowledge transfer through the PPI group, establish mentoring relationships and identify skill set development activities to boost PPI team’s potential and capabilities

REQUIRED QUALIFICATIONS

• Strong interpersonal and analytical skills required.
• Experience in college media or related field.
• Quantitative aptitude and familiarity with MS Office application suite required.

EDUCATION PREFERENCE

• Rising seniors with an interest in pricing and data analysis preferred.
• Major in business, finance, economics, mathematics, computer science or media preferred, but all backgrounds will be considered.

Job Code : TWCGIR060 Intern Nonexempt

189266BR