Advancement Database Analyst I or II, Advancement Services

University of Texas at San Antonio; San Antonio (TX); Hybrid; USD 46,000 - 54,000; Full time

Job summary

The University of Texas at San Antonio is seeking an Advancement Database Analyst I or II to support the Office of Advancement Services by developing, maintaining, and optimizing the UTSA Advancement database and related systems. This role enables fundraising, alumni engagement and strategic decision-making.

This position will be filled at either level based on qualifications and department needs and will involve collaboration with fundraising, alumni relations, and communications teams,

Qualifications

• High School Diploma required; a Bachelor's degree may be substituted for experience on a one-for-one basis.
• Advancement Database Analyst I requires 3 years of related work experience.
• Advancement Database Analyst II requires 5 years of related work experience.
• Ability to maintain the security and integrity of UT San Antonio and its infrastructure per TexasEO-GA-48.

Responsibilities

• Monitor performance, optimization, and integrity of database policies and procedures.
• Collaborate with the technical lead to advise management on university databases and technologies.
• Develop, manage, test, and support enterprise database systems and applications.
• Design, create, implement, and maintain enterprise database reports, functions, and processes.
• Assist as a member of the Advancement Enterprise team to ensure system availability and support.
• Complete database projects promptly.
• Perform routine audits of enterprise databases for compliance with standards.
• Develop and manage documentation related to the university's database environment.
• Support development of analytical reports for advancement, development, and prospect research.
• Support development of advanced queries and exports for segmented communications datasets.

Skills

Verbal and Written Communication

Attention to Detail

Collaboration

Database Processes and Design

Microsoft Office Suite

Education

High School Diploma

Bachelor’s degree substitution allowed

Bachelor’s degree

Tools

MS Access

Excel

HTML

Job description

Advancement Database Analyst I or II, AdvancementServices

Location: San Antonio, TX

Regular/Temporary: Regular

Job ID: 16468

Full/Part Time: Full Time

Position Information

The University of Texas at San Antonio (UT SanAntonio) is a nationally recognized, top-tier public researchuniversity that unites the power of higher education, biomedicaldiscovery and healthcare within one visionary institution. As thethird-largest research university in Texas and a CarnegieR1-designated institution, UT San Antonio is a model of access andexcellence — advancing knowledge, social mobility and public healthacross South Texas and beyond. UT San Antonio serves approximately42,000 students in 320 academic programs spanning science,engineering, medicine, health, liberal arts, AI, cybersecurity,business, education and more. With 17,000 faculty and staff, UT SanAntonio has also been recognized as a Top Employer in Texas byForbes Magazine. Learn more online, on UT SanAntonio Today or on X, Instagram,Facebook, YouTube or LinkedIn.

Salary Range: $46,330–$54,380, commensuratewith education, experience and level of position filled.

Job Type: Full Time

Posting Close Date: Applications will beaccepted through 11:59 PM CDT on the listed close date. At thediscretion of the hiring department, this posting may close once asufficient number of qualified applications have been received.

Required Application Materials

• Resume and Cover Letter are required.

Job Details

Job Summary

The Advancement Database Analyst I/II supports the Office of Advancement Services through the development, maintenance, and optimization of the https://www.utsa.edu/giving/ Advancement &Alumni Engagement database and related systems. In addition to managing critical database processes and reporting, this role leverages data analysis, constituent segmentation, and data-driven solutions to support fundraising, alumni engagement, and strategic decision-making.

This position will be filled at the Advancement Database Analyst I or II based on finalist qualifications and department need.

Core Responsibilities

Advancement Database Analyst I

1. Supports departmental operations in a high-throughput production environment by proactively monitoring the performance, optimization, and integrity of database policies and procedures.
2. Collaborates with the technical lead to advise management on university databases and technologies supporting faculty, staff,and students. Consults with and advises users of various applications and tools.
3. Develops, manages, tests, and supports multiple enterprise-wide database systems and applications.
4. Designs, creates, implements, and maintains highly available enterprise database reports, functions, and processes.
5. Acts as a member of the Advancement Enterprise team to help ensure maximum availability and support of information technology systems.
6. Works to complete database projects promptly.
7. Performs routine audits of enterprise databases and systems to ensure compliance with established standards, policies, and configuration guidelines.
8. Develops and manages documentation related to the university's database environment.
9. Supports the development, validation, and creation of various analytical reports related to university advancement, development, communications, and prospect research.
10. Supports the development of advanced queries and exports required for producing key segmented communications and external relations datasets.
11. Performs other duties as assigned.

Advancement Database Analyst II

1. Works closely with other advancement colleagues, such as fundraisers, alumni relations staff, and communications professionals, to understand their data needs and provide data-driven insights and support.
2. Collects, organizes, and analyzes data to identify trends, patterns, and insights to inform fundraising strategies and initiatives. This includes conducting data mining, segmentation, and statistical analysis.
3. Assists with building and generating regular reports and dashboards to measure and report on key performance indicators (KPIs) related to fundraising, donor retention, alumni engagement, and other advancement metrics. These reports will be used to evaluate the effectiveness of campaigns and to inform decision-making.
4. Generates constituent lists for events, fundraising campaigns, and other strategic engagement efforts.
5. Identifies opportunities for system enhancements and process improvements to streamline data management and improve data quality. This may involve collaborating with university IT and Information Security teams or external vendors to implement system upgrades or integrations.
6. Assists with providing training and technical support to advancement staff on the proper use of the CRM system and database. This may include creating user manuals, conducting training sessions, and offering ongoing assistance.
7. Assists with efforts to update the CRM database to ensure accurate and up-to-date constituent records; conducts data entry, de-duplication, and record merging.
8. Performs other duties as assigned.

Required Qualifications

Advancement Database Analyst I

• High School Diploma.
• At the department's discretion, a Bachelor's degree may be substituted for the required experience on a one-for-one basis.
• Three (3) years of related work experience.
• This position may require the ability to maintain the security and integrity of UT San Antonio and its infrastructure per TexasEO-GA-48.

Advancement Database Analyst II

• High School Diploma.
• At the department's discretion, a Bachelor's degree may be substituted for the required experience on a one-for-one basis.
• Five (5) years of related work experience.
• This position may require the ability to maintain the security and integrity of UT San Antonio and its infrastructure per TexasEO-GA-48.

Preferred Qualifications

• Bachelor's degree.
• Salesforce experience.

Knowledge, Skills, and Abilities

Advancement Database Analyst I

• Verbal and Written Communication
• Attention to Detail
• Collaboration
• Database Processes and Design
• Microsoft Office Suite

Advancement Database Analyst II

• Proficiency with database processes and design, MS Access, Excel and HTML.
• Work performed in an office/data processingenvironment.
• Duties require computer work and meticulous accuracy.
• Computer and standard office equipment.

Working Conditions

• Office environment. Ability to travel to and from meetings, training sessions, or other business-related events.

Physical Demands

Advancement Database Analyst I

• Sedentary work; sitting most of the time. Jobs are sedentary; if walking and standing are required, only occasionally. Ability to exert up to 10 pounds of force to lift, carry, push, pull, or otherwise move objects.

Advancement Database Analyst II

• Sedentary work; sitting most of the time. Repetitive hand motion routinely.

This position will work both on campus and remotely inTexas.

Travel and parking expenses are the employee's responsibility.

This position is contingent upon a successful background check. Verification of a valid driver's license and Motor Vehicle Record (MVR) may be completed as applicable. Applicants selected must be able to show proof of eligibility to work in the United States by time of hire.

Equal Employment Opportunity

As an equal employment opportunity and affirmative actionemployer, it is the policy of The University of Texas at SanAntonio to promote and ensure equal employment opportunity for allindividuals regardless of race, color, religion, sex, gender identity, sexual orientation, national origin, age, disability or genetic information, and veteran status. The University iscommitted to the Afforidal Action Program in compliance with allgovernment requirements to ensure nondiscrimination.