Power BI Developer
Role details
Job location
Tech stack
Job description
The Power BI Developer supports PG&Es business intelligence environment by designing, building, and maintaining dashboards, reports, and semantic models in Microsoft Power BI. Working closely with the Senior Business Intelligence Developer and the Director of Fundraising Data and Analytics, this role turns fundraising and engagement data into clear, reliable reporting that provides actionable insights for fundraisers and PG&E leadership, including dashboards and reports that support self-service analytics for fundraising teams. While the Senior BI Developer leads data warehouse design, ETL development, and system architecture, the Power BI Developer owns the reporting layer, including dashboard development, KPI design, and user experience.The role is primarily focused on Power BI dashboards, DAX measures, and stakeholder facing analytics, and works as a collaborative partner and thought partner to the Senior BI Developer across the reporting lifecycle, from requirements gathering through deployment, to improve and modernize reporting tools and processes as analytics needs evolveThis role also provides backup support for BI issue triage during periods of coverage, helping identify, document, and escalate data or pipeline issues in partnership with the Senior BI Developer and database teams.
Essential Responsibilities
POWER BI DEVELOPMENT AND REPORTING
- Design, build, and maintain Power BI dashboards, reports, and datasets using DAX and Power Query
- Create clear, user-friendly visualizations and reports for operational and executive audiences that support self-service analytics
- Explore and use Power BI features, including emerging AIassisted capabilities, to improve the efficiency of dashboard and report development
REQUIREMENTS GATHERING AND STAKEHOLDER ENGAGEMENT
- Partner with stakeholders to understand and prioritize reporting needs, translate business questions into reporting solutions, and validate outputs for accuracy and usability
- Communicate insights and reporting logic clearly to nontechnical audiences to support informed decisionmaking
KPI DEVELOPMENT AND ANALYSIS
- Support the definition and implementation of KPIs for fundraising and engagement
- Design dashboards to monitor donor behavior, campaign performance, and operational metrics
- Collaborate with analytics colleagues to ensure consistent business logic and reporting standards
REPORTING QUALITY, VALIDATION, AND COLLABORATION
- Test and validate dashboards and reports to ensure accuracy, consistency, and performance
- Investigate reporting anomalies and partner with the Senior BI Developer and data teams to resolve reporting discrepancies
- Work with CRM, database, gift processing, and BI colleagues to ensure reporting aligns with underlying data models and source systems, and contribute to documentation
SELF-SERVICE AND USER ENABLEMENT
- Support selfservice analytics by providing guidance on how to use dashboards and reports
- Promote best practices in dashboard usage and data interpretation
SAFEGUARDING RESPONSIBILITIES
- Actively learns about safeguarding and integrates it into their work, including safeguarding risks and mitigations related to their area of work.
- Practices the values of Mercy Corps including respecting the dignity and well-being of participants and fellow team members.
- Encourages openness and communication in their team; encourages team members to submit reports if they have any concerns using reporting mechanisms e.g., Integrity Hotline and other options.
Supervisory Responsibility None
Accountability Reports Directly To: Director of Fundraising Data & Analytics Works Directly With: : Senior BI Developer, PG&E Team, Database Manager, IT Team, Development Operations Team
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., 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).
Requirements
- Bachelor's degree or equivalent professional experience.
- 4+ years of experience in business intelligence, reporting, or analytics roles.
- Experience within the humanitarian, NGO, nonprofit, or fundraising sectors is preferred.
- Demonstrated experience building dashboards and reports in Microsoft Power BI, including strong working knowledge of DAX for developing measures and KPIs, and experience using Power Query to prepare and transform data.
- Experience using SQL to query and manipulate data from relational databases.
- Experience gathering business requirements and translating them into reporting solutions, including validating outputs and investigating data issues.
- Familiarity with data warehousing concepts and reporting environments.
- Excellent written and verbal communication skills, with the ability to present complex data and insights clearly to both technical and non-technical audiences.
- Demonstrated ability to handle sensitive and confidential information with a high level of integrity, discretion, and professionalism.
- Fluency in English is required; working proficiency in French, Spanish, or Arabic is a plus., * Experience working in stakeholder-facing analytics or reporting roles.
- Experience working with CRM technologies and data (e.g., Salesforce, Blackbaud).
- Familiarity with Microsoft SQL Server, SSRS, or SSAS.
- Knowledge of Microsoft Power Apps and/or Power Automate is considered a strong asset.
- Exposure to ETL processes (e.g., SSIS or similar tools), particularly for troubleshooting and collaboration.
- Experience working with fundraising or nonprofit data.
- Experience developing or supporting self-service reporting environments.
- Familiarity with digital analytics, segmentation, or A/B testing concepts.
- Exposure to tools such as Python or R for data analysis is a plus.
- Familiarity with AI-enabled analytics tools and an interest in using them responsibly to support reporting and analysis.
Success Factors The successful candidate is curious about fundraising and the questions fundraisers ask, and brings an investigative, analytical approach to working with data. They are comfortable engaging with colleagues to explore business questions and translate needs into clear, practical reporting solutions. They can explain technical concepts, metrics, and reporting logic in plain language, helping fundraisers and nontechnical colleagues understand and act on data with confidence. The ideal candidate works well in a collaborative, relationship driven environment and communicates effectively with colleagues across different roles and work styles. They bring structure and clarity to their work while remaining adaptable as priorities and needs evolve. A steady, solutions-oriented approach to problem-solving and a collaborative mindset are important for success in this role. Awareness of and sensitivity to multicultural and international development contexts are valued.
Benefits & conditions
Open to candidates in any country where Mercy Corps is registered and able to employ staff. Applicants must hold independent right to work for the country of hiring.
Position Status: Full-time, Exempt, Regular
Salary Level:
- US: The starting annual salary for this role will range from USD $90,000 to USD $110,000.
- UK: The starting annual salary for this role is 63,840.
- Other Countries: Salaries will be benchmarked against local market rates and will be commensurate with professional experience and internal equity., $90,000.00