Business Analyst

Overview

Organization:Washburn University Alumni Association and Foundation
Title:Business Analyst
Job Classification:Exempt, Full-time
Work Schedule:Monday-Friday, 8 am – 5 pm
Reporting Relationship: Executive Director of Administration
Location:Topeka, KS

Primary Accountability:
The Business Analyst provides key analytical and reporting functions to Washburn University Alumni Association and Foundation (“Foundation”) through a customer-service oriented program of analysis and data management to support the organization’s overall fundraising efforts. This position will design procedures, conduct work simplifications and provide strategic and technical insight into the proper entry, query/export and reporting from the Raiser’s Edge (RE) constituent database.

This position will be a key member of the Advancement Information, Analysis & Reporting team which is a dynamic, fast-paced and high-impact part of the organization.

• Key member of the information team impacting overall strategies and fundraising efforts; provides import, export, query and report on data fields quickly and easily from RE to support all divisions of the Foundation as well as campus partner needs from the RE Alumni and Donor database in which the Foundation manages;
• Develops, maintains, and monitors data integration and data sharing/output efforts between the Raiser’s Edge database and other systems; the goal is to facilitate and support all fundraising initiatives and data needs within the Foundation and with other campus partners;
• Manipulates and assimilates large amounts of unique data into meaningful, informative datasets and/or reports primarily through Microsoft Excel;
• Understands the database coding structure for gifts and other related information in the RE database in order to create analytical reports, mailing lists, data analysis projects and other related requests based on that information;
• Prepares Campus Partner Stewardship reports on a monthly basis;
• Support the Annual Giving team with requests, annual giving scorecard, and data needs;
• Develops a firm understanding of the roles and responsibilities of the Gift Information Specialist position to review the daily gift batches as needed, as well as key gift batches as a backup in times of absences or high gift volumes. Quality knowledge of gift accounting procedures is vital to assist with reporting and analysis projects as well;
• Updates planned gift opportunities including the Raiser’s Edge opportunity and attach related documentation for effective reporting for the planned giving program;
• Updates constituent records from daily online obituaries;
• Prepares recommendations for implementation of new system procedures;
• Assists with data surveys as needed;
• Works collaboratively with the Executive Director of Administration and other team members on special projects; and
• Performs other duties as assigned.

• Bachelor’s degree in business, mathematics, accounting, information systems or related degree required;
• Strong analytical and critical thinking skills required;
• Demonstrated reporting, data analysis and data management skills preferred;
• Advanced computer skills including Microsoft Excel and Word required; experience with Blackbaud Raiser’s Edge or similar CRM database preferred;
• Ability to gather large amounts of data, analyze, evaluate and disseminate in a succinct and effective manner;
• Strong attention to accuracy and detail;
• Strong problem solving skills;
• Strong organizational skills, the ability to manage multiple projects, and meet deadlines;
• Appropriate interpersonal skills to collaborate effectively with colleagues and staff;
• Ability to identify and initiate process improvements;
• Professional attitude and the ability to maintain confidentiality;
• Demonstrated ability to work independently and as a team member; and
• Reliable and predictable attendance.

• Ability to sit for extended periods of time; and
• Ability to read computer screens and mail;

• Innovative, dynamic and fast-paced team environment;
• Professional and deadline-oriented environment in an office setting; and
• Interaction with staff and customers.

Additional duties and responsibilities may be added to this job description at any time. The job description does not state or imply that these are the only activities to be performed by the employee(s) holding this position. Employees are required to follow any other job-related instructions and to perform any other job-related responsibilities as requested by their supervisor.

Washburn University Alumni Association and Foundation is committed to building a community of support to continuously strengthen Washburn University and enhance the educational opportunities and experiences of our students. We build life-long partnerships with alumni and friends, and secure, invest, and steward private financial support.