Data Strategist, Windy City Harvest (Chicago, IL)

Requisition Number: 
Windy City Harvest
Job Status: 
Reports to: 
Program Director
Windy City Harvest is the urban agriculture department of the Chicago Botanic Garden, with a 15 year-plus history of serving 200-plus participants annually in multiple programs. Windy City Harvest is part of the Learning and Engagement division. Historically, data for all participants has been collected and analyzed using a series of Excel spreadsheets. In 2019, the Chicago Botanic Garden received a grant to build a data management system. The Garden has contracted with a third party to build this system using Microsoft Dynamics and PowerBI being used as a reporting tool. In year one, the main goal for the system was to 1) organize historical data to prepare for data migration into the system; 2) create a universal application for all program participants; 3) onboard programs into the system, ensuring staff buy-in and appropriate training along the way. Now that year one is complete, the phases of implementation include the Incubator, Veteran Intern, and Youth Farm programs. Year three will include the roadmapping and integration of the rest of the Learning and Engagement Division. Produce a long-term strategy for data analysis and a method for sharing data across multiple departments for fundraising, program management/assessment, and the general public. Data visualization and storytelling with data is key to the success of this role. The data strategist will be a key inter-departmental player. Candidates should have an interest in messy, complex data, data visualization, and helping program staff with analysis.
Duties and Responsibilities: 

In this role you will be responsible for the following:
• Maintain regular familiarity of with Windy City Harvest programs, the Learning and Engagement Division, and the Chicago Botanic Garden as they pertain to data collection and analysis
• Help determine and implement analytics plan for the department
• Provide expertise on database contract and scope of services for data management system
• Work with third-party consultants, the Chicago Botanic Garden–Windy City Harvest staff, donors, and the Learning and Engagement team to ensure smooth integration of data to the platform

• Extract and organize historical data for upload into the new data management systems (from Excel and other platforms to Microsoft Dynamics)
• Support with data input and troubleshooting between frontline staff and database system
• Participate and inform discussions/meetings between third-party team and programs team
• Work with program team to create best practices for feedback loop to build effective database system
• Participate in professional development training offered by consultant and serve as staff liaison for technical/training issues
• Serve as a resource to the Development team in developing dashboards and powerBI visuals to aid in proposals and reporting to existing donors


Key Garden competencies/behaviors desired:

  • Communicates in a manner that gains the trust and support of others at all levels.
  • Works effectively with others despite differences of opinion and style; builds alliances.
  • Has a tolerance for opposing points of view.
  • Strives for collaboration. Works cooperatively, as a positive contributor to the team.
  • Demonstrates a positive attitude and shows kindness in all workplace interactions.
  • Makes decisions appropriate for level of responsibility.
  • Can effectively adapt to change; can shift gears comfortably; is flexible, and embraces change with a “can-do” attitude.
  • Is self-aware; knows personal strengths and weaknesses; seeks feedback and is open to negative feedback as an opportunity for improvement.
  • Is cool under pressure; can be counted on to hold things together during tough times; can handle stress; is not knocked off balance by the unexpected; is a settling influence during a crisis.
  • Recognizes problems, constructively identifies and articulates solutions.
  • Picks up garbage when it is seen regardless of position.
  • Follows safety guidelines to ensure a safe working environment and consistently demonstrates safe work behaviors.
  • Is welcoming of new hires.

Our ideal candidate will have the following:
• Experience working with Microsoft Dynamics, Salesforce, or other CRM platforms
• Familiarity with a data scripting language like R/Python and SQL
• Knowledge of and experience with powerBI, Tableau, or other data visualization tools
• Interest in working with complex historical data stored in various formats
• Ability to collect qualitative data and pull key information for analysis

*The Chicago Botanic Garden requires all existing employees to be fully COVID-19 vaccinated by October 15, 2021; hires after this date must be fully vaccinated upon hire or may request a medical/religious exemption after an offer is extended.*


Complete an application here - Click to Apply

Physical Demands: 
Office setting and remote work. Frequent sitting, standing, walking, bending, listening, speaking, and keyboarding. Use of office equipment including computers, telephones, copiers, scanners, and fax machines. Some requirements for lifting, pushing, or pulling items less than 30 pounds.
Why Apply?: 

Come work in a setting that is like no other as you support our mission: We cultivate the power of plants to sustain and enrich life. Take the first step toward being one of the employees who make the Garden one of the treasures of the Forest Preserves of Cook County. Apply today. Please note that applicants who do not meet the required qualifications will not be considered.

Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities and qualifications required of personnel so classified.

The Chicago Botanic Garden is a M/F, Disabled, and Vet EEO/AA Employer.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

In accordance with Title IX of the Education Amendments Act of 1972, the Chicago Botanic Garden does not discriminate on the basis of sex in its programs or activities, including in employment or admissions. Please call (847) 835-8264 to contact our Title IX coordinator should you have questions or concerns.