Data Analytics, ERP Consultant

This is a fully remote position, open to applicants in United States.

📋 Description

• Examine current country-office award matrices to pinpoint inconsistencies, duplications, and gaps.

• Create and sustain a unified master dataset that includes awards, sub-awards, and partners, incorporating data version control.

• Develop a standardized data submission template along with a validation and quality assurance process for country offices.

• Design a database intended for the collection of country-office KPIs, as well as for managing and visualizing the data.

• Construct and oversee a live Power BI dashboard linked to the consolidated dataset and subsequently to NetSuite.

• Update the dashboard on a predetermined schedule.

• Organize the dashboard to ensure role-based access for the Awards Management Unit, Country Directors, and senior management.

• Offer a temporary data and reporting mechanism while NetSuite is not fully operational.

• Align dashboard fields and logic with the fields, requirements, and workflows of the NetSuite Award and Partnerships Module.

• Provide guidance on configuring NetSuite Analytics Connect/API connectivity, allowing Power BI to retrieve live data from NetSuite.

• Record reporting logic for both the Awards Management Unit and the development team.

• Assist in award and partnership management reporting throughout the grant lifecycle, covering aspects like award/sub-award volumes, ICR, partner status, due diligence compliance, and cost-contribution tracking.

• Report to the Global Awards Director, with collaborative technical oversight from the Global Awards and Donor-Compliance Coordinator and Global Partnerships Advisor.

⛳️ Requirements

• Demonstrated experience in data management within the humanitarian or development sector; NGO experience is highly preferred.

• Proficient in advanced Power BI functionalities.

• Familiarity with ERP or grants management systems.

• Knowledge of sub-award and grants management concepts, including ICR/NICRA, cost share/match, FFATA, due diligence, and risk assessment.

• Proven capability to design adaptable and sustainable interim data solutions during system transitions.

• Background in product management or business analysis is desirable.

• Ability to convert functional requirements into technical specifications for a development team is preferred.

• Previous experience with multi-country data collection from field or country offices, particularly in scenarios with varying data quality and connectivity, is advantageous.

• Experience in data governance and quality frameworks, including validation rules, audit trails, and version control, is preferred.

• Familiarity with reporting requirements from UN and other major institutional donors is advantageous.

• Proven capacity to deliver reporting solutions amidst evolving data and prioritize actionable outputs.

• Exceptional skills in stakeholder engagement, including experience training or supporting non-technical, multi-country field staff to ensure timely data submissions.

• Previous involvement in supporting data or systems migration from legacy platforms to new systems.

• Flexibility to synchronize delivery schedules with ERP development timelines and go-live milestones.

• Strong documentation abilities, including the creation of data dictionaries and technical handover materials for diverse audiences.

• Ideally able to work during business hours in EST, EEST, and/or AST time zones.

• Submission of a CV and a one-page cover letter or proposal is required.

• Completion of standard pre-contracting checks is mandatory.

🏝️ Benefits

• 3-month independent consultant contract.

• Remote work arrangement available.

• Opportunity to collaborate with an international non-profit organization.

• Commitment to an inclusive and representative workplace.

• Standard pre-contracting checks applicable.

• Self-declaration of criminal records, along with references and other pre-employment checks, which may include police and qualifications verification.