University of Michigan

Statistical Programmer/Data Analyst

Prospect Development & Analytics, Office of University Development

Working Title

: 

Statistical Programmer/Data Analyst

Posting Number

: 

73614

Job Category

: 

Prospect Development and Analytics

Salary

: 

$45,000 - $54,000

Reports To

: 

Associate Director of Analytics

Experience Range

: 

2 to 5 Years

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

To apply for this position, please submit your cover letter and resume as one document on the University of Michigan Careers at the U site.

If you are unable to apply via the U-M Jobs site, please submit your cover letter and resume to dev.careers@umich.edu. In the subject line, please type in the Job ID# for which you are applying.

For questions about the U-M application process, please refer to the FAQ page

Position Description

The Statistical Programmer/Data Analyst provides reliable and timely qualitative and quantitative data and trend analysis that supports the strategic and tactical planning and operational effectiveness of key fundraising programs, including annual, major, principal and planned giving. Specifically, the Statistical Programmer/Data Analyst studies internal and external data and employs data mining, predictive modeling, forecasting and statistical analysis techniques to help identify, classify, understand and cultivate prospects capable of making philanthropic contributions to the University of Michigan as well as to provide assessments of program effectiveness.

Characteristic Duties and Responsibilities

Modeling, Statistical Analysis & Prospect Identification (70%)
*Under the supervision of the Associate Director of Analytics and in collaboration with development teams in the Office of University Development (OUD) and across campus, identify specific fundraising issues for review and analysis. 
*Engage in market research, data mining and modeling activities to determine trends and provide increased understanding and hypothesis testing of patterns in alumni and donor behavior, identifying and forecasting growth opportunities and addressing challenges. 
*Collaborate with department colleagues and those in major giving, annual giving and planned giving, as well as specific school, college and unit partners, in prospect identification at all levels. Develop and execute propensity and predictive behavioral models to support the development of short- and long-term engagement strategies.
*Gather, filter and segment large data sets for the purposes of identifying, classifying and refining rated prospect lists and pools for fundraising activities. Identify overall trends and patterns in giving, volunteerism, event participation, etc. and search for explanations and underlying causes. 
*Develop predictive model custom scoring and provide recommendations to unit managers and fundraisers for how to interpret, understand and apply scoring in various fundraising activities.
*Use various software tools (Excel, Access, SPSS, SAS, R, SQL Server, Weka, Tableau, MapPoint, PowerPoint, among others) to analyze and present the data analysis relative to specific development -related needs. Techniques used include regression and time trend or RFM analysis, cross-tabulation, pivotal table analysis, segmentation etc.
*Synthesize information and disseminate results through written reports, maps, charts, graphs and presentations. 

Knowledge & Data Resource Building and Management (15%)
*Leverage available data sources and retrieve, query and append data from internal databases, and external data sources such as electronic screening services, census records, surveys, focus groups, demographic studies, marketing data, etc.
*Work with the OUD Development Services team, as well as other relevant University and external data and business intelligence resources, to obtain, share, append and maintain information needed for market analysis and strategic planning projects. 
*Identify sources of data on campus and manage the interactions and relationships with data owners. 
*Stay abreast of current and emerging trends in philanthropy, fundraising, higher education and business intelligence; communicate to department and senior leadership as appropriate.

Analytics Program Outreach (15%)
*Work with University staff as an internal consultant to define quantitative analytics needs and guide team to meet those needs. 
*Collect marketing and benchmarking data that supports the business processes/outcomes of U-M?s fundraising efforts. 
*Work with prospect research analysts and fundraisers to offer decision support and to promote the cultivation of prospects at the appropriate levels and through the appropriate channels. 
*Promote and support data-driven decision making within the development community.

Perform other duties as assigned. (5%)

Required Qualifications

*Bachelors degree or equivalent combination of education and experience required, with demonstrated competencies in applied marketing research, sales and/or marketing analysis, social science research and/or similar fields.
*Related experience conducting projects in market research, statistics, fundraising or relevant fields. 
*Fluency in computer technologies, including high level of proficiency and understanding with data mapping, data mining and statistical software tools, (Excel, Access, SPSS, SAS, R, SQL Server, Weka, Tableau, MapPoint, among others). Proficiency with word processing, spreadsheet, presentation and relational database software programs a must.
*Demonstrated analytical and creative problem-solving skills required. 
*Proven research and analytical techniques, emphasizing the ability to gather, evaluate and synthesize complex and large sets of data from various sources and present information in a clear and cohesive manner. Must demonstrate ability to present information in formal and informal settings and impart understanding of complex ideas and statistics to others.
*Highly developed interpersonal, written and oral communications skills required.
*High degree of professionalism ethical sensitivity and discretion; ability to maintain a commitment to confidentiality.
*Ability to manage multiple projects and priorities and meet challenging and changing deadlines.

Preferred Qualifications

*Advanced degree preferred.
*Experience in SQL programming is preferred and reporting utilizing Oracle or MS-SQL Server or related experience a plus.

Mission Statement

The Office of University Development maximizes private support for the University of Michigan through high-quality collaboration with the development programs of schools, colleges, and units. We also provide fundraising leadership through the stimulation and facilitation of healthy, productive and life-long relationships with our colleagues, alumni, friends, foundations and corporations.

U-M EEO/AA Statement: The University of Michigan is an equal opportunity/affirmative action employer.