Senior Business Intelligence Developer – US or UK
Employment Senior Business Intelligence Developer – US or UK Organization: Mercy Corps Type: Full-Time Salary: $90,000 to $110,000 / Yearly Four-day Week: No 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 27th
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 anoma
Apply tot his job Apply To this Job