Film Hire Analyst

Job Description

Majid Al Futtaim invites you to join us in our quest to create great moments for everyone, everyday! We are the leading shopping mall, residential communities, retail and leisure pioneer across the Middle East, Africa and Asia, serving over 560 million visitors a year. For the past two decades, we have shaped the consumer landscape across the region, transforming the way people shop, live and play, while maintaining a strong sustainability track record and the largest mall in the world to attain LEED Gold EBOM Certification. We have over 40,000 team members in 15 international markets representing over 100 nationalities all keeping the customer at the heart of everything we do. If you enjoy being BOLD, PASSIONATE and TOGETHER, then Majid Al Futtaim is the destination for you.Role Purpose:This role reports to the Finance Manager and responsible for conducting regular cinema checks and audit, analysis of Ticket Prices and Promotions offered by Exhibitors, and any other activities that impacts Film Hire. This new role will provide additional layer of due diligence and assurance for the Studio that our reporting is as accurate as possible and that the reports from Exhibitors are analyzed on a regular basis. This role will oversee and help Finance Executive to ensure that Daily Reporting will not be impacted during busy or crowded period with back to back releases. This role will also work closely with Finance Manager to help on other Analysis and Reporting. Role Details Key Responsibilities and Accountabilities:Film Hire Analysis:

• Responsible for keeping track and reporting of all ongoing and new promotions being offered by the Exhibitors across all markets.
• Includes checking of exhibitor website and other social media pages to document those promotions and offers.
• Proactively report any promotions and offers that massively erode ticket prices.
• Analyze and create a report to showcase the impact of those promotions especially on Gross Box Office and Film Hire by movie releases.
• Regularly check ticket prices appearing in Daily Collection Report, keep track of the ticket pricing and report any material deviations especially those that cannot be verified against exhibitors website.
• Coordinate or flag any material issues to Sales and Distribution team if required to further discuss any issues with Exhibitors.
• Ensure that any special Film Hire agreements and/or adjustments agreed upon with Exhibitors should be Invoiced and collected from Exhibitors.
• Ensure that we receive sufficient data from Daily Collection Reports to enable regular analysis (i.e. includes session details, ticket types and others).  
• Ensure that any complimentary tickets are within the acceptable level while ensuring that the issuance of such complimentary tickets are within the acceptable terms.
• Ensure that we eliminate manual reporting (i.e. excel file, figures provided via WhatsApp or on body of email only). Ensure that we receive appropriate system reports that are in pdf format.
• Understand and keep track on any Loyalty schemes and offers, and its impact to ticket prices and film hire.
• Ensure that Film Hire and calculations appearing in Distributors Report are correct and matching with Sales Invoicing.
• Set up a regular reconciliation process with Exhibitors to ensure accuracy of tabulations and reporting.

 Cinema Checks / Field Audit:

• Create an audit plan to validate the accuracy of reported admissions and GBO in Daily Collection Reports.
• Includes checking of Exhibitor website, random counting of tickets sold before a session starts and validate against the admits being reported in Daily Collections Report.
• May Include actual purchasing of tickets in Exhibitor website to check the accuracy of reporting in Daily Collections Report.
• Creating a log to document the audit, then report and flag to management any material variances above the acceptable level.
• Includes physically going to cinemas to buy tickets to conduct audit activities.
• Oversee any audit or cinema check to be conducted by 3rd party vendor, if required by the studio.
• Coordinate or flag any material issues to Sales and Distribution team if required to further discuss any issues with Exhibitors.

 Others

• Validate on the accuracy of Distributors Report prepared by the Finance Executive.
• Assist Finance Executive on Distributors Report if needed, ensure that reports are completed and circulated before or within the Studios reporting deadlines.
• Oversee the month end closing activities for Revenues, ensuring that Revenue are calculated properly and reconciled with Distributors Report.
• Keep track of Studio Control Accounts in AX and endorse any adjustments if required.
• Assist Finance Manager in creating a monthly Statements to Studio.
• Ensure timely payments of monthly Statements to Studio.
• Coordinate with Global Solutions team, CPO team and other stakeholders for any system and process requirements if needed.
• Assist Finance Manager on any Adhoc Analysis, Reporting and other month end activities.
• Handle automation of the Daily Distributor Reports tabulation, a project that will eliminate or minimize manual tabulation of Daily Collection Reports from Exhibitors and will result to a faster and more accurate reporting of Box Office results as well.

  Other Context (if applicable):

• Be a culture ambassador that reflects the organizations values, encourages good performance, and rewards productivity
• Be able to deliver without supervision
• Awareness of nature of operations and operational issues of various business units

Functional/Technical Competencies

• Intermediate to advanced knowledge of Excel is a must
• Internal or external audit experience is an advantage
• Understanding of the Cinema industry is an advantage
• Problem solving ability
• Ability to multi-task, and manage time wisely
• Flexibility to work on weekends and holidays if required

 Personal Characteristics and Required Background:

Keyskills :