Note: The job is a remote job and is open to candidates in USA. Relief International is an international nonprofit organization providing humanitarian and resilience-building programs in communities affected by conflict, climate change, and disaster. The Data Analytics & ERP Consultant will strengthen awards-management data and reporting by consolidating country-office data, developing a live Power BI dashboard, and supporting the transition to the NetSuite Partnerships Module.
Responsibilities
- Review existing country-office award matrices and identify inconsistencies, duplication, and gaps against AMU's reporting needs
- Lead the design and maintain a consolidated master dataset (awards, sub-awards, partners) with a clear data version control
- Establish a standard data submission template and validation/QA process for country offices
- Lead the design database for AMU to launch, collect COs KPIs and how to manage and visualize these data
- Build and maintain a live Power BI dashboard connected to the consolidated dataset (and later to NetSuite), refreshed on an agreed cadence
- Ensure the dashboard is structured for role-based access (AMU, Country Directors, senior management)
- Interim/bridge solution: provide a temporary data and reporting mechanism that covers AMU's needs while NetSuite is not yet fully live
- NetSuite alignment: map dashboard fields and logic to the Award and partnerships Module's fields, current requirements, and workflows so reporting migrates cleanly once NetSuite goes live
- Post-transition continuity: advise on and help configure NetSuite. Analytics Connect / API connectivity so Power BI can pull live from NetSuite, and document the reporting logic for AMU and the dev team
Skills
- * Proven experience in humanitarian/development sector data management (NGO experience strongly preferred)
- * Advanced Power BI skills
- * Working knowledge ERP/grants-management systems
- * Understanding of sub-award/grants-management concepts: ICR/NICRA, cost share/match, FFATA, due diligence and risk assessment, OCA
- * Demonstrated ability to design bridge/interim data solutions during system transitions, adaptable and sustainable
- * Proven ability to deliver reporting solutions with evolving data, prioritizing usable outputs
- * Excellent stakeholder engagement skills, with experience training or supporting non-technical, multi-country field staff to ensure timely data submission
- * Prior experience supporting a data or systems migration from a legacy platform to a new system
- * Flexibility to align delivery schedule with the ERP system development timeline and go-live milestones
- * Strong documentation skills, including data dictionaries and technical handover materials for both non-technical and technical audiences
- * Product management or business-analyst background, able to translate functional requirements into technical specs for a dev team (relevant given the ongoing NetSuite transition)
- * Prior experience with multi-country data collection from field/country offices with variable data quality and connectivity
- * Data governance / data quality framework experience (validation rules, audit trails, version control)
- * Familiarity with UN and other major institutional donor reporting requirements
Benefits
- 3-month remote independent consultant contract
- Remote work arrangement
Company Overview