Consultant: Power BI/Business Intelligence Analyst
- Compensation
- Not disclosed
- Location
- United States, Remote, Washington DC
- Work setup
- Remote
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 5+ years
- Category
- Data analytics
- Posted
Skills
Must have
- Bachelor's degree in Business Analytics, Information Systems, Computer Science, Statistics, Finance, Public Health, or a related field.
- Minimum 5 years of experience developing business intelligence solutions and dashboards.
- Advanced proficiency in Microsoft Power BI, including DAX, Power Query, data modeling, and dashboard design.
- Demonstrated experience integrating data from multiple enterprise systems and databases.
- Required experience working with BusinessWorld financial systems and reporting environments.
- Experience working with Salesforce data and reporting structures.
- Experience developing financial forecasting and performance management dashboards.
- Strong analytical, data visualization, and problem-solving skills.
- Excellent communication and stakeholder engagement skills.
Nice to have
- Experience supporting donor-funded projects or large, complex international programs.
- Experience working with monitoring and evaluation data systems.
- Experience in global health, public health, or international development programs.
- Familiarity with milestone-based awards, performance management frameworks, and financial risk monitoring.
Full description
PATH current employees - please log in and apply Here
PATH is a global nonprofit dedicated to achieving health equity. With more than 40 years of experience forging multisector partnerships and with expertise in science, economics, technology, advocacy, and dozens of other specialties, PATH develops and scales up innovative solutions to the world’s most pressing health challenges.
PATH is implementing a large, complex global health project that requires timely monitoring of program performance, financial health, and milestone achievement across multiple countries and workstreams. Data relevant to project management currently resides across several systems, including internal project reporting tools, BusinessWorld, Salesforce, monitoring and evaluation (M&E) systems, and other organizational data sources.
To strengthen data-driven decision-making, PATH seeks a short-term consultant to design and develop a suite of Power BI dashboards and reporting tools that integrate data from multiple systems and provide actionable insights for project teams, financial managers, and executive leadership.
Purpose of the Consultancy
The Power BI / Business Intelligence Analyst will design and develop automated business intelligence solutions that consolidate project performance, operational, and financial data into interactive dashboards and reporting products. The consultant will work closely with project leadership, Finance, the Office of Grants and Contracts (OGC), and the project Monitoring, Evaluation, and Learning (MEL) team to create dashboards that support monitoring, forecasting, and decision-making at multiple organizational levels.
The consultant will help establish a sustainable reporting architecture that enables users to monitor performance against targets, track expenditures against budgets, forecast future spending and performance trends, and identify risks to project delivery and financial health.
Scope of WorkBusiness Requirements and Stakeholder Engagement
- Conduct consultations with project leadership, Finance, and MEL staff to understand reporting requirements, key performance indicators (KPIs), and decision-making needs.
- Review existing reporting systems, data sources, and dashboards.
- Develop data visualization tailored to different stakeholder audiences.
- Recommend dashboard architecture and reporting approaches that support ongoing decision-making and performance management.
Data Integration and Dashboard Development
- Design and develop Power BI dashboards that integrate data from:
- BusinessWorld
- Salesforce
- Internal project reporting systems
- Monitoring and evaluation databases
- Budget and financial management tools