What are the responsibilities and job description for the Business Analyst position at Lucile Packard Foundation for Children's Health?
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...
Data Analysis & Reporting – Ability to translate data into actionable insights that support strategic decision-making.
CRM Management & Data Integration – Expertise in managing and leveraging nonprofit CRM systems like Blackbaud’s The Raiser’s Edge.
Stakeholder Engagement & Collaboration – Skill in gathering requirements and partnering with diverse teams to align data solutions with business needs.
Business Intelligence Development – Proficiency in creating effective reports, dashboards and interactive visualizations using tools like SQL and Power BI.
Process Improvement – Capacity to identify inefficiencies and implement data management enhancements to drive organizational effectiveness.
YOU'LL BE SUCCESSFUL IF YOU...
Working at the Foundation
We Offer Excellent Benefits & Perks, Including…
The Foundation is a dynamic organization in a rapidly changing industry. Therefore, the responsibilities associated with this position will evolve and grow in accordance with LPFCH's business needs and growth plans. More specifically, the incumbent may be required to perform additional and/or different responsibilities based on the future growth plans for the Foundation.
WE STRIVE TO EMBODY OUR CULTURAL TOUCHSTONES…
Mission-first - We can never lose sight of why we exist and who we are here to serve.
Good of the whole - We share responsibility for overall results, think of what’s best for the team and organization, and act as responsible stewards of resources.
Bold and bendy - We’re unapologetically ambitious for our mission, creative, and take risks by trying new things.
Sweat the big stuff - We’re clear on our priorities, calibrating effort and resources to audience and impact: the higher the return, the greater the investment.
Make it happen - We’re focused on outcomes; only as much process as necessary to make good decisions and take action. Prepared with ideas and solutions for every challenge.
Community matters - We embrace diversity and practice inclusion.
WE’RE COMMITTED TO DIVERSITY, EQUITY, INCLUSION AND BELONGING…
Our Foundation embraces all individuals and celebrates the unique differences each of us bring to our team and community. Our approach to fostering diversity, equity, inclusion, and belonging is rooted in our cultural touchstones and inherent in our work to encourage every employee to bring their best, most authentic self to work and to provide each of them the opportunity to achieve their full potential.
We envision a world where race, gender, resources, and other factors do not serve as barriers to attaining optimal health. We recognize that this vision requires the commitment and actions of everyone.
To Support This Goal, We Pledge To
The Pay Range For This Role Is
105,000 - 125,000 USD per year (Palo Alto, CA )
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.
- 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 business units and translating those to programmers and developers.
- Experience successfully partnering with stakeholders to understand data and reporting needs and analyze, interpret, summarize and present information effectively, including visually. Proactive approach to user efficiency.
- Experience developing business analytic tools in a fundraising environment strongly preferred.
- Experience with dimensional modeling preferred.
- Bachelor’s degree or equivalent combination of education and experience in database management, report writing and data analytics. At least four years of relevant work experience.
- Experience demonstrating an advanced knowledge of data management principles and techniques.
Data Analysis & Reporting – Ability to translate data into actionable insights that support strategic decision-making.
CRM Management & Data Integration – Expertise in managing and leveraging nonprofit CRM systems like Blackbaud’s The Raiser’s Edge.
Stakeholder Engagement & Collaboration – Skill in gathering requirements and partnering with diverse teams to align data solutions with business needs.
Business Intelligence Development – Proficiency in creating effective reports, dashboards and interactive visualizations using tools like SQL and Power BI.
Process Improvement – Capacity to identify inefficiencies and implement data management enhancements to drive organizational effectiveness.
YOU'LL BE SUCCESSFUL IF YOU...
Working at the Foundation
We Offer Excellent Benefits & Perks, Including…
- Generous leave, including PTO, holidays, Summer Fridays, and a sabbatical (after 7 years of employment)
- Annual bonus
- Retirement plan employer match
- Premium Medical and Dental coverage
- FSA dependent care FSA
- Employer-paid life insurance
- Legal services plan
- Commuter Benefits, including CalTrain “Go Pass” Program
- 4-week paid maternity and paternity leave for new parents
- Stipend for home office and mobile phone
- If remote, frequent opportunities to visit our beautiful HQ in Palo Alto
The Foundation is a dynamic organization in a rapidly changing industry. Therefore, the responsibilities associated with this position will evolve and grow in accordance with LPFCH's business needs and growth plans. More specifically, the incumbent may be required to perform additional and/or different responsibilities based on the future growth plans for the Foundation.
WE STRIVE TO EMBODY OUR CULTURAL TOUCHSTONES…
Mission-first - We can never lose sight of why we exist and who we are here to serve.
Good of the whole - We share responsibility for overall results, think of what’s best for the team and organization, and act as responsible stewards of resources.
Bold and bendy - We’re unapologetically ambitious for our mission, creative, and take risks by trying new things.
Sweat the big stuff - We’re clear on our priorities, calibrating effort and resources to audience and impact: the higher the return, the greater the investment.
Make it happen - We’re focused on outcomes; only as much process as necessary to make good decisions and take action. Prepared with ideas and solutions for every challenge.
Community matters - We embrace diversity and practice inclusion.
WE’RE COMMITTED TO DIVERSITY, EQUITY, INCLUSION AND BELONGING…
Our Foundation embraces all individuals and celebrates the unique differences each of us bring to our team and community. Our approach to fostering diversity, equity, inclusion, and belonging is rooted in our cultural touchstones and inherent in our work to encourage every employee to bring their best, most authentic self to work and to provide each of them the opportunity to achieve their full potential.
We envision a world where race, gender, resources, and other factors do not serve as barriers to attaining optimal health. We recognize that this vision requires the commitment and actions of everyone.
To Support This Goal, We Pledge To
- Conduct ourselves in a manner that garners trust and respect from others.
- Foster a welcoming and supportive environment for our team members and community.
- Acknowledge and appreciate the dignity, expertise, experiences, and contributions of each other.
- Approach others with an open mind, compassionate heart, actively listening to their perspectives.
- Foster effective teamwork and encourage collaboration amongst our team and constituents.
The Pay Range For This Role Is
105,000 - 125,000 USD per year (Palo Alto, CA )
Salary : $105,000 - $125,000