Research Data Analyst Oakland, CA,

Research Data Analyst 3 Oakland, CA, Job

University of California Agriculture and Natural Resources

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. This position is normally based in Oakland, CA, but is eligible for hybrid flexible work arrangements for applicants living in the State of California at this time. 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. First application review date will be 10/24/2025.

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 federal systems: NIFA Reporting System, Research, Extension, and Education Project Online Reporting Tool, and National Information Management and Support System with over 500 UC ANR academic users. Provides training and technical assistance to users and campus partners. Core member of the multicampus Program Reporting Group with administrative staff from Deans' Offices. Liaises with Deans' Offices across multiple campuses and USDA NIFA on policy and technical questions.

Core member of the Product Owner Group for Project Board, the UC Cooperative Extension information system developed in-house, working closely with IT responsible for programming the system. Conducts testing when enhancements are deployed. Provides technical assistance to users statewide. 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. Example: retrieves, analyzes, and compiles UCPath data for all UC ANR academics across multiple campuses and locations to provide a quarterly report to leadership illustrating trends and informing staffing decisions.

Manages an annual statewide survey of community educators to collect programmatic scope data. 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, and UC ANR clientele/members of the public. Example: manages programmatic and non-sensitive personnel data tasks for presentation in the online ArcGIS UC ANR Programmatic Footprint Maps and tests maps to ensure proper representation.

Acts as a member of the project team that works on continued process improvements and map data enhancements.

5% Analyzes 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.

• Bachelor's degree in related area and/or equivalent experience/training.
• Thorough skills in analysis and consultation.
• Skill to communicate complex information clearly and concisely both verbally and in writing.
• Project management skills.
• Ability to evaluate alternate solutions and develop recommendations.
• Ability to create and edit tables in Structured Query Language (SQL).
• Ability to work independently and with a team.
• Strong interpersonal and verbal skills to effectively communicate with diplomacy and interact with a wide range of academics and staff.

• Must possess valid California Driver's License. Ability to travel on a flexible schedule as needed; proof of liability damage…