Data Analyst

Data Analyst

Agency: Prairie View A&M University

Department: Vice President for University Advancement

Proposed Minimum Salary: Commensurate

Job Location: Prairie View, Texas

Job Type: Staff

The Data Analyst serves as the primary point person and subject‑matter expert for advancement systems, data coordination, reporting, analytics, and gift operations within the University Advancement division at Prairie View A&M University (PVAMU). This position gathers, compiles, analyzes, interprets, and reports data while identifying trends and patterns to support operational effectiveness, strategic planning, donor stewardship, and institutional decision‑making. The role functions as the day‑to‑day operational lead for the advancement of customer relationship management (CRM) system and related platforms, collaborating closely with University Advancement, the Prairie View A&M Foundation (PVAMF) Finance team, University Finance, Information Technology, and other stakeholders.

• Develops, maintains, updates, and manages databases and reporting systems for specialized projects and operational functions.
• Serves as the primary administrator and point of contact for the advancement of CRM system and related platforms, ensuring accurate constituent, donor, gift, pledge, prospect, and fund data.
• Implements and maintains data standards, business rules, naming conventions, and coding structures as approved by Advancement Services leadership.
• Coordinates ongoing data quality initiatives, including audits, validation, reconciliation support, and data cleanup activities to ensure data integrity and consistency.
• Configures and maintains system settings, user access, security roles, imports, exports, and integrations in collaboration with Information Technology and in accordance with approved policies.
• Supports system enhancements, automation initiatives, and implementation of new tools by gathering requirements, testing functionality, and assisting with user adoption.
• Collects, manipulates, tallies, and analyzes quantitative and qualitative data using accepted statistical and research methods.
• Coordinates and supports the timely and accurate processing of gifts and pledges across all giving channels, including online transactions, mailed payments, corporate and foundation gifts, matching gifts, securities, wire transfers, and in‑kind contributions.
• Partners with the PVAMF Finance team and University Finance to support gift deposits, fund transfers, reconciliations, and supporting documentation between Foundation and University systems.
• Ensures gifts and pledges are recorded, classified, and tracked in alignment with donor intent, institutional policies, and regulatory requirements, and assists with reconciliation activities between advancement systems, Foundation records, and University financial systems.
• Supports compliance with IRS regulations, CASE standards, AFP Donor Bill of Rights, institutional policies, and audit requirements.
• Identifies potential data or process issues and escalates discrepancies, risks, or exceptions to leadership for review and resolution.
• Supports pledge tracking, billing schedules, reminders, adjustments, write‑offs, and reconciliation activities to assist with donor fulfillment and revenue forecasting.
• Responds to requests for information and prepares standard and ad‑hoc reports, dashboards, queries, analyses, and data extracts in various formats.
• Analyzes and interprets institutional, donor, fundraising, and operational data to identify trends, patterns, and opportunities for improvement.
• Compiles data into usable reports and presentations for leadership and stakeholders; prepares, maintains, and presents historical, comparative, and performance data to support strategic planning and decision‑making.
• Supports campaign, annual giving, and major gift reporting, including segmentation, forecasting, trend analysis, and performance measurement.
• Ensures the accuracy and consistency of data used in donor stewardship reports, surveys, impact reports, recognition efforts, and compliance reporting; prepares and presents technical information and educational materials for non‑technical audiences in a…