ADVANCEMENT DATA ANALYST

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

Job summary

University of Texas Rio Grande Valley seeks an Advancement Data Analyst in Edinburg, TX to maintain donor and alumni data within the CRM. You will analyze data imports, create queries, and generate reports to support fundraising and alumni relations.

You will collaborate with IT and campus teams to test field integrations, document processes, and ensure data confidentiality for decision making purposes. Strong SQL and FetchXML skills; experience with CRM systems and data quality initiatives is

Responsibilities

• Validate and maintain donor and alumni records in the CRM.
• Create and modify SQL and FetchXML queries for reports.
• Prepare data extracts and ensure correct data mapping during imports.
• Schedule and disseminate reports to campus departments.
• Test system updates and document business processes.

Tools

SQL

FetchXML

Job description

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

Edinburg: [phone]
Brownsville: [phone]
Office hours:
Monday-Friday
8:00a.m. - 5:00p.m.

Faculty Recruitment:
College of Engineering & Computer Science: [e-mail]

Robert C. Vackar College of Business & Entrepreneurship: [e-mail]

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].

Position Information

Posting Number

Posting Number SRGV9199

Working Title

Working Title ADVANCEMENT DATA ANALYST

Number of Vacancies

Number of Vacancies 1

Department

Department Advancement Services

FTE

FTE 1.0

FLSA

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