Senior Data And Business Intelligence Analyst - 122047

Under the general direction of the Director of Advancement Systems and Business Intelligence (Dir-ASBI), the Prospect 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 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.

• Occasional evenings and weekends may be required.

Equity, Diversity, and Inclusion are core values at UC San Diego and Advancement is committed to a continuous process of learning and updating practices to support systemic evolution toward equity, diversity, and inclusion for our team and constituents. We foster the by encouraging and developing a collaborative and positive environment among colleagues. UC San Diego provides resources and services so employees can develop a deeper connection to our diverse campus community. Explore more at and Campus Community Centers.

• Thorough knowledge of Business Intelligence functions, analytics, industry standards and best practices. Demonstrated experience in business analytics. Ability to understand complex relational data structures.

• Thorough knowledge of relevant internal databases, BI applications and tools. Ability to produce high-quality reports and documentation.

• Demonstrated experience in querying, cleansing and manipulating large data sets.

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

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

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

• Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop effective solutions. Demonstrated ability to analyze information, situations, problems, policies and procedures; separate problems from symptoms; 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.

• High degree of professionalism, ethical sensitivity and discretion. Proven ability to maintain a commitment to confidentiality.

• Detail oriented, with ability to manage time and organize competing priorities. Ability to maintain accuracy and focus with attention to detail in fast-paced environment with constantly changing priorities.

• Strong written and verbal communication skills with the ability to convey complex information in a clear, concise manner, and explain analytical result sets to both internal and external audiences at all levels.

• Effective interpersonal skills for effective collaboration with a broad range of professional and technical staff. Professional, highly-developed interpersonal skills including tact, diplomacy, flexibility and skills in dealing with politically sensitive situations required.

• Demonstrated skill in understanding of quality service and group process with proven ability to work as part of a team and build consensus and collaboration. Ability to lead, mentor, and train others. Willingness to share skills and techniques with peers and colleagues.

• Job offer is contingent on clear Background Check.

• Must have access to reliable transportation.

If employed by the University of California, you will be required to comply with our Policy on Vaccination Programs, which may be amended or revised from time to time. Federal, state, or local public health directives may impose additional requirements.

To foster the best possible working and learning environment, UC San Diego strives to cultivate a rich and diverse environment, inclusive and supportive of all students, faculty, staff and visitors. For more information, please visit .

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:

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