Data Analyst

Position Title: Data Analyst

Reports To: Associate Director of DART

Range:  $60,000-$75,000

Company Description

Ravinia is North America's longest-running not-for-profit music festival and its most artistically diverse. Over 100 different events by a mix of classical, rock, pop, jazz, R&B, indie, and country performers make up a typical summer season on our two open-air and two indoor stages. Each year the Chicago Symphony Orchestra is featured in six weeks of concerts, many with Chief Conductor Marin Alsop. During the same summer months, the Ravinia Steans Music Institute provides young professional classical and jazz musicians with career-advancing training and concert settings.

Offstage and year-round, Ravinia's Reach Teach Play education programs engage 85,000 children and adults—in schools with little to no music curriculum, in our Chicagoland communities, and at our 36-acre park—in our mission to make music equitably accessible to all.

Ravinia embraces diversity in all forms and is committed to providing an equitable and inclusive environment for all staff, musicians, guest artists, audiences, and community members. Ravinia is proud to be an equal-opportunity employer. We encourage individuals of all identities and abilities to apply.

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

Data Quality and Data Validation: 45%

• 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

Data Pipeline, Data Structure, and ETL: 10%

• 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

Other tasks as assigned

Qualifications

• 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

Success Factors

• 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.

DART will provide opportunities for professional development for learning and career growth, including attendance at industry conferences.

Benefits

Excellent health and welfare benefits including comprehensive time off, generous retirement savings plans, learning and mentorship opportunities, access to various staff working groups, and a general admission season pass to Ravinia events.