Overview
The International Rescue Committee (IRC) seeks a qualified consultant to design and develop a centralized Power BI dashboard that consolidates and visualizes performance metrics from various digital products under the Ahlan Simsim program.
Tasks Summary
- Develop a consolidated master spreadsheet to collect and organize data from digital products.
- Create structured sheets for each product and data source, accepting manual entry and automated connections.
- Apply validation rules and formulas to ensure data accuracy.
- Prepare documentation describing data sources, entry processes, and refresh frequency.
- Build an interactive Power BI dashboard connected to the backend spreadsheet.
- Develop visual pages summarizing metrics by product and platform.
- Provide filtering options by product, platform, country, gender, age, and date-time period.
- Include visual components such as trend charts, key figures, and product comparisons.
- Ensure the dashboard is intuitive, visually coherent, and accessible to non-technical users.
- Configure secure user access through IRC’s Microsoft accounts.
- Ensure reports can be downloaded by users.
- Integrate the dashboard with IRC’s existing Power BI workspace.
- Provide comprehensive documentation covering data structure, update procedures, and user guidelines.
- Conduct one training session for IRC staff on updating and maintaining the system.
- Deliver an orientation session to regional Ahlan Simsim staff on navigating and using the dashboard.
Experience Requirements
- At least three years of hands-on experience in data visualization and dashboard development for digital products or programs.
- Proven experience designing and delivering dashboards or analytics solutions, ideally in non-profit, humanitarian, or international development contexts.
- Strong proficiency in Power BI, including data modeling, core DAX calculations, and dashboard design.
- Advanced working knowledge of Excel or Google Sheets for structured reporting and data preparation.
- Experience integrating data from multiple sources, including app analytics, messaging platforms, CMS databases, and social media insights, using a mix of manual and automated inputs.
- Working familiarity with data transformation and automation tools such as Power Query, Power Automate, or Python to support efficient reporting workflows.
- Solid understanding of data structures and databases, with the ability to work alongside technical teams managing PostgreSQL or MongoDB environments.
- Ability to design clear, user-friendly dashboards with attention to data quality, consistency, and documentation.
Qualification Requirements