Sustainability Analyst – Carbon Reporting & Power BI Dashboard Development Consultancy

Mercy Corps Europe; United States; Remote; USD 148,000 - 221,000; Full time

Job summary

Mercy Corps Europe is seeking a Sustainability Analyst to lead carbon reporting and Power BI dashboard development as part of a consultancy engagement. The role focuses on building an interactive dashboard for Scope 1-3 emissions, integrating data from multiple sources, and automating refresh processes to ensure data integrity.

You will collaborate with the Global Data Services Team and the Environmental Sustainability Manager to deliver a fully functional solution within 10–15 days, with

Qualifications

• Degree in Environmental Science, Sustainability, Data Analytics, or related field.
• Experience with carbon accounting and emissions reporting.
• Proven Power BI development experience including data modeling and visualization best practices.

Responsibilities

• Develop and build a Power BI dashboard for carbon accounting (Scope 1–3) with integrated data sources.
• Integrate data from multiple sources (including Lakehouse) into Power BI for reporting.
• Identify opportunities to improve dashboard functionality and usability.
• Automate data refresh processes and maintain data integrity in collaboration with the Data Services Team.
• Deliver a fully functional dashboard with automated checks and ongoing support.

Skills

Power BI development

Power Query Editor

Excel

Data modeling

DAX

Relational databases

Data integration

Carbon accounting

Emissions reporting

Sustainability frameworks

GHG Protocol

Education

Bachelor's degree in Environmental Science/Sustainability/Data Analytics

Tools

Power BI

Excel

Power Query Editor

Relational databases

Job description

Sustainability Analyst – Carbon Reporting & Power Bi Dashboard Development Consultancy

Description

Background:

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.

Purpose / Project Description:

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.

Consultant Activities:

The Consultant will:

Develop and build a Power BI Dashboard:

• Build a custom interactive Power BI dashboard for our 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 our Data Services Team to automate data refresh processes and maintain data integrity

Consultant Deliverables:

The Consultant will deliver:

• Fully functional Power BI dashboardfor carbon emissions reporting (Scope 1, 2, and 3) with integrated data sources and automated data refresh and error-checking processes.

Timeframe / Schedule:

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

The Consultant will report to:

Environmental Sustainability Manager

The Consultant will work closely with:

• Global Data Services Team

Required Experience & Skills:

• 5-10 years of experience in relevant technical field.
• Industry relevant knowledge and expertise.
• Track record of supporting mission-driven organizations.
• Degree in Environmental Science, Sustainability, Data Analytics, or related fields.
• Experience with carbon accounting and emissions reporting.
• 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).

Safeguarding & Ethics

Mercy Corps is committed to ensuring that all individuals we come into contact with through our work, whether team members, community members, program participants or others, are treated with respect and dignity. We are committed to the core principles regarding prevention of sexual exploitation and abuse laid out by the UN Secretary General and IASC. We will not tolerate child abuse, sexual exploitation, abuse, or harassment by or of our team members. As part of our commitment to a safe and inclusive work environment, team members are expected to conduct themselves in a professional manner, respect local laws and customs, and to adhere to