UC San Diego Jobs Site

Column Content Left

#94054 Senior Data and Business Intelligence Analyst

Filing Deadline: Wed 6/27/2018

UCSD Layoff from Career Appointment: Apply by 6/18/18 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor. Eligible Disability Counseling and Consulting services (DCC) or Special Selection clients should contact their Vocational Rehabilitation Counselor for assistance.


Under the general direction of the Executive Director of Prospect Development (ED-PD), the Senior Data and Business Intelligence Analyst provides reliable and timely high-level qualitative and quantitative data and trend analysis that supports the strategic planning and operational effectiveness of key fundraising programs, including annual, major, principal, and planned giving. Specifically, the incumbent studies internal and external data and employs data querying and mining, predictive modeling, forecasting, and/or statistical analysis techniques to provide information, knowledge, coordination, and tools that support the campus in achieving its private fundraising goals, as well as to provide assessments of Advancement program effectiveness.

More specifically, responsibilities include but are not be limited to:

Fundraising Reporting
- In consultation with Director, generate and maintain reports illustrating overall, and unit specific results;
- Develop and produce performance reports for fundraising operations including YTD progress toward goals, comparison with prior period and annual reporting;
- Develop and produce campaign progress reports in terms of dollars raised, pipeline, portfolio capacity and development officer activity;
- Implement ‘self-serve’ results delivery system;
- Partner with Senior Management, Director, and Prospect Management Liaisons to determine organizational information and reporting needs.

Fundraising Analysis
- Assess and provide concise, actionable and accurate analysis of fundraising operations;
- Utilizing available data, respond to management analysis needs by developing strategic plans, forecasts, business cases, cost benefit analysis, ROI calculations, and any other analysis required in support of fundraising operations.

Prospect Identification
- Utilizing appropriate quantitative techniques which may include statistical modeling, provide targeted prospect lists to Development Officers to balance and or augment portfolio mix;
- In partnership with senior management, prospect management liaisons and front line fundraisers, determine appropriate characteristics to associate with top prospects;
- Develop and implement appropriate tracking and metrics in support of modeling efficacy.

  • Must have access to reliable transportation.

  • Occasional evenings and weekends may be required.


  • 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.

  • Demonstrated ability to analyze information, situations, problems, policies and procedures; identify and communicate root cause of issues; identify potential solutions; apply solutions and formulate logical and objective conclusions from data and observations; communicate conclusions to a variety of personnel at various levels.

  • Experience in querying, cleansing and manipulating large data sets.

  • Advanced knowledge of analytical techniques, advanced knowledge of SQL or other structured language, advanced knowledge of Excel required.

  • 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.

  • Working knowledge of the principles and practices of philanthropy, sales or marketing.

  • Demonstrated experience in business analytics. Ability to understand complex relational data structures.

  • Ability to leverage knowledge of data needs, data sources and data solution technologies to provide clients with accurate and timely (often real-time) prospects, results and analytical reports.

  • Strong written and verbal communication skills with the ability to convey complex information in a clear, concise manner.


Job offer is contingent upon satisfactory clearance based on Background Check results.

The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age, protected veteran status, gender identity or sexual orientation. For the complete University of California nondiscrimination and affirmative action policy see: http://www-hr.ucsd.edu/saa/nondiscr.html

UC San Diego is a smoke and tobacco free environment. Please visit smokefree.ucsd.edu for more information.

Payroll Title:
Hiring Salary Range
$63,400.00 - $75,000 / Year
Appointment Type:
Appointment Percent:
Total Openings:
Work Schedule:
Days, 8 hrs/day, Mon-Fri