Position Summary:
Database Coordinator - Philanthropy
The Philanthropy Systems Coordinator in the?Office?of Philanthropy?is responsible for?efficient?and accurate gift?entry?in alignment with donor intent,?processing of daily gifts/pledges, daily submission of cash deposit/adjustments to finance department for posting to the general?ledger, coordinating the generation of daily acknowledgement?letters, creates, generates, and provides daily, weekly, monthly, quarterly,?semi-annual,?and annual standard reports and others on an ad hoc basis, including financial and progress?reports.? ?
RESPONSIBILITIES:
Gift Processing & Data Integrity
Perform all?Philanthropy/Fundraising gift entries into the Raiser's Edge database based on the approved processes and protocols, including cash receipts, special events, direct mail, credit card transaction, online and general donations and provide a 24-48-hour turnaround on all gift?entries?and donor acknowledgment letters.?
Perform all?Philanthropy/Fundraising gift entries into the Raiser's Edge database based on the approved processes and protocols for gifts received through payroll deductions.?
Prepares monthly pledge reports and pledge reminders performing data validation prior to?approval?process for mailing.?
Financial Coordination & Reconciliation
Lead batching process for deposits, commitments, and credit card transactions aligning with donor intent uploading the batch data for Finance.?
Reporting & Analytics Support?
In conjunction with Director of Operations,?design and deliver advanced analytics, dashboards, and predictive models (donor behavior, campaign performance, pipeline forecasting).?
Support Campaign tracking and donor analysis through?accurate?data entry and reporting.?
Prepares monthly internal fundraising reports for the Development team.?
Assist?with special projects as needed.?
Donor Stewardship Support?
Generate donor acknowledgment letters from the Raiser's Edge for editing per the batching schedule.?
Use expert knowledge of systems, applications, and organizational requirements to create lists,?reports?and data formats to support the needs of team members and partners,?validating?data prior to delivery.?
Systems & Operational Support??
Prepares data selections for solicitations and mailings (appeals, newsletters, annual reports, event invitations, emails, etc.).?
Ensures that all recipients of mailings are coded in the database to track appeals and actions conducted by the?Office?of Philanthropy.?
Provide proper training and guidance to systems users or as technical are?required.?
Gift Fund Guidelines: Manage and perform SharePoint site administration and governance while?maintaining?up to date guidelines.?
Coordinate website maintenance and perform regular audits and updates.?
Create giving pages for events, appeals, and other annual or specialty fundraising/non-fundraising activities?in coordination with team members and Marketing.?
Develop user guides, SOPs, and other training materials for consistent and?accurate?data entry and output.?
Maintain Standard Operating Procedures as?required?in conjunction with the Director,?Operations?and Database Management.?
Monitor and analyze fundraising trends and Blackbaud product updates to?assist?with long-term planning. Share necessary updates with the teams.?
Support API-based workflows and data exchanges when applicable.?
Cross-Functional Collaboration?
Provide liaison support between?Philanthropy?and Accounting for reconciliation processes and manage internal accounting reports.?
Works closely with payroll departments and the Philanthropy Office team to ensure the accuracy of the Team Member Giving Program by comparing monthly payroll deduction files and tracking team member pledges and pledge payments.?
Works closely with the UTHSC College of Medicine, Knoxville and UT Foundation finance and database administration teams to ensure accuracy and best practice implementation.?
Supports Major Gift Officers by adding new constituents in the database and updating existing constituent records as requested so that all information in the database?remains?current and correct.?
Provide opportunities for streamlining and?efficiencies?with technology.?
Grateful Patient Program Support??
Complete data entry for prospects?identified?in the Grateful Patient Program, ensuring proper coding is used as outlined in Grateful Patient Program Tracking Your Success guide.?
Completes ad hoc prospect research and ensures that constituent information is linked and?synced?between Research Point database and the Raiser's Edge database.?
Position Qualification:
QUALIFICATIONS:
Required Education and Experience
Advanced computer skills, particularly with use of relational databases, especially Blackbaud products (CRM, Raiser's Edge) or other?similar products.?
Strong analytical?and problem-solving?skills, including?expertise?in modeling and analysis of data.?
Strong attention to detail, accuracy, and organization
Proficiency in Microsoft Word, Excel, Teams and Adobe
Excellent communication and customer service skills
Ability to maintain confidentiality and meet deadlines
Preferred Education and Experience?
In addition to meeting the required qualifications, the preferred candidate will have:
Associate's or?bachelor's degree in Business, Accounting, Communications, or related field
?
Located in Knoxville, Tennessee, The University of Tennessee Medical Center, has a rich history in the East Tennessee community of providing patient-centered care and remaining at the forefront of research, technology and treatments. UT Medical Center attributes its well-respected standing within the community to the exceptional people that dedicate themselves to patient care excellence. The hospital serves as a referral center for Eastern Tennessee, Southeastern Kentucky and Western North Carolina. It is the region’s academic medical center, Magnet® recognized hospital and Level I Trauma Center.