Royalty Reporting
20th Century Fox
Los Angeles, CAThis was removed by the employer on 10/14/2014 4:12:00 PM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the Accounting/Finance Category
Browse the Studio Category
Search for Royalty Reporting jobs in Los Angeles-CA
Search all Royalty Reporting postings
Full Time Job
Responsibilities:
•Update Media Maestro database (Royalties System) calculation tables and data file attributes required for processing data from interfacing systems
•Perform monthly data file loading into Royalties System, including monthly data calculations, system data adjustments, as required, PeopleSoft file uploading and Hightail FPT processes
•Maintain department's monthly data processing schedule and research archives
•Perform reconciliations on financial data for accuracy in Excel, Access or Royalties system
•Research system data exceptions for resolution by supervisor or directors
•Troubleshoot data processing issues and report to supervisor for resolution
•Utilize Microsoft Office and various PC applications daily
•Maintain a detailed audit trail of all data verifications and organized files
•Other tasks as assigned
Qualifications:
•Bachelor's Degree in Information Technology or Math, Accounting or Finance with Information Technology classes
•Minimum two years of job-related experience in Accounting or Finance with proven strong data analysis skills
•Minimum one year experience with text file structures to sort, search, replace and extract data within the text file
•Minimum two years of experience working with data in relational databases using MS Access and/or Qlikview programs to join tables, create queries, design reports and export data into Excel. Visual Basic programming skills, a plus
•Must be proficient in Excel
- Especially with pivot tables to sort, group and summarize data
- Must be able to export/import to and from text file
•Must be able to work independently, multi-task, and meet strict deadlines
•Excellent detail tasks and research skills
•Excellent communication skills
20th Century Fox Film is one of the world's largest producers and distributors of motion pictures. 20th Century Fox Film produces, acquires and distributes motion pictures throughout the world. These motion pictures are produced or acquired by the following units of 20th Century Fox Film: Twentieth Century Fox, Fox 2000 Pictures, Fox Searchlight Pictures, Fox International Productions, and Twentieth Century Fox Animation.?