Data Analyst - Royalty Reporting Systems
Job Number: FFE0004784
Organization: 20th Century Fox
Job Type: Finance/Accounting
Location: Los Angeles, California, United States
Job Posting Date: August 8, 2017

Job Description

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 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.


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 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
Division Description:

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.

Back to Search Results
New Job Search

Job Quick Search

By Job Type
By Business
By Location
By Language
Job Quick Search

By Job Type

By Business

By Location
By Language
We use first and third party cookies to improve our services, personalize your advertising, and remember your website preferences. If you continue to browse, you accept the use of cookies on our site. For more information (e.g. how to disable cookies), please see our cookie policy.