Senior Business Intelligence Developer - US or UK

Location: US or UK - flexible home basePosition Status: Regular, Full Time, ExemptSalary: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 experienceApplications closing date: Please submit application including CV and cover letter by April 8thRisk Level: ☐ Level 3 ☐Level 2 x Level 1Level 1: Likely to have no contact with participants or sensitive data)ABOUT MERCY CORPSMercy 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 solutionsinto 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 POSITIONThe 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 RESPONSIBILITIESSQL 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 documentationInterview 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 Servicesand 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 documentationDATA 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 RESPONSIBILITYNone.ACCOUNTABILITYReports Directly To: Director of Fundraising Data & AnalyticsWorks Directly With: PG&E Team,Online Database Developer and Manager, IT Team, Database Manager, Development Operations Manager.ACCOUNTABILITY TO PARTICIPANTS AND STAKEHOLDERSMercy 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 FACTORSThe 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 CONDITIONSThe position is remote.ONGOING LEARNINGIn 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 developmentTEAM ENGAGEMENT AND EFFECTIVENESSAchieving 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 OPPORTUNITYMercy 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 & ETHICSMercy 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]).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.HOW TO APPLYlearn more about this role and join us by applying here: Mercy Corps Careers - Senior Business Intelligence Developer - US or UK