Description

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 ([email protected]).