DATA ANALYST

University of California, Davis

Under general supervision, work as part of the Advancement Services team supporting fund raising at the UC Davis.

Improve data integrity by analyzing database and developing validations and audits to improve overall data quality.

Provide input on how newly acquired data should be stored in the database to best meet user needs and be consistent with existing data. Co-ordinate the distribution of update tasks to staff in other departments; help identify suitable work, staff selection, and staff training. Analyze institutional business needs, system resources, and end user needs to improve existing data entry and input processes. Independently specify, test, and debug user interfaces and SQL queries and programming code. Develop and enforce data standards. Consult with clients and recommend acquisition of new technology solutions to improve or automate existing processes; coordinate and prioritize client requests; delegate staff resources; create implementation plans and conduct project management activities. Communicate Records Management policy and procedure changes to end users as necessary. Analyze processes, create documentation, and collaborate with training staff in the development of end-user training materials.

Serve as part of a team of decision makers who analyze database functionality, coding, and practices for continual improvement. Supervise programmatic data correction, including data downloading, analyzing, programmatic correction, and uploading into an enterprise scale database environment for improving and enforcing data standards. Provide overall database analysis and development across a variety of platforms. Provide general system administration, installation, file management and data transfers.

Physical Demands:

Work in close quarters.

Sit and work in front of a personal computer for extended periods of time.

Work Environment:

UC Davis is a smoke and tobacco free campus effective January 1, 2014. Smoking, the use of smokeless tobacco products, and the use of unregulated nicotine products (e-cigarettes) will be strictly prohibited on any UC Davis owned or leased property, indoors and outdoors, including parking lots and residential space.

Background Check Required:

This position is a critical position and subject to a background check. Employment is contingent upon successful completion of background investigation including criminal history and identity checks.

Yes

Qualifications

Minimum Qualifications:

Extensive database experience in a large-scale database environment maintaining data quality.

Experience analyzing database, developing validations and audits to improve data quality.

Experience analyzing business needs, system resources, and end user needs to improve existing data entry and input processes.

Experience analyzing database functionality, coding, and practices for continual improvement.

Experience developing and enforcing data standards.

Skills in client interaction through written and verbal communication.

Experience working with confidential records.

Independent problem solving skills.

Preferred Qualifications:

Experience managing small to midsize projects.

Working knowledge of SQL.

Experience working within a database environment, including work with interface development and query languages.

Experience developing, testing and debugging site specific applications.

Experience with Advance Web or Advance Windows.

Experience in not-for-profit or fund-raising environment.

Experience with large complex database structures.

To apply for this job please visit tinyurl.com.