Overview
Support the design and development of a simple KPIs tracking system and dashboard to monitor grant status, combining financial, programmatic, and compliance elements.
Key Responsibilities
- Review and organize existing data and tools.
- Support organizing and simplifying information.
- Identify overlaps, gaps, and opportunities for improvement.
- Help structure a small set of core KPIs.
- Support defining how to track process stages and bottlenecks.
- Create a user-friendly Excel file including a grant-level overview, KPI tracking sheets, and a simple action tracker.
- Integrate basic logic into the Excel file.
- Design a simple and clear dashboard to visualize key KPIs, highlight delays and risks, and support internal discussions and decision-making.
- Suggest ways to make the tool easy to use and maintain, clear and visually intuitive.
- Bring new ideas and creative approaches to improve the overall design and usefulness of the system.
Required Experience
- Experience in data organization, dashboards, or analysis
- Strong skills in Excel
- Ability to simplify and structure information
- Interest in practical problem-solving and process improvement
- Creativity and willingness to propose new ideas
