Associate Data Analyst

Beyond presenting outstanding performances by the world’s greatest musicians, our mission as a not-for-profit organization is to develop broader, more diverse audiences and performers in the music industry with our Reach Teach Play® community engagement and education programs, our Steans Institute’s collaborative and experiential artistic training programs, and more. Together, Ravinia’s initiatives serve tens of thousands of students, families, and emerging professional musicians.

Our 36-acre park is home to North America’s longest-running outdoor music festival and its most artistically diverse. Over 100 different events, featuring a mix of classical, rock, pop, jazz, R&B, indie, and country performers, make up a typical summer season across our open-air and indoor stages, including the annual residency of the Chicago Symphony Orchestra.

Position Summary

The Data Analytics & Research Team (DART) is responsible for providing strategic support to all departments and teams at Ravinia to develop a more data-driven decision-making culture. Our primary aim is to help teams Reduce Risks, Increase Revenues, and Widen Impact.

Reporting to the Associate Director of DART, Ravinia is seeking an early-career Data Analyst with strong technical skills to join our team. You will conduct meticulous and accurate analysis of Ravinia data; join data quality and data assurance efforts; and work with the Manager of Software Development to ensure accurate ETL for Tableau, our Business Intelligence tool.

The ideal candidate will be proactive, curious, and have a desire to learn and grow. Cultivating good relationships across multiple departments is a vital aspect of the role

Key Responsibilities

Reporting, Data Visualization, and Analysis: 45%

• Tableau Dashboards: maintain existing and create new dashboards with the intention of automation and self-service. The goal is to provide the right data, at the right time, to the right audience
• Use data to continually tell stories and help the organization learn more about our audiences, donors, and outreach programs to deliver a memorable guest experience
• Contribute to developing and presenting reports that summarize insights for Ravinia management, governing bodies, and volunteer leadership
• Join a weekly team meeting focused on project management and timelines
• Stay up to date on the latest trends and tools in the industry

• Work with other data stakeholders to ensure consistent and accurate data
• Create and maintain data dictionaries
• Create documentation for new and existing processes
• Collect, clean, and prepare business data for reporting and analysis.
• Combine large and disparate data sources for ad-hoc analysis. Data sources include our data warehouse and various other external sources
• Translate back-end, raw data from ticketing and other sources into meaningful categorizations and reporting for the business
• Join the Ravinia Data Forum and additional task forces relevant to these issues

• Work with colleagues in IT to maintain, enhance, and expand the data pipelines flowing into and out of the Ravinia Data Warehouse
• Create/update/maintain documentation on requirements and business processes

• Education: Bachelor's degree or equivalent experience
• Experience: 1+ years in an Analytics, Data Quality, or Data Support role
• Skills:
  • Developing business acumen and the application of data and insights to business strategy
  • Developing written and verbal communication skills, including the ability to present complex data and research findings to non-technical audiences
  • Exceptional spreadsheet and slide deck skills
  • Proficiency in Python or R, experience with SQL
  • Some experience building and interpreting Tableau dashboards and reports (or equivalent visualization/BI software)
  • Familiarity with relational databases and data warehouses
  • A growth mindset: curiosity and willingness to identify knowledge gaps and learn new things to acquire skills
  • Desire to work for a non-profit performing arts institution

• Develops a strong understanding of Ravinia’s audience segments, ticket buyers, and engagement patterns
• Applies data-driven analysis to inform and respond to business questions posed to DART
• Builds effective, trust-based relationships with colleagues across departments
• Demonstrates curiosity and openness to learning new tools, methods, and organizational context

Work Environment

This is a full-time hybrid position based at Ravinia Park in Highland Park, IL.

This role will primarily operate during business hours (9:30 am—5:30 pm). Your work schedule will flex based on the time of year. During the height of the summer concert season, typically from May to September, DART will work on location Monday through Thursday, with Fridays being remote. During the off-season, typically October through April, DART switches to a Monday and Friday remote schedule.