JOB SUMMARY:

Responsible for the protocols, maintenance and infrastructure of all databases related to the Development operations at UTMB.  Program areas to support include development, alumni relations, events planning, stewardship, research, gift processing and endowments.  Serves as the data custodian of all fund raising and alumni relations information for UTMB and works with development leadership to set the direction and assist in the formulation of strategy to accomplish UTMB fund raising and alumni relations information system needs.

ESSENTIAL JOB FUNCTIONS:

·        Creates complex downloads for custom and routine reports (such as fund, appeal, or constituency; labels for particular constituencies; management reports regarding various fund-raising activities)  requiring knowledge of SQL table structures, and skill using SQL Server, Microsoft Access, Visual Basic for Applications, Crystal Reports, Microsoft Word and Excel. 

·        Provides ad-hoc reporting support and assists end users in creating report specifications.

·        Works with database users and other technical staff to troubleshoot reported problems pertaining to reports and application software.  Ensures follow-through on reported problems to final resolution.

·        Responds to routine reporting needs for development, other campus entities and UT System including the annual reporting of the Voluntary Support of Education report, quarterly reporting of Chancellor’s Council, and monthly reporting of gifts of $1 million or more, GASB and others.

·        Supports and maintains development office databases and their integrity including Raisers Edge, a proprietary database that serves as the primary development database for gift and constituent management.  Responsible for implementing software upgrades.

·        Works with development leadership, campus resources and outside vendors(s) to assess strengths and to identify improvements to existing databases and to implement/enhance systems as needed.  Leads efforts to design, code, test, install, and implement current and future database applications.

·        Implements new methods of coding to properly extra data.

·        Sets goals, implements actions, oversees budget and timeline, measures results and disseminates information throughout department. 

·        Analyzes development data and provides regular reports to development leadership including advancement services activity reports.

·        Updates and assigns security rules, classifications and responsibilities.

·        Maintains database dictionaries, code files and tables.  Develops policies and procedures for the storage and use of information relating to fund raising and alumni relations.

·        Assists end users in understanding RE system functions and data relationships that impact their reporting needs.  Develops training programs necessary to educate development staff concerning the department’s computing platform, and centralized reporting environment and reporting tools including new development staff as well as routine and advanced users. 

·        Supervises programmer analyst I and coordinator II, including overseeing completion of job duties, delegating work projects, time management guidance, providing training and counseling, and performance reviews.

·        Responsible for data integrity and the continuous update and improvement of development data.  Develops and implements a schedule of continuous improvement and routine maintenance.  Ensures integrity and consistency of data by creating and processing verification reports.  Responsible for all global changes and data imports.

·        Works with outside vendors (ex. Wealth Engine and Blackbaud) to update and enhance constituent data including constituent addresses, and to identify potential development prospects.

·        Adheres to internal controls and reporting structure. 

MARGINAL OR PERIODIC JOB FUNCTIONS:

·        Performs related duties as required.

REQUIRED EDUCATION / EXPERIENCE:

 Bachelor’s degree and a minimum of five years related experience.   

EQUIPMENT:

Standard office equipment.

WORKING ENVIRONMENT/LOCATION OF POSITION:

Standard office environments.

OTHER:

Specific job requirements or physical location of some positions allocated to this classification, may render this position security sensitive, and thereby subject to the provisions of Section 51.215, Texas Education Code.

ANY QUALIFICATIONS TO BE CONSIDERED AS EQUIVALENTS IN LIEU OF STATED MINIMUMS REQUIRE THE PRIOR APPROVAL OF THE VICE PRESIDENT FOR HUMAN RESOURCES AND EMPLOYEE SERVICES.