The Intelligence department is seeking an entry-level Assistant Analyst to join the team responsible for championing a data-driven, holistic approach to marketing client productions, with a focus on sales and ticketing. The Assistant Analyst will directly support data analysis, reporting, and ticket programming for client productions. This is a full-time, regular, benefits-eligible position.
JOB RESPONSIBILITIES
- Data Analysis & Reporting:
- Administrate daily, weekly, and quarterly data analysis and reporting, focusing on sales activity and advertising effectiveness. Reporting includes but is not limited to: daily sales reporting, weekly client presentations, ad-hoc deep dives, data visualizations, heatmapping, and cross-channel analysis in collaboration with internal teams.
- Collect, organize, analyze, and interpret data sets from disparate sources with attention to detail and accuracy.
- Distribute timely and accurate reporting, including contextual insights and recommendations as needed.
- Ticket Programming:
- Create, submit, and revise ticket programming to support all aspects of inventory management. Programming includes but is not limited to: dynamic and variable pricing adjustments, performance scheduling, special promotions, distribution management, and group sales.
- Liaise with industry ticketing and box-office partners to implement programming across multiple ticketing systems.
- Assist with strategic pricing and programming recommendations as needed.
- Agency Resource:
- Develop a framework for dashboards integrating client data and internal agency databases.
- Assist in populating data to dashboards and databases on a daily, weekly, and ad-hoc basis.
- Cultivate a deep understanding of the Broadway and entertainment industries, seasonal variables, and the competitive landscape to be a resource for both clients and agency teams as needed.
JOB REQUIREMENTS
- Minimum 1-2 years’ experience in a data-driven role.
- Advanced Microsoft Excel skills required (Macros & VBA, SUMIFS, XLOOKUP, Pivot Tables, charting, etc.)
- Experience with other data analysis or business intelligence tools (Power BI, Tableau, etc.) a plus.
- Proficiency with reporting and working with large data sets required.
- Strong mathematical skills, analytical skills, and financial acumen required.
- Meticulous attention to detail and organizational skills required.
- Excellent communication skills, both written and in-person, are required.
- Ability to be available evenings and/or weekends may be required as needed.
- Experience in ticketing a plus.
- Experience in marketing or advertising a plus.
- Experience and/or interest in live entertainment a plus.