DATA ANALYST

Posting Number: SRGV
9199

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 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 ofCRM processes while ensuring data confidentiality for decision making 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 from different 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 the development of the data cleaning process.
• Schedules reports and/or listings and disseminates data toother departments on a scheduled basis or as requested by management.
• Generates insights from advancement data to support fundraising performance, 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 business processes and test findings and reports any issues for support if necessary 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 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. Workis performed primarily in a general office environment. Some traveland 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, whichmay require presence at multiple locations…