Business Analyst

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 organizations 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 Raisers 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.

Major Duties :

• 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 Raisers 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 Raisers 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.

Qualifications :

Physical Demands :

Work Environment :

Additional Duties :

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.

EEO Employer

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.

Required Experience :

IC

Key Skills

SQL,Agile,Business Analysis,Visio,Waterfall,Business Process Modeling,Requirements Gathering,User Acceptance Testing,Business requirements,SDLC,Systems Analysis,Data Analysis Skills

Employment Type : Full Time

Experience : years

Vacancy : 1