• Independently complete analysis, development and enhancement of analytical and operational BI solutions to fulfill business needs • Independently work closely with end users to understand and translate business needs to create well-designed and validated BI solutions using business intelligence tools • Maintain technical currency and certifications in areas of responsibility and communicates effectively with team members and associates at all levels • Provides complete and accurate documentation for work based on current documentation standards • Provides production support for business intelligence solutions • Activities include problem analysis, break/fix, design/modeling, implementation/coding, and testing • Provides technical leadership to team members and leads medium size projects through all phases of system development including: planning, development, implementation and operation

Location: US or UK - flexible home base Position Status: Regular, Full Time, Exempt Salary: US: starting salary for this role will be from $90,000 USD to $110,000 USD annually- commensurate with experience. UK: starting salary will be from £63,840 - commensurate with experience Applications closing date: Please submit application including CV and cover letter by April 8th Risk Level: ☐ Level 3 ☐Level 2 x Level 1 Level 1: Likely to have no contact with participants or sensitive data) About Mercy Corps 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. Now, and for the future. The Department: Private Giving & Engagement (PG&E) The Private Giving & Engagement (PG&E) department advances Mercy Corps’ strategic priorities by raising private funds, building meaningful relationships with supporters, and strengthening the organization’s global profile and influence. PG&E partners closely with teams across Mercy Corps to deliver innovative, ethical, and effective fundraising and engagement strategies. Within PG&E, Development Operations plays a critical role in enabling fundraising success by ensuring strong systems, sound governance, and effective operational support. The team brings together expertise in fundraising operations, compliance, analytics, systems, and project management to support high-performing fundraising teams across regions and channels. The Position The Senior Business Intelligence Developer supports and expands PG&E’s business intelligence solution(s), which includes a custom SQL Server-based data warehouse (on-premises) and a suite of reports in SQL Server Reporting Services (SSRS) and Microsoft Power BI. They play a critical role in all phases of the solution’s lifecycle, including requirements gathering, data analysis and modeling, data warehouse development, ETL design and maintenance, integrating data from disparate data sources, developing and deploying reports and dashboards. As our analytics’ needs evolve, we anticipate opportunities to streamline and modernize our environment. The Senior BI Developer will help assess improvement areas within our current architecture, optimize performance, and strengthen documentation to support future scalability and long-term data strategy. The role focuses on developing the insights, reports, and semantic models that enable analysis of fundraising performance, constituent behavior, and gift trends, with occasional use of exploratory and predictive techniques. This position engages regularly with stakeholders to understand reporting needs and validate results. Ultimately, the Senior BI Developer helps ensure the reporting and analysis needed to guide and support PG&E’s fundraising strategy and decision-making. The ideal candidate thrives in a collaborative, relationship-driven environment and brings structure, clarity, and best practices while remaining flexible and responsive to evolving business needs. Essential Responsibilities SQL development in a production environment ● Develop, test and document stored procedures, views, tables, indexes, constraints, functions and T-SQL scripts. ● Prepare clear and comprehensive technical documentation Interview stakeholders about reporting needs ● Work regularly with the Director of Fundraising Data & Analytics and team members to identify new reports and updates, to existing ones, clearly communicate requirements and changes, and design, test, and validate report outputs. Develop and maintain standardized reports using Microsoft’s SQL Server Reporting Services and Microsoft Power BI ● Create scheduled and on-demand reports for a self-service environment, support legacy MDX while focusing new development on Power BI tabular models and DAX. ● Expand, assess, and maintain the SQL Server data warehouse and SSIS-based ETL processes, including improving performance, streamlining legacy workflows, and strengthening documentation Data quality and integrity ● Work closely with the Donor Database Manager, Online Database Developer and Manager, and Development Operations Manager to identify data anomalies and broken business rules and support data integrity and cleanup processes. Ensure that personally identifiable data and data analytics practices are aligned with Mercy Corp’s Responsible Data Policy. Cross-train in essential functions to ensure business continuity. Collaborate with the IT Department to ensure that marketing technical strategy aligns with the broader enterprise roadmap. Development and maintain OLAP cubes as needed. Other duties as requested or required. Supervisory Responsibility None. Accountability Reports Directly To: Director of Fundraising Data & Analytics Works Directly With: PG&E Team, Online Database Developer and Manager, IT Team, Database Manager, Development Operations Manager. Accountability to Participants and Stakeholders Mercy Corps team members are expected to support all efforts toward accountability, specifically to our program participants, community partners, other stakeholders, and to international standards guiding international relief and development work. We are committed to actively engaging communities as equal partners in the design, monitoring and evaluation of our field projects. Minimum Qualification & Transferable Skills ● Bachelor degree or equivalent professional experience. ● Demonstrated knowledge of data warehousing, database management, reporting development, data cleansing, ETL and data analysis, preferably in a non-profit fundraising environment. ● Demonstrated success using T-SQL or MySQL to support data warehousing and reporting ● Projects, (ideally 5+ years). ● Demonstrated technical competency (ideally 3+ years) with Microsoft SQL Server - 2016, including Analysis Services, Integration Services, and Reporting Services (SSAS, SSIS, SSRS) and Power BI. ● Demonstrated success (ideally 2+ years) developing customized reports in Microsoft SQL Server - Reporting Services and Microsoft Power BI, including multi-dimensional reports with drill-down capability. ● Knowledge of The Raiser’s Edge ideal; non-profit experience preferred. ● 3+ years of experience with fundraising data or other comparably complex data. ● Strong written and verbal communication skills; including the ability to communicate effectively with team members of varied work styles. ● Proven ability to handle confidential materials and sensitive information. ● Python experience is a plus. Success Factors The successful candidate will be a highly motivated self-starter who is deeply curious about fundraising and the questions fundraisers ask. They bring an investigative and analytical approach to data and fundraising strategy and are comfortable engaging with colleagues to explore bigger questions and translate business needs into technical solutions. They can translate technical concepts into clear, accessible insights for fundraisers and non-technical colleagues, ensuring that data is understandable and actionable. The ideal candidate thrives in a collaborative, relationship-driven environment and communicates effectively with team members across varied work styles. They bring structure, clarity, and best practices to their work while remaining adaptable in a setting where needs and priorities evolve. An even temperament, a proactive and solutions-oriented approach to problem-solving, and a collaborative mindset are appreciated. Awareness of and sensitivity to multicultural and international development contexts are valued. Living Conditions / Environmental Conditions The position is remote. Ongoing Learning In support of our belief that learning organizations are more effective, efficient and relevant to the communities we serve, we empower all team members to dedicate 5% of their time to learning activities that further their personal and/or professional growth and development Team Engagement and Effectiveness 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. We recognize that building a strong and effective team is an ongoing process, and we remain committed to learning, improving, and growing together. 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 and have signed on to the Interagency Misconduct Disclosure Scheme. 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. Team members are required to complete mandatory Code of Conduct elearning courses upon hire and on an annual basis. As an applicant, if you witness or experience any form of sexual misconduct during the recruitment process, please report this to Mercy Corps Integrity Hotline (integrityhotline@mercycorps.org). As a safeguarding measure, Mercy Corps screens all potential US-Based employees. This is done following the conclusion of recruitment and prior to assuming full employment. Our screening process is designed to be transparent and completed in partnership with new Team Members. You will have the opportunity to disclose any prior convictions at the conclusion of the recruitment process before the check is initiated. We ask that you do not disclose any prior convictions in your application materials or during the recruitment process.

• Serve as the key data partner for our business teams and senior leadership, providing insights that drive strategic decision-making and enable proactive performance management. • Develop a suite of Tableau dashboards and toolkits that align business teams around a standard success management strategy, including the creation of shared KPIs and enablement plan for how/when dashboards and data will be used by the business. • Derive data requirements from business leadership and translate to technical requirements for our Analytics Engineering team to support the development of our Enterprise Data Warehouse. • Curate business analytics content within Tableau and re-design the overall user experience with Tableau: overhaul site structure/navigation, publish documentation and training content for creators and viewers, and leverage/manage usage of newly available Tableau AI tools. • Partner with Analytics Engineering to manage inbound data ingestion to Tableau, including data sources, schedules, monitoring/alerting, and Tableau Bridge configuration. • Stay current with industry trends, best practices, and emerging technologies in analytics, and contribute to a culture of continuous learning, growth, and innovation. • Serve as the primary Subject Matter Expert on all things Tableau & Business Intelligence. Providing technical support to other analysts, content creators, and end users will be critical to this role’s success. • Lead by example in terms of stakeholder communication, project management, and solution design/development.

• Design, build, and maintain Power BI dashboards and reports for both operational and executive stakeholders. • Translate complex business needs into clear, actionable reporting and data visualizations. • Lead data validation efforts to ensure consistency, accuracy, and trust in reporting outputs. • Collaborate cross-functionally with Finance, Operations, and Senior Leadership Team to deliver performance metrics that inform strategic decisions. • Manage recurring performance reporting cycles and respond to ad-hoc data requests. • Maintain and enhance self-service reporting tools to support scalable, data-informed decision-making. • Act as a liaison between technical teams and business users to align reporting with practical use cases and priorities.