Data Insights Specialist

About the role

The Data Insights Specialist supports the Nutrition Department by ensuring department data is accurate, organized, accessible, and useful for program management, reporting, forecasting, and decision-making. This position is responsible for data entry and maintenance, data cleaning and reconciliation, dashboard and report development, forecasting, and the design and improvement of department data systems and workflows. The Specialist also supports staff in developing consistent data practices, documenting processes, and using data and technology platforms effectively. The Data Insights Specialist works under the direction of the Director of Nutrition Programs, with guidance from the Vice President of Nutrition & Food Service. The position has latitude to design and build data tools, dashboards, workflows, and system solutions within established department priorities, with final approval as appropriate. The ideal candidate is highly organized, detail-oriented, persistent, and comfortable working with incomplete or inconsistent data across multiple systems. They enjoy solving problems and can move easily between technical work, routine data maintenance, and supporting colleagues with different levels of technical experience. They work independently within established direction, use sound judgment, adapt to changing priorities, and know when an issue requires leadership input.

Responsibilities

• Enter, maintain, clean, reconcile, and validate program, participant, grant, operational, and reporting data across department systems.
• Review data for accuracy, completeness, consistency, and duplication and resolve discrepancies when possible.
• Combine data from multiple sources and maintain master datasets, trackers, reporting files, and other department data resources.
• Import and export data between platforms and prepare data for internal, grant, and external reporting requirements.
• Identify gaps or inconsistencies in data collection and work with staff to improve data quality and documentation.
• Build and maintain dashboards, reports, and visualizations that allow department leadership to monitor program activity, outcomes, reach, and key measures.
• Develop reports using tools such as Excel, Power Query, Power BI, Tableau, and other department platforms.
• Translate data from multiple programs and systems into clear, usable information, trends, and forecasts for department leadership.
• Develop and maintain forecasting models using historical and current program, referral, production, distribution, and other relevant data.
• Support program planning, resource allocation, production needs, and