Associate Data Analyst

Ravinia Festival is North America’s longest-running not-for-profit music festival, known for its diverse artistic offerings. They are seeking an early-career Data Analyst to provide strategic support through data-driven decision-making, focusing on data analysis, quality, and visualization.

Responsibilities

• Maintain existing and create new dashboards with the intention of automation and self-service
• 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
• Other tasks as assigned

Skills

• Education: Bachelor's degree or equivalent experience
• Experience: 1+ years in an Analytics, Data Quality, or Data Support role
• 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

Benefits

• Excellent health and welfare benefits including comprehensive time off
• Generous retirement savings plans
• Learning and mentorship opportunities
• Access to various staff working groups
• A general admission season pass to Ravinia events

Company Overview