Overview

Responsibilities:
Review and approve Columbia employee travel requests and itineraries
Review Columbia employee expense reports in the Databasics system for compliance with overall company and business unit specific Travel & Entertainment (T&E) policies
Prepare purchase orders, related check requisitions, and process invoices for payment in connection with overhead related expenditures
Serve as primary Columbia label liaison with various corporate departments including Travel & Procurement, Accounts Payable, Travel Accounting, Information Systems & Technology (IS&T), and Telecommunications
Oversee certain aspects of the new employee on-boarding process as it relates to establishment of employee travel profiles, issuance of corporate credit cards, assignment of company equipment (computers, mobile devices, etc.), and T&E system access
Conduct periodic training sessions for Columbia label assistants/coordinators (and other staff) on topics such as use of Paperless Requisition System (PRS), company T&E policies, and use of T&E system
Prepare monthly Columbia label overhead spending forecast
Review and analyze monthly overhead expense including researching SAP general ledger activity, preparing/uploading of accrual, deferral and reclassification journal entries, analyzing account balances and transaction detail, etc.
Maintain T&E database model and prepare & issue monthly reports tracking actual travel & entertainment expenditures by employee/department versus budget
Maintain vendor payment database model and prepare monthly report to review spending by vendor and identify any unusual or excessive activity
Overall responsibility for reconciling monthly American Express charges to the Marketing Business Travel Account (BTA) and Promotion Business Travel Account (BTA) relating to artist travel in connection with promotional tours/appearances and non-employee travel in connection with radio contests, etc.
Overall responsibility for reconciling monthly American Express charges to the Touring & Events Corporate Meeting Cards (CMC’s) and Finance & Operations Corporate Meeting Card (CMC) relating to ticket buys, company meetings, wireless bills, showcases, listening parties and promotional events, etc.
Initiate IS&T and Telecommunications purchase requests and work orders in connection with computer hardware/software and mobile devices
Initiate commodity purchase requests in connection with furniture & fixtures, electronics, and other miscellaneous office supplies
Review and approve office supply orders initiated by Columbia label assistants and coordinators
Coordinate management of Columbia employee magazine subscriptions with Procurement department
Oversee Federal Express account management and review monthly shipping costs for reasonableness of amounts and business purpose; Supervise the monthly recharge of shipping costs to artist marketing budgets as applicable
Administer the Verizon and AT&T accounts relating to pooled wireless plans for Columbia departments/staff; Review monthly wireless invoices for unusual activity and reasonableness of charges
Administer service agreements and subscriptions with various third party product/service providers (e.g., Quench, SlideRocket, MailChimp, etc.)
Oversee RideWell Transportation account management and supervise processing of invoices for payment and chargeback to marketing and overhead budgets as applicable
Oversee the review of monthly SCA telecommunications activity reports
Investigate the nature of miscellaneous incoming cash receipts and determine appropriate accounting disposition; Supervise the preparation of PRS credit memos and processing of related check deposits
Edit PRS purchase orders initiated by marketing coordinators as necessary prior to routing for final financial approval
Maintain/update database of Columbia equipment inventory (computers, mobile devices, etc.)
Ad hoc special projects and analyses for Columbia Head of Finance & Operations
Qualifications:
A self-motivated individual with a positive attitude and work ethic, willingness to learn, eagerness to work in a recorded music company, and ability to thrive in a dynamic team environment
Recent college graduate; ideal candidate may have 1-2 years of work experience in an operations, accounting or business administration role
Proficient in Microsoft Excel and ability to quickly learn proprietary company systems and other applications
Good verbal, writing and interpersonal skills, with ability to communicate with a wide range of individuals both inside and outside the company in a professional manner
Well organized, detail oriented with ability to work under pressure and meet deadlines while managing multiple concurrent tasks
Experience with general ledger accounting systems (in general) and SAP business software (in particular) a strong plus