Film Analyst

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Regular and Consistent Attendance
• Collaborate with the Film department to understand and address their BI and analytical needs.
• Utilize SQL and Python to extract, manipulate, and analyze data from various sources in support of analytical requirements.
• Create new and convert existing reporting in modern BI platforms (Power BI, Vista Horizon).
• Develop and maintain actionable dashboards using Excel and Power BI, delivering insights to stakeholders in a clear and actionable manner.
• Track, optimize, and audit the booking of films and scheduling of showtimes to maximize market share potential, ensuring theatre compliancy of scheduling and pricing, and providing actionable recommendations.
• Conduct competitive analysis to understand key success factors in each market, driving strategic positioning within the industry.
• Develop more robust tracking of advance film sales to better forecast and strategize film performance.
• Maintain a comprehensive competitor data catalogue, including theatre and auditorium metadata, ticket prices, and amenities.
• Catalogue film-specific data such as on-sale dates, forecasts, early access dates, and demographics.
• Present analytical findings to stakeholders, providing recommendations to enhance film strategies and operations.

Qualifications :

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and / or ability required.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Professional Skills :

• Desire to work in a fast-paced environment.
• Excellent computer skills
• Excellent communication skills
• Ability to multi-task and distinguish high-priority matters
• Excellent reasoning and analytical skills
• Excellent organizational skills.
• Must be self-motivated with a strong ability to prioritize and recognize critical situations that need immediate attention.
• Must be detail-oriented and produce both a high quality and a high volume of work in a timely manner

Education / Experience :

• Bachelor's degree in Business Analytics, Data Science, Computer Science or another analytically focused field (Master's degree is a strong plus).
• 3-5 years of experience in an analytical role, preferably within the film or entertainment industry.
• Proficiency in writing complex and optimized SQL queries.
• Advanced Excel skills, including Power Query, DAX, and complex formulas.
• Experience building actionable, KPI-driven dashboards in Power BI.
• Solid experience with Python for data manipulation, analysis, and visualization; experience with web scraping a plus.
• Strong analytical and problem-solving skills for interpreting complex data sets.
• Excellent communication skills, with the ability to convey complex data insights clearly to both technical and non-technical audiences.
• Detail-oriented with a strong commitment to data accuracy and quality.
• Ability to understand market dynamics and contribute to strategic positioning.

Certificates, Licenses, Registrations :

None

Language Ability :

Must have good reading, writing, and speaking skills to effectively communicate with studios, managers, and co-workers.

Math Ability :

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.

Ability to compute rate, ratio, and percent, and to develop and interpret charts.

Reasoning Ability :

Perform under pressure and / or opposition at times relying on your own independent judgment and knowledge to decide the best directions and solutions.

Computer Skills :

Microsoft Outlook, Word, Excel, database software

Supervisory Responsibilities :

This position has no direct supervisory responsibilities.

Work Environment :

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

The noise level in the environment is moderate.

Physical Demands :

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

While performing the duties of this job the employee is frequently required to stand, walk, sit, and use hands to finger, handle, or feel;

reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl and talk or hear. The vision requirements include close vision, distance vision, peripheral vision, depth perception, and the ability to adjust focus.

The employee is occasionally required to lift up to 50 pounds.