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 departments 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
Trouble shoot 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
This is an Union role.
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 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.
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, disability, protected veteran status, or any other characteristic protected by law.