This position is vital to our goal of using analytics in fundraising - by providing sophisticated and actionable reports, value-added intelligence and recommendations regarding wealth and engagement and continuing to have another data/base expert that will influence the use of data in developing and evaluating strategies - to help to advance the College in numerous ways.
Reporting to the Director of Prospect Development, with a dotted line to the Executive Director of Advancement Operations and Prospect Development, the Senior Data Analyst and BI Developer plays a crucial role in this relationship management process by providing actionable, value-added intelligence and recommendations regarding Skidmore constituents' wealth, history, and circumstances that would influence engagement and philanthropic capacity and related strategies, or help to advance the College in various ways. The position is responsible for helping leverage data and identifying opportunities for growth, spot trends, as well as recognize potential issues and offer solutions. Their work involves creating actionable reports, analysis and data visualizations for management and external audiences.
Establish and complete analytical projects that are designed to identify new prospects, re-evaluate known prospects, and build the pipeline of potential donors, either working independently or in collaboration with teammates. Assign ratings based on detailed wealth analysis.
Develop and validate statistical and predictive models for alumni, parents and friends for engagement and giving likelihood. Build relationships across campus to collate and share data, reports and expertise.
Implement data mining processes to identify trends and patterns in giving, volunteerism, event participation and provide in-depth data analysis to better understand donor behavior, segmentation strategies and provide recommendations to management staff.
Respond to research requests on individuals or groups, tailoring reporting and/or answering specific questions on wealth, affinity and likelihood of giving, to help guide the work of the frontline fundraisers and management.
Work collaboratively with gift officers and other staff to ensure strategic use of analytics, analysis and research, i.e. suggest prospects for specific funding opportunities, and/or event invitation lists and other cultivation opportunities.
Work as part of the team in maintaining the integrity of the database, including updating records, enhancing data collection and reporting efforts and maintaining data integrity of the prospect management system.
Train new and existing research personnel on the database and reporting available to Advancement staff.
Responsibility to generate summary and specified dashboard reports which represent operational data in brief and intelligible format, suitable for the target audience, which includes executive, leadership department managers and executive board of directors.
Actively manage prospective data and analytical requests to give support to management requirements.
Carry out quality assessment of data, data reports and the accompanying decisions.
Liaise with executive leadership to spearhead the organization in employing data-motivated decision making.
Conduct analysis of findings and offer action-driven recommendations and insights to executive leaders and managers on the basis of results.
Serve on various working group teams as required or available.
This position will be responsible for driving the use of data analytics and reporting for Advancement, and specifically prospect development, presenting complex information and providing recommendations based on data models and analysis. As a key member of the research team, this position is empowered to make recommendations on staff portfolios, prospect management, and building a prospect pyramid. As a member of the operations team, this position will be critical in management of key advancement reports, dashboards, analysis and prediction of engagement and philanthropy at Skidmore.
This position would have extensive interactions with Advancement staff – specifically gift officers and management (i.e. program directors).This position may supervise student worker/interns over time to assist in specialized data analytical projects as available.
Education: Bachelor's degree with 5-7 years of experience in an appropriate area of specialization such as data analytics, statistics, business intelligence - or an acceptable combination of education and experience required. Master’s degree preferred.
Solid technical skills, including direct experience and proficiency in T-SQL, Microsoft Reporting Services, Excel, PowerBI, and/or Tableau. Experience working with relational databases required.
Strong statistical and analytical skills and experience carrying out interpretations by utilizing intricate data sets.
Experience in designing and presenting managerial level presentations and reports.
Outstanding skills in finding resolution to complicated problems while performing independently in a multifaceted and dynamic environment.
Knowledge of fundraising principles and best practices, preferably in higher education or non-profit environment.
Ability to communicate clearly and professionally, verbally and in writing.
Strong interpersonal skills that enable successful relationships with colleagues, both within own team and within the overall department.
Effective training skills.
Demonstrated research experience using both public and subscription-based tools and databases (including international resources).
Ability to handle sensitive and confidential information appropriately and with discretion.
Ability to analyze and summarize extensive and diverse facts into useful information.
Ability to efficiently organize and prioritize a wide range of assignments and projects while demonstrating keen attention to detail, accountability, and follow through.
Willing to experiment with new and different ways to harness tools and resources available to the team. Knowledge of, and experience working with, relational databases, especially in a fundraising context.
Required documents needed to apply:
List of Three References
Pay Range: Commensurate with experience
Apply on line at: http://jobs.skidmore.edu
In order to prevent or significantly reduce the risk of COVID-19 transmission at Skidmore College and protect all members of the College community from infection, successful candidates will be required to submit proof of full vaccination as a condition of employment, unless exempted as a reasonable accommodation of a medical condition or sincerely religious belief or practice.
Skidmore College is committed to being an inclusive campus community and, as an Equal Opportunity Employer, does not discriminate in its hiring or employment practices on the basis of race, color, creed, religion, gender, age, national or ethnic origin, physical or mental disability, military or veteran status, marital status, sex, sexual orientation, gender identity or expression, genetic information, predisposition or carrier status, domestic violence victim status, familial status, dating violence, or stalking, or any other category protected by applicable federal, state or local laws.
Employment at Skidmore College is contingent upon an acceptable background check result.
CREATIVE THOUGHT MATTERS.