ADVANCEMENT DATA ANALYST

University of Texas Rio Grande Valley; Edinburg (TX); On-site; USD 60,000 - 90,000; Full time

Job summary

The University of Texas Rio Grande Valley seeks an Advancement Data Analyst to maintain donor and alumni records within the CRM, analyze imports, and support fundraising and alumni relations through data-driven insights.

The role involves creating queries, producing reports, validating data from multiple sources, and ensuring confidentiality. A Bachelor's degree and two years of data management experience are required; SQL/FetchXML experience is preferred.

Qualifications

• Bachelor's degree from an accredited university.
• Two years of data management experience including data analysis and reporting.
• Preferred: SQL and FetchXML experience.

Responsibilities

• Manage and maintain donor, alumni data in Advancement CRM.
• Develop and produce data queries and ad hoc reports.
• Analyze and import data from multiple sources; validate formatting and mapping.
• Identify and resolve data discrepancies and duplicates; support data cleaning.
• Schedule reports and distribute data to other departments as requested.

Skills

Data analysis

Data management

Education

Bachelor's degree

Tools

SQL

FetchXML

Job description

ADVANCEMENT DATA ANALYST

Posting Number: SRGV9199

Number of Vacancies: 1

Location: McAllen, Texas

Department: Advancement Services

FLSA: Exempt

Scope of Job: To maintain the accuracy and integrity of donor and alumni datawithin the CRM database by analyzing and managing data imports,reporting, analytics, system testing, and data quality. To supportfundraising efforts, alumni relations, and advancement operationsthrough data management, reporting, and continuous improvement ofCRM processes while ensuring data confidentiality for decisionmaking purposes.

Description of Duties:

• Manages, analyzes and maintains large volumes of donor, alumniand fundraising data through the creation and/or modification ofqueries to validate and ensure the accuracy of donor and alumnirecords within the Advancement CRM system.
• Develops and produces data queries, ad hoc reporting based onrequested criteria using programing languages such as SQL andFetchXML, reporting tools and other data analysis technologies tosupport advancement operations.
• Collects, validates and prepares and interprets data fromdifferent internal and external data sources to ensure data filesare properly formatted and mapped correctly before importing tocorresponding database.
• Analyzes and imports data on a daily, weekly, and ad-hocschedule basis (dependent on data sources).
• Identifies, investigates and resolves routine and complex dataentry discrepancies including removal of duplicated records usingthe merge process, ad hoc mass updates, and continuing thedevelopment of the data cleaning process.
• Schedules reports and/or listings and disseminates data toother departments on a scheduled basis or as requested bymanagement.
• Generates insights from advancement data to support fundraisingperformance, donor engagement strategies and advancementdecision-making purposes.
• Collaborates with IT and other university department teams totest new field integrations, system updates and or patches into theCRM database and/or new functionalities. Documents businessprocesses and test findings and reports any issues for support ifnecessary while effectively communicating new functionality toimpacted departments/users.
• Performs application configurations, documents setup changes,workflows and management processes to support advancementoperations and best practices.
• Troubleshoots and resolves reported issues with CRM databaseresulting from data entry errors, integration failures, orsystem/configuration error.
• Creates, maintains and updates functional and technicaldocumentation related to the Data Import Process, Data CleaningProcess, Data Reporting Process, and new CRM functionality.
• Maintains strict confidentiality, discretion and exercisessound judgement while handling sensitive donor, alumni, prospectand institutional information.
• Performs other duties as assigned.

Supervision Received: General supervision from assigned supervisor.

Supervision Given: Direc supervisor of assigned staff.

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 dataanalysis 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. Workis performed primarily in a general office environment. Some traveland weekend work is required. Exerting up to 10 pounds of forceoccasionally, and/or a negligible amount of force frequently orconstantly to lift, carry, push, pull or otherwise move objects,including the human body. UTRGV is a distributed institution, whichmay require presence at multiple locations throughout the RioGrande Valley.

As part of their essential duties, employees in these roles areexpected to maintain a consistent, in-person presence on campus attheir assigned locations. Limited exceptions may apply forpositions that are approved as hybrid or fully remote in accordancewith UTRGV policies.

Other: Exceptional planning and organizational skills. Proficient in dataanalysis. Strong analytical skills and ability to manage largevolumes of data for decision making purposes. Knowledge offundraising terminology and processes and extracting data fromdatabase systems to be used for interpretation and decision-makingpurposes.

Physical Capabilities: N/A

Additional Information:

UTRGV is a distributed institution and working location issubject to change based on need.

All UTRGV employees are required to have a criminal backgroundcheck (CBC). Incomplete applications will not be considered.

Substitutions to the above requirements must have prior approvalfrom the VP of Human Resources.

Employment Category: Full-Time

Minimum Salary: Commensurate with Experience

Posted Salary: Commensurate with Experience

Position Available Date: 10/16/2026

Grant Funded Position: No

If Yes, Provide Grant Expiration Date:

EEO Statement: It is the policy of The University of Texas Rio Grande Valley topromote and ensure equal employment opportunities for allindividuals without regard to race, color, national origin, sex,age, religion, disability, sexual orientation, gender identity orexpression, genetic information or protected veteran status. Inaccordance with the requirements of Title VII of the Civil RightsAct of 1964, the Title IX of the Education Amendments of 1972,Section 504 of the Rehabilitation Act of 1973, and the Americanswith Disabilities Act of 1990, as amended, our University iscommitted to comply with all government requirements and ensuresnon-discrimination in its education programs and activities,including employment. We encourage women, minorities anddifferently abled persons to apply for employment positions ofinterest.