Sustainability Analyst – Carbon Reporting & Power Bi Dashboard Development Consultancy

About the role

Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, in hardship, in more than 40 countries around the world, we partner to put bold solutions into action — helping people triumph over adversity and build stronger communities from within. Mercy Corps is committed to reducing our global carbon footprint by 50% reduction by FY2030 as part of our environmental sustainability goals. As signatories to the Climate Charter and the NGO Climate Compact 2.0 under Inter Action, we are committed to advancing the global agenda to drastically reduce greenhouse gas emissions and alleviating the effects of climate change on people with the least power and fewest resources. After five years of tracking and reporting our sustainability data, we are upgrading our tracking and reporting system to increase accuracy and automation. Mercy Corps is looking for an experienced sustainability analyst/reporting consultant to work alongside our sustainability team and execute the Power BI visualization elements of this rebuild. The Consultant will report to the Environmental Sustainability Manager and will work closely with the Global Data Services Team.

Responsibilities

• Develop and build a custom interactive Power BI dashboard for Carbon accounting/reporting (e.g., Scope 1, 2, 3 emissions) and data validation.
• Integrate data from multiple sources (including Enterprise Fabric Lakehouse) into Power BI for comprehensive reporting.
• Identify opportunities to improve dashboard functionality.
• Ensure the dashboard is user-friendly, visually compelling, and aligned with the organization’s needs.
• Work closely with the Data Services Team to automate data refresh processes and maintain data integrity.

Requirements

5-10 years of experience in relevant technical field. Industry relevant knowledge and expertise. Track record of supporting mission-driven organizations.

Qualifications

Degree in Environmental Science, Sustainability, Data Analytics, or related fields. Experience with carbon accounting and emissions reporting.

Skills

Proven experience in Power BI development (e.g., data modeling, DAX, data visualization best practices). Strong proficiency in Excel and familiarity with data transformation tools (e.g., Power Query Editor). Understanding relational databases and data integration. Familiarity with sustainability frameworks and standards (e.g., GHG Protocol).

Schedule

Precise timelines to be agreed with candidate. Approximately 10‑15 days’ work. Project to be completed by end of July 2026.