ADVANCEMENT DATA ANALYST

The University of Texas Rio Grande Valley; McAllen (TX); On-site; USD 70,000 - 90,000; Full time

Job summary

The University of Texas Rio Grande Valley is seeking an Advancement Data Analyst in McAllen, TX. This role focuses on managing donor, alumni, and fundraising data within the Advancement CRM system, developing queries in SQL and FetchXML and producing ad hoc reports.

You will validate data across sources, import and clean data, schedule reports, and generate insights to support fundraising performance and engagement strategies. Collaboration with IT and campus partners is essential.

Qualifications

• Bachelor’s degree required.
• Two years of data management experience including data analysis and report preparation.
• Experience with SQL and FetchXML preferred.

Responsibilities

• Manages and analyzes large volumes of donor, alumni and fundraising data in the Advancement CRM system.
• Develops data queries and ad hoc reports using SQL, FetchXML and reporting tools.
• Validates and imports data from multiple sources to ensure proper formatting and mapping.

Skills

SQL

FetchXML

Data analysis

Data governance

Education

Bachelor's degree

Tools

CRM systems

Job description

ADVANCEMENT DATA ANALYST

Position Available Date: 10/16/2026. Employment Category: Full-Time. FLSA: Exempt. Minimum Salary: Commensurate with Experience. Posted Salary: Commensurate with Experience. Location: McAllen, Texas.

Responsibilities

• Manages, analyzes and maintains large volumes of donor, alumni and fundraising data through the creation and/or modification of queries to validate and ensure the accuracy of donor and alumni records within the Advancement CRM system.
• Develops and produces data queries, ad hoc reporting based on requested criteria using programing languages such as SQL and FetchXML, reporting tools and other data analysis technologies to support advancement operations.
• Collects, validates and prepares and interprets data from different internal and external data sources to ensure data files are properly formatted and mapped correctly before importing to corresponding database.
• Analyzes and imports data on a daily, weekly, and ad-hoc schedule basis (dependent on data sources).
• Identifies, investigates and resolves routine and complex data entry discrepancies including removal of duplicated records using the merge process, ad hoc mass updates, and continuing the development of the data cleaning process.
• Schedules reports and/or listings and disseminates data to other departments on a scheduled basis or as requested by management.
• Generates insights from advancement data to support fundraising performance, donor engagement strategies and advancement decision-making purposes.
• Collaborates with IT and other university department teams to test new field integrations, system updates and or patches into the CRM database and/or new functionalities. Documents business processes and test findings and reports any issues for support if necessary while effectively communicating new functionality to impacted departments/users.
• Performs application configurations, documents setup changes, workflows and management processes to support advancement operations and best practices.
• Troubleshoots and resolves reported issues with CRM database resulting from data entry errors, integration failures, or system/configuration error.
• Creates, maintains and updates functional and technical documentation related to the Data Import Process, Data Cleaning Process, Data Reporting Process, and new CRM functionality.
• Maintains strict confidentiality, discretion and exercises sound judgement while handling sensitive donor, alumni, prospect and institutional information.
• Performs other duties as assigned.

Requirements

Required Education: Bachelor’s degree from an accredited university.

Preferred Education: N/A.

Licenses/Certifications: N/A.

Required Experience: Two (2) years of experience in data management to include data analysis and report preparation.

Preferred Experience: Preferred programming experience in SQL/FetchXML.

Equipment: Use of standard office equipment.

Working Conditions: Needs to be able to successfully perform all required duties. Work is performed primarily in a general office environment. Some travel and weekend work is required. Exerting up to 10 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. UTRGV is a distributed institution, which may require presence at multiple locations throughout the Rio Grande Valley. As part of their essential duties, employees in these roles are expected to maintain a consistent, in-person presence on campus at their assigned locations. Limited exceptions may apply for positions that are approved as hybrid or fully remote in accordance with UTRGV policies.

Other: Exceptional planning and organizational skills. Proficient in data analysis. Strong analytical skills and ability to manage large volumes of data for decision making purposes. Knowledge of fundraising terminology and processes and extracting data from database systems to be used for interpretation and decision-making purposes.

Employment Conditions

Employment Category: Full-Time. FLSA: Exempt.

Minimum Salary: Commensurate with Experience. Posted Salary: Commensurate with Experience.

EEO Statement

It is the policy of The University of Texas Rio Grande Valley to promote and ensure equal employment opportunities for all individuals without regard to race, color, national origin, sex, age, religion, disability, sexual orientation, gender identity or expression, genetic information or protected veteran status. In accordance with the requirements of Title VII of the Civil Rights Act of 1964, the Title IX of the Education Amendments of 1972, Section 504 of the Rehabilitation Act of 1973, and the Americans with Disabilities Act of 1990, as amended, our University is committed to comply with all government requirements and ensures non- discrimination in its education programs and activities, including employment. We encourage women, minorities and differently abled persons to apply for employment positions of interest.

Special Instructions

Dear Applicant, Human Resources will not be held responsible for redacting any confidential information from the documents you attach with your application. The confidential information includes the following:

• Date of Birth
• Social Security Number
• Gender
• Ethnicity/Race

Please make sure that you omit this information prior to submission. We are advising that Human Resources will be forwarding your application to the department as per your submission. If you have any questions, please do not hesitate to contact us at [phone] and/or [e-mail].

Additional Information

UTRGV is a distributed location institution and working location is subject to change based on need. All UTRGV employees are required to have a criminal background check (CBC). Incomplete applications will not be considered. Substitutions to the above requirements must have prior approval from the VP of Human Resources.

Applicant Documents

• Resume

1. Cover Letter/Letter of Application
2. Curriculum Vitae
3. Unofficial Transcripts
4. Reference Letter 1
5. Reference Letter 2
6. Reference Letter 3
7. Certifications and Licenses
8. Training Certificates
9. Other Document
10. List of 3 References
11. Unofficial Transcripts 2
12. Unofficial Transcripts 3
13. Letter of Interest
14. Unofficial Graduate Transcripts
15. Additional Document

Posting Supplemental Questions

1. * Are you now, or previously, employed by The University of Texas System or any of its institutions?
   • Yes - I currently am employed by the UT System or its institutions
   • Yes - I have previously been employed by the UT System or its institutions
   • No - I have never been employed by the UT System or its institutions
2. * Are you a current UTRGV employee?
   • Yes
   • No
3. * Please select your highest level of completed education.
   • 6th grade education
   • 10th grade education
   • High School Diploma or GED
   • Associates Degree, Technical, or Trade School Degree/Certification or 60 Hours of College Hours
   • Bachelors Degree from an accredited university
   • Masters Degree from an accredited university
   • Ph. D. or other terminal degree from an accredited university
   • None of the above
4. * Please provide the field of study for your education:

   (Open Ended Question)

5. * Please indicate the number of years of work experience you have directly related to the position in which you are applying for:
   • Less than 1 year
   • 1 year
   • 2 years
   • 3 years
   • 4 years
   • 5 years
   • 6 years
   • 7 years
   • 8 years
   • 9 years
   • 10 years
   • Over 10 years
6. * Do you meet the minimum requirements for this position?
   • Yes
   • No

Final Notice

To ensure the security of your data, you will be logged out due to inactivity in 3 minutes.