Senior Data & Business Intelligence Analyst - 113250
#113250 Senior Data & Business Intelligence AnalystInitial Review Date: Wed 1/26/2022
For the safety and well-being of the entire university community, the University of California requires, with few exceptions, that all students, faculty and staff be vaccinated against the COVID-19 virus and influenza before they will be allowed on campus or in a facility or office. For more information visit: Flu Vaccine Mandate / COVID Vaccine Policy
This position will remain open until filled.
UCSD Layoff from Career Appointment: Apply by 12/09/2021 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor.
Special Selection Applicants: Apply by 12/13/2021. Eligible Special Selection clients should contact their Disability Counselor for assistance.
Under the general direction of the Director of Advancement Business Intelligence (Dir-ABI), 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.
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.
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.
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.
Demonstrated 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.
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.
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.
Excellent written and oral communications skills required to explain analytical result sets to both internal and external audiences at all levels.
Professional, highly-developed interpersonal skills including tact, diplomacy, flexibility and skills in dealing with politically sensitive situations required.
Proven track record in analyzing, developing and proposing business process improvements using quantitative and qualitative analytical techniques.
Job offer is contingent on clear Background Check.
Must have access to reliable transportation.
Job offer is contingent on successful engagement in the UC COVID-19 Vaccination program (fully vaccinated with documented proof or approved exception/deferral).
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.