Advancement Database Analyst

JOB SUMMARY: The Advancement Database Analyst serves as a database administrator with limited supervision, assisting with the management and maintenance of the Raisers Edge database, while maintaining data integrity, providing gift processing support, and creating any complex queries/exports/dashboards needed to present the data in a format easily used by team members. The position serves as an administrator of other software packages and services used by Advancement, which will require data uploads/exports on a periodic basis. Audits of the data to identify cleanup tasks and reports will be required. This position will also function as a liaison between Advancement Services and other areas and will be involved in project management tasks and on calls with other staff/vendors for various projects to ensure data needs are understood, provide data as needed, and ensure any limitations are identified and brought up as discussions happen. This role will be involved in assessing and making recommendations to management for changes to established policies and procedures or addition of new tools/services/software that will advance our mission and help reach established goals. MAJOR RESPONSIBILITIES / DUTIES / CRITICAL TASKS: Responsible for database management and administration, database maintenance, and data integrity tasks. Perform gift processing activities and reporting. Create basic and complex queries used to export data/lists as needed. Maintain and improve donor relations by ensuring accurate and timely handling, recording, receipting, and acknowledgement of gifts and related data. Create cost centers and perform reclass/budget transfer tasks to ensure gifts are deposited according to donor intent. Create new constituent records and maintain constituent biographical information in Raisers Edge which includes updates of gift/appeal/campaign records as needed. Ensure duplicates are not created when new records are added. Create appeals when needed and ensure gifts are credited appropriately as they come in. Create detailed and customized reports to accommodate the needs of the Advancement team. Perform data imports of new graduates, parents, etc. Create and maintain Raisers Edge dashboards to aid in tracking fund/campaign/appeal performance. Manage access to the Raisers Edge database which includes periodic reviews of current access and making needed changes/additions/deletions. Perform regular audits of database records to ensure gifts are coded with the appropriate fund/appeal/campaign, the correct solicitor is credited (when appropriate), and that the correct attributes are added. Train and support Raisers Edge end-users as needed to enable them to do the tasks needed in their respective areas which includes, but is not limited to, Advancement, Special Events, and Community Partnerships Maintain data entry standards and procedures and update policies and procedures where needed. Communicate with and respond to staff/constituent questions regarding data issues and provide technical expertise as needed. Be able to effectively communicate how to use the database modules and any limitations that may exist. Meet with team members, vendors, or other UT Tyler staff as needed to understand data needs and objectives to provide an informed assessment and what is possible and what limitations might exist. Lead new projects and effectively delegate tasks to ensure timely completion by established deadlines. Stay up to date with established industry standards and identify areas of improvement that will be brought to managements attention. It is expected that this position will have an active role in making recommendations for changes in policy, procedure, and adding new services/software that would be of benefit to Advancement and will help us better meet established goals. Other duties as assigned. ACCOMPANYING KNOWLEDGE, SKILLS, ABILITIES AND COMPETENCIES: Strong working knowledge of database software, preferably Raisers Edge. Must be detail oriented and able to maintain records with a high level of accuracy. Ability to learn and adapt quickly as changes in procedure occur, new processes are implemented, or tasks are re-prioritized. Ability to identify problems, troubleshoot, and propose solutions. Ability to use critical thinking skills, evaluate processes, and find improvement opportunities for better efficiency. Must have strong organizational and time management skills, be able to effectively prioritize tasks, and be able to multi-task in a fast-paced environment while meeting important deadlines and maintaining flexibility. Must be able to work independently and as part of a team by establishing good working relationships with other staff, faculty, students, alumni, volunteers, and donors. Must maintain high standards of integrity and confidentiality and have a demonstrated proficiency working with data and financial information. Strong interpersonal, proofreading, spelling, verbal, and written communication skills. Strong customer service skills. Excellent computer skills required, including the ability to learn special software and databases.