Reporting Executive, Ticketing

Company: Live Nation

Department: Management Information (Ticketing)

Location: Farringdon, London, hybrid working from home

Reports to: Management Information Analyst

Working Hours: 40 hours/week, Mon-Fri. Applications for flexible working hours considered however, availability on Mondays 9am and Thursdays 9am is essential

Role Description

An exciting opportunity to utilise your SQL, SSRS and Excel skills to produce ticketing focussed reports and provide management information (MI) to support business decision-making within the largest concert promoter in the UK.

Who you are

You may have experience in the following roles: SQL Exec, Data Analyst, Reporting Executive, Management Information Analyst, Ticketing Analyst, Event Ticketing Manager                          

Competencies / Skills / Knowledge / Experience

• Demonstrable experience writing SQL queries (including CTEs, views, stored procedures) and creating automated SSRS reports is essential
• Demonstrable knowledge and experience of using MS Excel to an advanced level is essential
• Experience with other data visualisation / BI tools a bonus.
• Excellent numeracy skills with an exceptional attention to detail.
• Clear and concise written communication skills.
• Previous experience of reporting on and analysing data, ideally in a ticketing environment
• Previous experience of live event ticketing and/or live music industry is preferred.

Behaviours

The following attributes determine how the role will be carried out and are required to be a success

• Uses interpersonal skills to establish excellent rapport and working relationships with a wide range of colleagues
• Confident making technical information easy to understand for non-technical colleagues
• Uses initiative to identify issues and create solutions
• Process driven, well organised, deadline-focussed and adept at prioritising workloads
• Combines analytical thought with creativity to excel at problem-solving
• Maintains good commercial awareness and understands business drivers

What the role includes

• Design, build, maintain and improve reporting solutions using SQL, SSRS and other business intelligence tools
• Gather reporting requirements from stakeholders and translate into SQL scripts / automated SSRS reporting solutions
• Deliver, manage and improve daily and weekly Excel-based ticketing reports for distribution to the wider business
• Proactively engage with a wide range of colleagues to identify operational processes that would benefit from automated reporting; working closely with all departments to create efficient solutions
• Proactively engage with current reporting processes to identify improvements to increase reporting capability and efficiency
• Maintain data integrity throughout Live Nation Event Ticketing’s database (EOS)
• Deliver small to medium size reporting & analysis projects when required.
• Support Management Information team in any other management information duties as required & provide cover in their absence
• Assist Event Ticketing team with any reporting, processes or general administration as required

Equal Opportunities

We are passionate and committed to our people and go beyond the rhetoric of diversity and inclusion.  You will be working in an inclusive environment and be encouraged to bring your whole self to work.  We will do all that we can to help you successfully balance your work and homelife.  As a growing business we will encourage you to develop your professional and personal aspirations, enjoy new experiences, and learn from the talented people you will be working with.  It’s talent that matters to us and we encourage applications from people irrespective of their gender, race, sexual orientation, religion, age, disability status or caring responsibilities.

The Company

Live Nation Entertainment is the world’s leading live entertainment company, comprised of global market leaders: Ticketmaster, Live Nation Concerts, and Live Nation Media & Sponsorship. Ticketmaster is the global leader in event ticketing with over 500 million tickets sold annually and more than 12,000 clients worldwide.  Live Nation Concerts is the largest provider of live entertainment in the world promoting more than 40,000 shows and 100+ festivals annually for nearly 4,000 artists in over 40 countries. These businesses allow Live Nation Media & Sponsorship to create strategic music marketing programs that connect over 1,000 brands with the 98 million fans that attend Live Nation Entertainment events each year. For additional information, visit www.livenationentertainment.com