Data Analysis and Visualization Intern

Purpose, Impact & Opportunities:

Many Minnesota food shelves are volunteer run and don't have additional capacity to analyze their food sourcing data. FFEN’s Strategic Food Sourcing (SFS) Report uses data to drive strategic decision making at the food shelf level and effectively promotes more sustainable and stable operations. By evaluating operations through a lens of economics and business practices, it opens the conversation to understand best practices and use of available resources to drive cost effective operations while also respecting and balancing the need for a shopper-centered and community-driven approach.

This position will provide consistent support and leadership to the creation of Strategic Food Sourcing Reports (Tableau) and Consultation materials (Google Slides/Sheets), development and quality assurance for statewide benchmarking, and ongoing management of data for accuracy and data integrity. This position will work closely with pro-bono Data Analysis volunteers and FFEN staff.

Role Responsibilities:

Data accuracy, storage and tracking:

• Collect and collate data for internal and external reports.
• Review raw data, input files, and database exports for accuracy.
• Format raw data to import into Amazon Web Services database.
• Utilize saved SQL queries to query data from Amazon Web Services database.
• Document ongoing processes around internal data storage.

Strategic Food Sourcing (SFS) Report and Consultation Materials Creation:

• Utilize Tableau to create site specific dashboards and statewide visualizations.
• Quality check SFS data and Tableau dashboards for accuracy.
• Join consultations with food shelf leaders to support dissemination of data and insights, discussion on next steps and recommendations, and support further FFEN engagement after each session.

Tableau Stewardship:

• Use Tableau to create relevant data visualizations.
• Update Tableau dashboards as needed, including managing data flows from AWS to Tableau.
• Develop and maintain documentation for FFEN’s Tableau processes and usage.

Strategic Food Sourcing Service - Process Improvement:

• Work with FFEN staff, consultants, Database Volunteers, and Data Analysis Volunteers to improve processes around quality checks and data integrity.
• Document processes for ensuring data accuracy.
• Document processes and best practices for running Tableau dashboards.
• Document processes for creating and updating consultation materials.

Time Commitment & Schedule

• Total time requirement:
  • 5 - 7 hours per week
  • During business hours (8am - 4pm CST) primarily
    • Some evenings required (2 - 3 a month)
• Project dates: January 8th 2025 - May 31st 2025 (opportunity to extend)
• Work site: Remote or FFEN office in Minneapolis

Support & Resources

• Step-by-step written guides and video tutorials
• Monthly database meeting and training sessions
• Weekly check in with supervisor
• FFEN staff available to answer any questions you may have
• $16.00 hourly pay
• If residing in Minnesota, an estimated 3.5 - 7 hours of Earned Sick and Safe Time

Skills & Requirements

• Wi-Fi–enabled laptop with Excel (2019 or newer), Google Drive, and Zoom access
• Strong attention to detail and ability to work independently
• Proficiency in Excel and at least two of: AWS, SQL, or Tableau
• Experience with Tableau Online, AWS databases, and SQL querying
• Familiarity with database operations (tables, views, queries)
• Initiative, flexibility, and willingness to troubleshoot and share improvements
• Upper-level undergraduate or graduate student with prior data analysis experience
• Experience with food shelves or food banks a plus
• Comfort with Google Workspace and general Windows technology
• Able to adapt and take initiative in a fast-paced environment

To Apply:

Send your resume to: volunteer@ffen.org