<p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Background:</b></span></p><p style="text-align: justify;"><span style="font-family: helvetica;font-size: 12.0pt;"><span style="color: black;">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.</span><span style="color: rgb(192,0,0);"> </span></span></p><p style="text-align: justify;"><span style="font-size: 12.0pt;font-family: helvetica;">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. </span></p><p><span style="font-size: 12.0pt;font-family: helvetica;"> </span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Purpose / Project Description:</b></span></p><p style="text-align: justify;"><span style="font-size: 12.0pt;font-family: helvetica;">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.</span></p><p><span style="font-size: 12.0pt;font-family: helvetica;"> </span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Consultant Activities:</b></span></p><p><span style="font-size: 12.0pt;font-family: helvetica;">The Consultant will:</span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Develop and build a Power BI Dashboard:</b></span></p><ul style="margin-top: 0.0px;"><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Build a custom interactive Power BI dashboard for our Carbon accounting/reporting (e.g., Scope 1, 2, 3 emissions) and data validation. </span></span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Integrate data from multiple sources (including Enterprise Fabric Lakehouse) into Power BI for comprehensive reporting.</span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Identify opportunities to improve dashboard functionality.</span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Ensure the dashboard is user-friendly, visually compelling, and aligned with the organization’s needs.</span></span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Work closely with our Data Services Team to automate data refresh processes and maintain data integrity</span></span></p></li></ul><p><span style="font-size: 12.0pt;font-family: helvetica;"> </span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Consultant Deliverables:</b></span></p><p style="text-align: justify;"><span style="font-size: 12.0pt;font-family: helvetica;">The Consultant will deliver:</span></p><ul style="margin-top: 0.0px;"><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Fully functional <strong>Power BI dashboard</strong> for carbon emissions reporting (Scope 1, 2, and 3) with integrated data sources and automated data refresh and error-checking processes.</span></p></li></ul><p><span style="font-size: 12.0pt;font-family: helvetica;"> </span></p><p style="text-align: justify;line-height: 107.0%;"><span style="font-family: helvetica;font-size: 12.0pt;"><b><span style="line-height: 107.0%;">Timeframe / Schedule: </span></b></span></p><p style="text-align: justify;line-height: 107.0%;"><span style="font-size: 12.0pt;line-height: 107.0%;font-family: helvetica;color: black;">Precise timelines to be agreed with candidate. Approximately 10 -15 days’ work. Project to be completed by end of July 2026. </span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>The Consultant will report to: </b></span></p><p style="text-align: justify;"><span style="font-size: 12.0pt;font-family: helvetica;">Environmental Sustainability Manager </span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>The Consultant will work closely with:</b></span></p><ul style="margin-top: 0.0px;"><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 107.0%;">Global Data Services Team</span></span></p></li></ul><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Required Experience & Skills:</b></span></p><ul style="margin-top: 0.0px;"><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>5-10 years of experience in relevant technical field.</span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Industry relevant knowledge and expertise.<span style="color: black;"> </span></span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Track record of supporting mission-driven organizations. </span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Degree in Environmental Science, Sustainability, Data Analytics, or related fields.</span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span>Experience with carbon accounting and emissions reporting.</span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Proven experience in Power BI development (e.g., data modeling, DAX, data visualization best practices).</span></span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Strong proficiency in Excel and familiarity with data transformation tools (e.g., Power Query Editor).</span></span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Understanding relational databases and data integration.</span></span></p></li><li style="font-family: helvetica;font-size: 12.0pt;"><p><span style="font-family: helvetica;font-size: 12.0pt;"><span> </span><span style="line-height: 125.0%;">Familiarity with sustainability frameworks and standards (e.g., GHG Protocol).</span></span></p></li></ul><p><span style="font-family: helvetica;font-size: 12.0pt;"><i> </i></span></p><p><span style="font-size: 12.0pt;font-family: helvetica;color: red;">            <u></u></span></p><p style="margin-bottom: 2.0pt;"><span style="font-family: helvetica;font-size: 12.0pt;"><b><span lang="EN" style="color: rgb(192,0,0);">Team Engagement and Effectiveness </span></b></span></p><p><span lang="EN" style="font-size: 12.0pt;font-family: helvetica;color: rgb(67,67,67);">Achieving our mission starts with how we build our team and collaborate. By bringing together individuals with a variety of experiences, backgrounds, and perspectives, we strengthen our ability to solve complex challenges and drive innovation. We foster a culture of trust and respect, where every team member is valued for their contributions, empowered to reach their full potential, and motivated to do their best work.</span></p><p><span lang="EN" style="font-size: 12.0pt;font-family: helvetica;color: rgb(67,67,67);">We recognize that building a strong and effective team is an ongoing process, and we remain committed to learning, improving, and growing together.</span></p><p><span style="font-size: 12.0pt;font-family: helvetica;color: rgb(67,67,67);"> </span></p><p style="margin-bottom: 2.0pt;"><span style="font-family: helvetica;font-size: 12.0pt;"><b><span lang="EN" style="color: rgb(192,0,0);">Equal Employment Opportunity</span></b></span></p><p style="margin: 0.0in;background: white;"><span style="font-size: 12.0pt;font-family: helvetica;color: rgb(67,67,67);">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.</span></p><p style="margin: 0.0in;background: white;"><span style="font-family: helvetica;font-size: 12.0pt;">  </span></p><p><span style="font-family: helvetica;font-size: 12.0pt;"><b>Safeguarding & Ethics<br></b>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 <a href="https://www.mercycorps.org/who-we-are/ethics-policies" target="_blank" title="https://www.mercycorps.org/who-we-are/ethics-policies">Mercy Corps Code of Conduct Policies</a> and values at all times. Team members are required to complete mandatory Code of Conduct elearning courses upon hire and on an annual basis.</span></p>