DATA ANALYST

Office Location
The University of Texas Rio Grande Valley
1201 W. University Drive
Human Resources
MASS Building 2 nd Floor
Edinburg, TX 78539

Edinburg:
Brownsville:
Office hours:
Monday-Friday
8:00a.m.

- 5:00p.m.

Faculty Recruitment:
College of Engineering & Computer Science: cecs

Robert

C. Vackar College of Business & Entrepreneurship: cobe

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  and/or careers.

Posting Number SRGV
9199

Working Title ADVANCEMENT DATA ANALYST

Number of Vacancies 1

Department Advancement Services

FTE 1.0

FLSA Exempt

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.

• 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