Manager, SMB Revenue & Subscriber Forecasting

JOB SUMMARY
Support the revenue planning and forecasting process of Charter Communications’ $4B Small and Medium Business (SMB) operating unit that encompasses Internet, Voice, Video, and Mobile product lines. Develop an analytical framework to effectively forecast and measure subscriber and revenue performance.

MAJOR DUTIES AND RESPONSIBILITIES

• Support SMB sales, subscriber, and revenue forecasts
• Support month end close process
• Assist Offer Management team in developing new pricing / promotion initiatives
• Ad Hoc / Special Projects

Support SMB Sales, Subscriber, and Revenue Forecasts:

• Revenue
  • Maintain and continuously enhance forecast models
  • Create financial / operating models to support ad hoc management requests
  • Leverage Accounting and BI platforms (Hyperion / Essbase / Micro Strategy / Tableau) to access underlying performance data to derive forecast assumptions
• Subscriber / Customer Forecasting
  • Partner with subscriber metrics team to develop a product level statistical budget and forecast
  • Identify operational drivers behind churn, subscriber migration, and other key metrics to validate projection assumptions

Support Month End Close Process

• Identify performance drivers and reasons for revenue, statistical, and ARPU variance to plan
• Provide variance commentary to senior management
• Identify areas of risk and performance improvement opportunities
• Continuously enhance executive key performance indicators (KPI) dashboard

Assist Offer Management Team in Developing New Pricing / Promotion Initiatives

• Support new pricing and product introduction initiatives
• Provide detailed analytics to support campaign effectiveness and realization
• Perform revenue assurance activities to identify non-compliant operating activity

Ad Hoc / Special Projects

• Assist in executive reporting / analysis requests
• Perform in depth analysis on high value activity

REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge

• Ability to read, write and speak the English language to communicate with employees, customers, suppliers, in person, on the phone, and by written communications in a clear, straight-forward, and professional manner
• Ability to manage multiple projects and priorities demanding a rigorous attention to detail
• Strong Microsoft Office skills (Excel, PowerPoint, etc.)
• Experience with business intelligence and analytics tools (i.e. Micro Strategy, Tableau, etc.)
• Experience with Financial Reporting tools (Hyperion, Essbase, PeopleSoft, and SAP etc.)
• Knowledge of budgets, P&L reports, systems, and procedures
• Ability to professionally interact with and influence others
• Ability to build and foster collaborative relationships inside or outside the organization
• Strong leadership, communication, presentation, and interpersonal skills
• Enthusiastic about relevant topic or skill, pushes boundaries, intelligent, likes to learn, ability to turn findings into executable plans
• Ability to interpret and structure complex customer and revenue data and translate analysis into executive-level presentations

Education
Bachelor’s degree in Finance or related field
Master’s degree in Finance or related field preferred, but not required

Related Work Experience
2-5+ years: Budget and forecasting preparation or related experience
2-5+ years: Financial or revenue analysis experience

PREFERRED QUALIFICATIONS
Skills/Abilities and Knowledge
Exceptional Excel modeling and PowerPoint skills
Working understanding of SQL and / or other analytical tools (or ability to learn)

WORKING CONDITIONS
Office environment
Exposure to moderate level of noise