Reporting to the Assistant Director of Prospect Management and Analytics, the senior prospect data analyst is responsible for providing data driven solutions to Prospect Management and Research (PMR) programs.
Lead the development of analytical strategies, tools and ad-hoc reports to support PMR programs such as centralized portfolio management, prospect identification and assignment, portfolio analysis, portfolio penetration, proposal activity, etc., Provide on-going assessments of programs' effectiveness. Coordinate routine and ad hoc analysis and reporting on University-wide prospect qualification, cultivation and solicitation activities.
In collaboration with the Prospect Research team, plan, develop and implement custom predictive models to facilitate the identification of high quality prospects to ensure portfolios have a sufficient number of prospects to meet goals and to develop an understanding of donor behavior.
Conduct extensive business analysis; extract, organize, manipulate, mine and model data to inform management business decisions related to matters of portfolio management, staff deployment and goal-setting.
Serve as subject matter expert for the PMR team in data manipulation and data analysis and reporting. Provide high level support to the PMR team in the integration of data analysis into day-to-day work. Develop and maintain substantial knowledge of applicable information technology and how data are structured within the development database and complementary reporting tools. Responsible for building-out, maintaining and improving a comprehensive repository of reports and analytics in order to serve the needs of PMR and DEVAR.
Sit for extended periods of time in front of a computer terminal and extensive use of a keyboard.
Must provide own transportation to off-site meetings and events.
Work occasional flexible hours as needed to meet operational need.
UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.
Background Check Required:
This position is a critical position and subject to a background check. Employment is contingent upon successful completion of background investigation including criminal history and identity checks.
Experience in business analysis and project team facilitation in order to extract, organize and disseminate information for data segmentation, statistics, and decision making.
Experience with spreadsheet, query, statistical modeling, data management and visualization software - e.g., Microsoft Access, Excel, Word, Visual Basic and Visual Studio, Structured Query Language (SQL), R, SPSS, Tableau, et al.
High degree of technical skills with proficiency and understanding of data mining, modeling and statistical analysis techniques and software. Direct knowledge and proven experience with manipulating data from relational databases (such as Ellucian's Advance, Reeher platform, Michelangelo). Extensive database experience in a large-scale database environment maintaining data quality.
Exceptional analytical skills to synthesize a high volume of information from a variety of sources and perform complex analysis to produce reports that are usable and actionable to a variety of fundraising professionals.
Expert written communication skills to compose and document complex technical processes as well as issues and their resolution. Strong oral communication skills, including skills to successfully interact and collaborate with varied constituents in a professional manner.
Proven analytical, problem-solving and management skills to independently research, develop, take ownership of, and confidently recommend solutions to complex problems and issues.
Experience in determining priorities, delegating responsibilities, exercising independent judgment and making appropriate decisions.
Project management experience to thrive in an environment of changing priorities and conflicting demands.
Demonstrated understanding and knowledge of the principles of development/fundraising at a major university with emphasis on analysis.
Work experience in a large fundraising organization, especially in higher education.
Working knowledge of R, SPSS, Tableau, or other mainstream software packages used for building statistical data models and for data visualizations
Direct knowledge and proven experience with Ellucian's Advance, Reeher platform, Michelangelo.
Ability to adequately utilize research tools.