Donor Relations Data Analyst

Job Summary

Are you a data wizard who loves to help your colleagues? Do you spot that one glitch no one else sees? Can you foresee data problems no one else has imagined? Under the supervision of the Senior Director of Donor Relations, the Donor Business Intelligence Specialist plays a key role in campus communications objectives by leading data gathering, integrity, and analysis for the Donor Relations team across Financial Endowment Reporting, donor acknowledgments, our impact reporting calendar, our professorships website, and other key areas as needed.

A successful Donor Relations Data Analyst  will provide user-friendly, easy-to-understand reports that make the data easily understandable to all colleagues, regardless of their role. This includes program metrics for Acknowledgments, Narrative Reporting, Financial Reporting, budgets, and more.

You will manage the Financial Endowment Reporting process for all donors, including maintaining data on donors, funds, reporting status, and verifying financial information. This key project includes reporting to hundreds of donors on thousands of funds across the University and requires advanced Excel skills, Tableau, and Salesforce, high accuracy, and focus, and reporting through web-based software, along with proactive collaboration with colleagues, fundraisers, and UDAR leadership.

You will collaborate closely with our Senior Donor Relations Writer for Acknowledgments by generating template acknowledgments in a timely and accurate manner with a goal of recognizing donors' generosity, expressing appreciation, and stewarding donors by articulating the current needs and vision of the University. Donor Relations generates more than 2,500 acknowledgments each year, with all letters approved and sent within five to seven business days.. This requires close coordination with and reporting on metrics to the Offices of the Chancellor and School Deans. A successful candidate will be able to balance accuracy and speed while delivering acknowledgments based on the donor’s giving level, philanthropic capacity, and other key factors.

You will manage the Donor Relations project calendar for reporting, reviewing incoming gifts, pulling gift documentation, consulting with fundraisers and other colleagues and adding projects to our team’s project management software, conducts monthly audits of all Donor Relations projects in our donor database and project management software to ensure project files are complete and copied for the next reporting cycle, guaranteeing the integrity of our project calendar.

The work of the position will impact the success of UCSF’s fundraising, stewardship, and events programs by building relationships with and securing support from the campus’s external audiences. In the first three months, as the Business Intelligence Specialist, you will forge a strong and productive relationship with our Senior Donor Relations Writer in Acknowledgments and the Senior Director of Donor Relations, familiarize yourself with UDAR and our various systems (Salesforce, Marketing Cloud, WorkFront, Box, Slack, MS Teams, Paperflite, and Tableau, among others), forge partnerships across our team and fundraisers across our development office, and communications colleagues in each of our Schools.

Within six months, you will be tracking incoming gift data for acknowledgments and reporting, managing our reporting calendar in WorkFront, creating Paperflite projects, building reports in Salesforce, analyzing metrics in Tableau, and be a pro at sending acknowledgments in Marketing Cloud. You’ll be our department’s in-house expert and train others on how to build reports and use many aspects of our software, while providing reports and more custom analytics for your colleagues.

Within a year, you will leverage your strategic partnerships across UDAR to analyze data and suggest opportunities to improve workflows, create new reports, continue to be a proactive and engaged collaborator, and be able to anticipate the needs of our fundraisers, leaders, and donors, with a campus-wide insight into philanthropy at UCSF. The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.
The final salary and offer components are subject to additional approvals based on UC policy.

To see the salary range for this position (we recommend that you make a note of the job code and use that to look up): TCS Non-Academic Titles Search (https://tcs.ucop.edu/non-academic-titles)

Please note: An offer will take into consideration the experience of the final candidate AND the current salary level of individuals working at UCSF in a similar role.

For roles covered by a bargaining unit agreement, there will be specific rules about where a new hire would be placed on the range.

To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html

Department Description

The UCSF Foundation and the Office of University Development and Alumni Relations (UDAR) are responsible for fostering and strengthening the campus outreach efforts to UCSF constituents and for garnering private support for the campus and the Medical Center. In raising private support, UDAR identifies, qualifies, solicits and stewards donors for the schools, medical centers, departments and programs on campus; accepts and administers all private gifts to the university through The Regents or the UCSF Foundation; and manages all alumni relations activities, campus support group activities and campus events. The UDAR office staffs the UCSF Foundation. The office is also responsible for the design and implementation of fundraising campaigns for UCSF

Required Qualifications

• Bachelor's degree in a related area and/or equivalent experience/training
• 3+ years work experience in an analytic role, business intelligence or related field
• Thorough knowledge of business intelligence functions, analytics, industry standards and best practices
• Thorough knowledge of relevant internal databases, BI applications and tools. Ability to produce high-quality reports and documentation
• Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop and effective solutions
• Detail oriented, with ability to manage time and organize competing priorities
• Strong written and verbal communication skills with the ability to convey complex information in a clear, concise manner
• Strong interpersonal skills for effective collaboration with a broad range of professional and technical staff
• Proven ability to serve as a technical resource providing advice and counsel on business intelligence issues
• Skill to maintain confidentiality

Preferred Qualifications

• 5+ years work experience in an analytic role
• Working knowledge of fundraising, donor relations and public relations concepts,
• principles, procedures and techniques
• Demonstrated proficiency in proofreading and copy editing. Preferred
• Ability to set, negotiate, and meet priorities and produce high-quality work under multiple
• deadline pressure and within a busy environment with minimal guidance and supervision
• Proficient knowledge of the MS Office Suite (Word, Excel, PowerPoint)

About UCSF

The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world’s leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence – also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity – both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available at diversity.ucsf.edu

Join us to find a rewarding career contributing to improving healthcare worldwide.

Equal Employment Opportunity

The University of California San Francisco is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

Job Code and Payroll Title

004959 BUS INTEL SPEC 3

Job Category

Professional (Non-Clinical)

Bargaining Unit

99 - Policy-Covered (No Bargaining Unit)

Location

Embarcadero Street (SF)

Additional Shift Details

Monday - Friday; 8AM -5PM PST