Overview

Responsibilities:
This position is responsible for performing financial budgeting, forecasting, reporting and analysis functions integral to supporting the business operations of Columbia Records Group.

Responsibilities:

Preparation of Daily Sales reports highlighting actual sales performance versus monthly forecast.
Preparation of Weekly Priority Recap report comprising shipment, sales, streaming and marketing spend data for current priority releases.
Responsible for maintenance of the sales forecast databases, including data entry for monthly domestic album/track/stream forecasts, actualization of monthly sales/revenue and ensuring accuracy of pricing & configuration mix assumptions and release date information.
Responsible for update, maintenance, and submission of monthly SAMIS sales forecast.
Preparation of monthly Worldwide Revenue Forecast analysis reflecting full year impact of album/track sales and streaming activity versus business plan.
Develop and maintain queries to retrieve financial data from proprietary label and other financial systems (MS Access, SAP, SAP BW, SAMIS, SMART, etc.).
Generate Flash P&L reports for the Columbia label during the month-end financial close process.
Responsible for retrieval of physical sales, returns, and point of sale data for use in preparing the monthly/quarterly Sales Returns Reserve analysis.
Assist with preparation of the annual budget and monthly forecast of Intercompany Repertoire License (“IRL”) income, ensuring accuracy of accrual rates at the selection level and reconciliation/analysis of actual income received.
Assist with preparation of the annual budget and monthly analysis of Talent expense, including maintenance of the Artist Ledger to ensure proper coding of recording costs & advances and accuracy of royaltor/talent account cross-collateralization.
Assist in the review and analysis of monthly financial results including, but not limited to: researching SAP general ledger activity, preparing journal entries, analyzing account balances and transaction detail, balance sheet analysis, corporate reporting, etc.
Assist with preparation and compilation of various monthly financial schedules (P&L, revenue, talent, marketing) for inclusion in monthly financial reporting package for label senior management.
Assist in preparation of financial schedules in connection with periodic corporate senior management business review meetings.
Ad hoc special projects and analyses in support of on-going business operations and industry/market research.
Qualifications:
Bachelor’s degree with a concentration in Finance, Accounting or related field.
Working knowledge of GAAP, financial reporting preferred.
Ideal candidate may be working towards CPA certification, or interested in pursuing an MBA in the future.
Generally, a minimum 1-2 years of business experience in accounting or financial analysis role.