Research Data Analyst Oakland, CA,

Position: Research Data Analyst 3  Oakland, CA, Job ID 81754
Research Data Analyst 3 Oakland, CA, Job

University of California Agriculture and Natural Resources

Job Description

Position Summary:

Gathers, analyzes, and interprets a wide variety of programmatic data. Designs and conducts data analysis. Prepares reports, charts, tables, and other visual aids to interpret and communicate data and results. Manages operations of several information systems and provides technical assistance to academic and administrative users statewide.

This position is a career appointment that is 100% fixed.

The home department is the Program Planning & Evaluation Department. While this position normally is based in Oakland, CA, this position is eligible for hybrid flexible work arrangements for applicants living in the State of California at this time. Please note that hybrid flexible work arrangements are subject to change by the University.

Pay Scale: $88,900.00/year to $/year

Job Posting Close Date: This job is open until filled. The first application review date will be 10/24/2025.

Key Responsibilities:

35%

Gathers, analyzes, prepares, and summarizes the collection of information and data. Recommends approaches, trends, sources, and uses. Writes complex queries to gather programmatic data from multiple systems, using SQL in Microsoft SQL Server Management Studio and Microsoft Access, for annual reporting and ad hoc requests. Analyzes and prepares data to inform administrative and program decision making. Provides leadership to compile data for the Program Planning and Evaluation team and contributes to the analysis to meet annual federal program reporting requirements, strategic communications, and advocacy efforts.

20%

Manages day-to-day operations for several information systems, including the following federal systems:
The National Institute of Food Agriculture's (NIFA) Reporting System; the Research, Extension, and Education Project Online Reporting Tool; and the National Information Management and Support System, with over 500 UC ANR academic users. Provides training and technical assistance to users and to campus partners. Is a core member of the multicampus Program Reporting Group with administrative staff from the Deans' Offices.

Liaises with Deans' Offices across multiple campuses and with USDA NIFA on policy and technical questions. Is a core member of the Product Owner Group for Project Board, the UC Cooperative Extension information system developed in-house, working closely with IT that is responsible for programming the system. Conducts testing when enhancements are deployed. Provides technical assistance to users statewide. Be a core team member, working with IT, to replace the publications data collection system Bibliography Project to improve administrative efficiencies.

20%

Develops systems for organizing data to analyze, identify, and report trends. Structures and categorizes raw data to make it easily accessible, usable, and analyzable. Completes tasks such as data cleaning, standardization, classification, and potentially data warehousing. For example, retrieves, analyzes, and compiles UCPath data, the UC systemwide personnel system, for all UC ANR academics across multiple campuses and locations, to provide a quarterly report to leadership to illustrate trends and inform their academic staffing decisions.

Manages an annual statewide survey of community educators to collect on data programmatic scope. Organizes and updates this academic and programmatic staff data in large, complex tables.

15%

Prepares data for presentation in clear and compelling ways for a variety of audiences including administrators across the UC system and academics across disciplines, from senior leadership to researchers in the field, as well as UC ANR clientele/members of the public. For example, manages the programmatic and non-sensitive personnel data tasks for presentation in the online ArcGIS UC ANR Programmatic Footprint Maps.

Tests maps to ensure the data is represented properly. Acts as a member of the project team that works on continued process improvements and map data enhancements.

5%

Analyzes the interrelationships of data and defines logical aspects of data sets. Contributes to researching, assessing, and selecting new data reporting products.

5%

Implements related business processes. Adapts processes to retrieve and analyze programmatic data when organization makes related changes. Manages proposal submission and provides process oversight for academic position planning and funding opportunities.

Requirements:

• Bachelor's degree in related area and / or equivalent experience / training.
• Thorough skills in analysis and consultation.
• Skills to communicate complex information in a clear and concise manner both verbally and in writing.
• Skills in project management.
• Skills at a level to evaluate alternate solutions and develop recommendation.
• Ability to create and edit tables in Structured Query Language (SQL).
• Ability to work independently and with a team.
• Interpersonal and verbal skills to effectively…