This job has expired, please see additional jobs below
Pricing & Planning Intern - Media (Summer)
Spectrum
Dallas, TX, United States
Job Details - this job has expired, please see similar jobs below
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.
INTERNSHIP REQUIREMENTS
• This position is part of our Summer Paid Internship Program.
• Internship will last between late May to 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 or recently graduating in May 2018.
JOB 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
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.
PREFERRED QUALIFICATIONS
Strong written and oral communication skills, with an emphasis on learning through listening.
Creativity and pattern recognition skills.
Ability to manage multiple priorities simultaneously, working efficiently and effectively under tight deadlines.
.