Analytics Analyst (LN Concerts)

Join the US Concerts Analytics team as an Analytics Analyst. In this role, you will use data to solve complex business problems, build and improve reports and dashboards, and support various areas including pricing, talent, touring, forecasting, and data management. You will work cross-functionally with business, finance, operations, and technical teams, and have regular exposure to senior leaders. This position is ideal for a self-starter with strong technical skills and a passion for the entertainment industry.

• Construire et maintenir des rapports récurrents, des tableaux de bord et des outils analytiques pour soutenir la division des concerts aux États-Unis, en mettant l'accent sur l'exactitude, l'évolutivité et l'automatisation.
• Écrire, dépanner et optimiser des requêtes SQL qui combinent plusieurs sources de données pour répondre aux questions commerciales et alimenter les rapports.
• Collaborer de manière transversale avec les équipes commerciales, financières, opérationnelles et techniques pour définir les questions, s'aligner sur les hypothèses et fournir des solutions analytiques utiles.

• Excel (required – high proficiency): build and maintain complex formulas, lookups, pivot tables, and dynamic array functions (e.g., FILTER, UNIQUE, XLOOKUP)
• Systems thinking: understands how source data, reporting logic, and final outputs connect to one another, so any number in a report can be traced back to its source; able to review existing formulas, queries, or dashboards and navigate BI tools to explain how outputs are produced
• AI tools (required): hands-on use of AI agents to accelerate, automate, and quality-check analytical work, with independent verification of outputs for accuracy
• Experience with Databricks, Tableau, and code-based programming (Python, R, etc.) is a plus
• SQL (required – high proficiency): independently write, troubleshoot, and optimize multi-source queries involving joins, filters, grouping, and aggregations
• Bachelor’s Degree (Finance, Economics, Statistics, IT, or related quantitative field)
• Adaptability and learning agility, with a track record of building new technical skills and business knowledge through research, practice, and feedback
• Strong written and verbal communication skills with technical partners, business stakeholders, and senior leadership
• 2+ years of experience in an analytical role such as management consulting, investment banking, data science, data analytics, or a related field
• Experience in live entertainment, ticketing, media, sports, hospitality, or another transaction-driven consumer business is a plus
• Ability to break down complex business questions into clear analytical steps and develop thoughtful, supportable, data-driven answers
• Strong Attention to detail and ability to critically evaluate data
• Self-sufficient problem solver who independently moves work forward, manages priorities, and evaluates solutions and next steps while still raising risks early, and knowing when to seek input
• Team-oriented mindset with a willingness to collaborate across functions with business stakeholders, support fellow team members, and contribute to shared goals
• Willing to work when necessary to help get overall team goals accomplished