Sustainability Analyst – Carbon Reporting & Power Bi Dashboard Development Consultancy

Description

Background: Mercy Corps is a leading global organization committed to reducing its carbon footprint by 50% by 2030. As signatories to the Climate Charter and the NGO Climate Compact 2.0, Mercy Corps is dedicated to advancing the global agenda to combat climate change and support those most affected.

Purpose / Project Description

Mercy Corps is upgrading its sustainability tracking and reporting system to enhance accuracy and automation. Specifically, the organization is seeking an experienced sustainability analyst/reporting consultant to develop and build a Power BI dashboard for carbon emissions reporting (Scope 1, 2, and 3).

Consultant Activities

• Develop and build a Power BI Dashboard
• Build a custom interactive Power BI dashboard for carbon accounting/reporting
• 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

Consultant Deliverables

• Fully functional Power BI dashboard for carbon emissions reporting (Scope 1, 2, and 3)
• Integrated data sources and automated data refresh and error-checking processes

Timeframe / Schedule

Approximately 10 - 15 days' work. Project to be completed by end of July 2026.

The Consultant Will Report To

The Consultant will report to the 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)

Equal Employment Opportunity

Mercy Corps is an equal opportunity employer committed to providing equal employment opportunities to all employees and qualified applicants for employment without regard to race, color, sex, sexual orientation, religion or belief, national origin, age, disability, marital status, veteran status, or any other characteristics protected under applicable law.

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 Mercy Corps Code of Conduct Policies and values at all times.