ADVANCEMENT DATA ANALYST

The University of Texas Rio Grande Valley - 4.3 McAllen, TX Job Details Full-time 18 hours ago Qualifications Data analysis reporting Bachelor's degree Full Job Description Number of Vacancies 1 Location McAllen, Texas Department Advancement Services

FTE 1.0 FLSA

Exempt Scope of Job To maintain the accuracy and integrity of donor and alumni data within the CRM database by analyzing and managing data imports, reporting, analytics, system testing, and data quality. To support fundraising efforts, alumni relations, and advancement operations through data management, reporting, and continuous improvement of CRM processes while ensuring data confidentiality for decision making purposes. Description of Duties 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. 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 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. Physical Capabilities N/A 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 Posting Detail Information 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 to Applicants 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 (956)665-8880 and/or . 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.