Finance Analyst, Consolidations and Reporting - Media
Location:
Charlotte , North Carolina
Posted:
October 16, 2017
Reference:
203145BR
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.

JOB SUMMARY
Supports the financial consolidation and reporting needs of the Spectrum Reach Finance team and serves as the main writer and keeper of the extensive report library .
Responsible for assisting Director in all aspects of management reporting on monthly, quarterly and annual basis.

MAJOR DUTIES AND RESPONSIBILITIES
  • Develop, prepare, analyze and maintain library of reports for finance team and management utilization
  • Create and distribute templates and supporting schedules used by finance teams for budgeting, forecasting and presentation purposes
  • Assist the Director with the annual budget and quarterly forecast process and preparation of presentation packages
  • Prepare and distribute daily update of financials throughout the monthly close process
  • Assist in preparation of weekly Line of Business (LOB) Dashboard report
  • Preparation of monthly management report for senior team review
  • Coordinate revenue and operating expense variance analysis for monthly, quarterly and annual reporting
  • Maintain calendar for quarterly forecast and budget review meetings and reporting deadlines
  • Coordinate scheduling of quarterly forecast and budget review meetings with executive assistants of senior management
  • Periodically update templates/reports for new accounts, rollups, structures, etc.
  • Serve as liaison to Hyperion Essbase group
  • Serve as go-to person within Finance team for Essbase-related questions
  • Extensive ad hoc report creation
  • Perform other duties as required

PREFERRED QUALIFICATIONS
  • Essbase experience required
  • Ability to analyze and interpret data
  • Ability to work independently; highly motivated and detail-oriented
  • Ability to plan, prioritize and organize effectively
  • Ability to thoroughly test models and proactively identify solutions
  • Ability to make independent decisions and solve problems while working under pressure
  • Ability to communicate with all levels of management and company personnel
  • Ability to work with others to resolve problems, handle requests or situations
  • Ability to handle multiple projects and tasks
  • Knowledge of budgeting tools and procedures
  • Advanced knowledge of personal computer and software applications (i.e., Essbase, spreadsheet, Powerpoint, word processing, macros and formulas)

Education
Bachelor’s degree in Business Administration, Accounting, Finance or related field, or equivalent experience

Related Work Experience Number of Years
Data reporting and analytical experience 4+
Heavy Essbase report writing experience 4+
Consolidations experience 2+
Office Environment 2+

A little about us:
Spectrum is the nation’s fastest growing TV, internet and voice company. We’re committed to integrating the highest quality service with superior entertainment and communications products.

Know someone who would be interested in this job? Share it with your network.