Sustainability Analyst/Reporting Consultant

Job Posting Organization:
Mercy Corps is a leading global organization founded on the belief that a better world is possible. Established to address the challenges faced by communities in disaster and hardship, Mercy Corps operates in over 40 countries worldwide. The organization is dedicated to implementing bold solutions that empower individuals to overcome adversity and build resilient communities. As part of its commitment to environmental sustainability, Mercy Corps aims to reduce its global carbon footprint by 50% by FY203

• The organization is also a signatory to the Climate Charter and the NGO Climate Compact 2.0 under InterAction, demonstrating its commitment to advancing the global agenda for reducing greenhouse gas emissions and addressing climate change impacts on vulnerable populations.

Job Overview:
The Sustainability Analyst/Reporting Consultant will play a crucial role in upgrading Mercy Corps' sustainability data tracking and reporting system. This position involves working closely with the sustainability team to enhance the accuracy and automation of data reporting. The consultant will be responsible for developing a custom interactive Power BI dashboard that will facilitate carbon accounting and reporting, specifically focusing on Scope 1, 2, and 3 emissions. The consultant will integrate data from various sources, including the Enterprise Fabric Lakehouse, to ensure comprehensive reporting. The goal is to create a user-friendly and visually compelling dashboard that meets the organization's needs while identifying opportunities for improved functionality. The consultant will also collaborate with the Data Services Team to automate data refresh processes and maintain data integrity, ensuring that the dashboard remains effective and reliable.

Duties and Responsibilities:
The primary duties and responsibilities of the Sustainability Analyst/Reporting Consultant include:

• Developing and building a custom interactive Power BI dashboard for carbon emissions reporting, including Scope 1, 2, and 3 emissions.
• Integrating data from multiple sources into Power BI for comprehensive reporting.
• Identifying opportunities to enhance dashboard functionality and user experience.
• Ensuring the dashboard is visually compelling and aligned with organizational needs.
• Collaborating with the Data Services Team to automate data refresh processes and maintain data integrity.
• Delivering a fully functional Power BI dashboard with integrated data sources and automated error-checking processes.
• Reporting to the Environmental Sustainability Manager and working closely with the Global Data Services Team.

Required Qualifications:
The required qualifications for this position include:

• 5-10 years of experience in a relevant technical field, demonstrating industry knowledge and expertise.
• A proven track record of supporting mission-driven organizations.
• A degree in Environmental Science, Sustainability, Data Analytics, or related fields.
• Experience with carbon accounting and emissions reporting.
• Proven experience in Power BI development, including data modeling, DAX, and data visualization best practices.
• Strong proficiency in Excel and familiarity with data transformation tools such as Power Query Editor.
• Understanding of relational databases and data integration.
• Familiarity with sustainability frameworks and standards, such as the GHG Protocol.

Educational Background:
Candidates should possess a degree in Environmental Science, Sustainability, Data Analytics, or a related field. This educational background is essential for understanding the complexities of sustainability data and the technical skills required for effective reporting and analysis.

Experience:
The position requires 5-10 years of relevant experience in a technical field. Candidates should have a strong background in sustainability, data analytics, and carbon accounting, with a proven ability to support mission-driven organizations. Experience in developing Power BI dashboards and working with data integration is crucial for success in this role.

Languages:
While the job description does not specify mandatory languages, proficiency in English is likely essential given the organization's global operations. Additional language skills may be beneficial but are not explicitly required.

Additional Notes:
The consultant role is expected to involve approximately 10-15 days of work, with precise timelines to be agreed upon with the selected candidate. The project is anticipated to be completed by the end of July 202

• This position is likely to be a contract role, and the consultant will work closely with the Environmental Sustainability Manager and the Global Data Services Team. Mercy Corps is committed to providing equal employment opportunities and fostering a safe and inclusive work environment.