Business Analyst

ABOUT THE FOUNDATION 

The Lucile Packard Foundation for Children's Health, in partnership with Stanford Medicine and Lucile Packard Children's Hospital, unlocks philanthropy to transform health for children and families in Northern California - and around the world. Through fundraising and grantmaking, the Foundation drives scientific research, innovation, and policy change that will improve care, advance cures, and reform healthcare systems for this and future generations.  

MAIN FOCUS: Drive data-informed decision-making by translating user needs into impactful reporting strategies with actionable metrics to advance the Foundation's philanthropic goals.

LOCATION: Palo Alto, CA (Hybrid) preferred or Remote-eligible (U.S. only) for an exceptional candidate. For remote candidates: compensation will be based on geographic region.

WHAT YOU'LL DO... 

Leveraging your knowledge of both philanthropy and business intelligence, you will play a critical role in enabling the Foundation to make key business decisions informed by data. You will work in close partnership with the Director of CRM Operations, Data and Reporting and Director of Business Intelligence to support a comprehensive reporting strategy that transforms data into useful and visible information. This position reports to the Director of CRM Operations, Data and Reporting with dotted line accountability to both the Senior Advisor to the CEO/Interim Advancement Services Lead and the Director of Business Intelligence. Using your ability to translate end users’ desire for information into metrics that support our fundraising goals, you will help define and develop reports that provide the most relevant data in an easily accessible form, facilitating the engagement of prospects and increase in philanthropic support for our mission.

The compensation range for this role is $105k-125k annually.

YOU'LL BE RESPONSIBLE FOR...

• Meet with business partners to understand their strategy and objectives to translate frontline business needs into data processes, workflows, and reporting that support and facilitate fundraising work.  This includes defining detailed requirements, establishing clear definitions, proposing and iterating solutions, and documenting methodology and definitions, adhering to best practices but flexing to support specific needs of the organization.
• In partnership with Director of Business Intelligence (who serves as the primary report developer), develop, validate/test, and deploy reports and data visualizations and business processes that provide the fundraising team with the information they need to make business decisions, helping to prioritize resources and engage prospects.
• Facilitate iterative feedback process among end users and developers to ensure functionality aligns with requirements, influence decisions based on prior implementation experience.
• Ensure end user satisfaction by seeking feedback through one-on-one meetings, surveys, and other methods of securing high adoption and satisfaction.
• Ensure a high level of service, productivity and adherence to quality standards, deadlines, and procedures.
• Serve as a subject matter expert in regard to process and procedures for complex technical and functional development systems. Identify gaps in current system and propose solutions.
• Create and maintain comprehensive instructions and definitions associated with different business intelligence tools to ensure consistent, clear and complete understanding of the tool.
• Provide ad hoc reporting and analysis of giving, prospect movement/engagement, gift officer activity, and other relevant information to inform fundraising strategy.
• Aid in organizational readiness for CRM conversion.
• Provide training and support to end users on business intelligence resources.
• Identify ways to influence and drive process improvements in the Foundation’s data management and reporting practices and make recommendations accordingly.
• Complete special projects as needed and assigned.

YOU MUST HAVE...

• Advanced working knowledge of Blackbaud’s The Raiser’s Edge database or extensive experience with other nonprofit CRM solutions. Experience writing SQL and creating Power BI reports strongly preferred.
• Experience gathering requirements from busi