Senior Business Intelligence Developer - US or UK

<div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Location:</b> US or UK - flexible home base</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Position Status:</b> Regular, Full Time, Exempt </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b><span lang="EN">Salary: </span></b></span></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b><span lang="EN">US:</span></b><span lang="EN"> Starting salary for this role will be from $90,000 USD to $110,000 USD annually- commensurate with experience.</span></span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b><span lang="EN">UK:</span></b><span lang="EN"> Starting salary will be from £63,840 - commensurate with experience</span></span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span lang="EN" style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Applications closing date: Please submit application including CV and cover letter by April 27th </span></li></ul><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Risk Level:</b> ☐ Level 3       ☐Level 2    <b>X Level 1</b> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Level 1: Likely to have no contact with participants or sensitive data) </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>About Mercy Corps</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>The Department: Private Giving & Engagement (PG&E) </b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>The Position </b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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. </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Essential Responsibilities </b></span></div><div style="margin-bottom: 0.0in;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">SQL development in a production environment</span></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Develop, test and document stored procedures, views, tables, indexes, constraints, functions and T-SQL scripts.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Prepare clear and comprehensive technical documentation </span></li></ul><div style="margin-bottom: 0.0in;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Interview stakeholders about reporting needs</span></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.</span></li></ul><div><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Develop and maintain standardized reports using Microsoft’s SQL Server Reporting Services and Microsoft Power BI</span></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Expand, assess, and maintain the SQL Server data warehouse and SSIS-based ETL processes, including improving performance, streamlining legacy workflows, and strengthening documentation </span></li></ul><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Data quality and integrity </span></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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. </span></li></ul><div style="margin-bottom: 0.0in;text-align: justify;"></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Ensure that personally identifiable data and data analytics practices are aligned with Mercy Corp’s Responsible Data Policy.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Cross-train in essential functions to ensure business continuity.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Collaborate with the IT Department to ensure that marketing technical strategy aligns with the broader enterprise roadmap.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Development and maintain OLAP cubes as needed.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Other duties as requested or required.</span></li></ul><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Supervisory Responsibility</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">None.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Accountability </b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Reports Directly To:</b> Director of Fundraising Data & Analytics</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Works Directly With:</b> PG&E Team, Online Database Developer and Manager, IT Team, Database Manager, Development Operations Manager. </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Accountability to Participants and Stakeholders</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Minimum Qualification & Transferable Skills </b></span></div><ul style="margin-top: 0.0px;"><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Bachelor’s degree or equivalent professional experience.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Demonstrated knowledge of data warehousing, database management, reporting development, data cleansing, ETL and data analysis, preferably in a non-profit fundraising environment.</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Demonstrated success using T-SQL or MySQL to support data warehousing and reporting</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Projects, (ideally 5+ years).</span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Knowledge of The Raiser’s Edge ideal; non-profit experience preferred. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">3+ years of experience with fundraising data or other comparably complex data. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Strong written and verbal communication skills; including the ability to communicate effectively with team members of varied work styles. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Proven ability to handle confidential materials and sensitive information. </span></li><li style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">Python experience is a plus.</span></li></ul><ul style="margin-top: 0.0in;"></ul><ul style="margin-top: 0.0px;"></ul><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Success Factors </b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.  </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">They can translate technical concepts into clear, accessible insights for fundraisers and non-technical colleagues, ensuring that data is understandable and actionable. </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.  </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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. </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Living Conditions / Environmental Conditions</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">The position is remote.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Ongoing Learning</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Team Engagement and Effectiveness </b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">We recognize that building a strong and effective team is an ongoing process, and we remain committed to learning, improving, and growing together.</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Equal Employment Opportunity</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"> </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;"><b>Safeguarding & Ethics</b></span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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 <a href="https://www.schr.info/the-misconduct-disclosure-scheme">Interagency Misconduct Disclosure Scheme</a>. 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">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></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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 (<a href="mailto:integrityhotline@mercycorps.org">integrityhotline@mercycorps.org</a>).</span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">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.  </span></div><div style="margin-bottom: 0.0in;text-align: justify;"><span style="font-size: 12.0pt;font-family: sans-serif , arial , helvetica;">We ask that you do not disclose any prior convictions in your application materials or during the recruitment process. </span></div>