Associate Data Analyst
About The Position
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
Requirements
- 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
Responsibilities
- 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
- Other tasks as assigned
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
101-250 employees
