ANALYST III

Caltrans; California (MO); Hybrid; USD 79,000 - 99,000; Full time

Job summary

Caltrans is seeking a PRSM HQ System Administrator and Reporting Specialist in Sacramento County. This hybrid, full-time role focuses on system administration for PRSM and robust reporting capabilities using Oracle APEX, Power BI, and Tableau.

Candidates must manage data quality, reports, and support contract-related activities within a large state transportation context. The position emphasizes ethical practices, self-sufficiency, and collaboration with district PRSM users to deliver timely

Qualifications

• Experience with enterprise-level software systems in large organizations.
• Ability to ensure data quality and develop reports for stakeholders.
• Experience coordinating with business teams, IT and third-party vendors.

Responsibilities

• Act as PRSM system administrator for the HQ.
• Develop and update reports to meet program needs and data quality standards.
• Assist in contract management activities including procurement and budget tracking.
• Ensure contract deliverables align with program objectives and value.

Skills

Data reporting

Report development

Data interpretation

Self-sufficiency

Stakeholder communication

Tools

Oracle APEX

Power BI

Tableau

Job description

Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

Equal Opportunity Employer
The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.

Position Details

Job Code #
JC-531823

Position #(s):
913-176-5402-XXX

Working Title:
PRSM HQ System Administrator and Reporting Specialist

Classification:
ANALYST III

Salary:
$6,623.00 - $8,290.00 A

# of Positions:
Multiple

Work Location:
Sacramento County

Telework:
Hybrid

Job Type:
Permanent, Full Time

Department Information

Caltrans Mission: Improving lives and communities through transportation.

Caltrans Vision: A thriving and connected California.

The Caltrans workforce is made up of diverse and unique individuals who contribute to our organizational success.

Department Website: www.dot.ca.gov

Director’s EEO Policy: https://dot.ca.gov/programs/equal-employment-opportunity

Director’s EEO Policy Statement: https://dot.ca.gov/programs/equal-employment-opportunity

Job Description And Duties

Under the general direction of the Chief, Office of Statewide Project Management Improvement, a Supervising Transportation Electrical Engineer, the incumbent will serves as Project Resource & Schedule Management (PRSM) business-side system administrator. The incumbent will provide additional capacity to the existing PRSM Report Developer (a Senior Transportation Engineer), serving district PRSM users by working to ensure data quality, reports development, and updates to existing reports. Must have a strong knowledge and advanced expertise with data reporting tools such as; but not limited to, Oracle APEX (Application Express), Power BI, Tableau, and have the ability to simplify and interpret data and automate reports. The incumbent also assists in contract management activities, including procurement, monitoring consultant task orders, supporting budget tracking, and ensuring contract deliverables align with program objectives. The successful candidate must be highly self-sufficient and must adhere to ethical practices and policies, ensure best value for the State, and demonstrate a positive attitude and a commitment to providing quality service that is accurate, timely, and exceeds customers’ expectations.

PARF# 44-27-0037 / JC-531823

Eligibility for hire may be determined by your score on the Analyst III exam. For those who do not have current eligibility (e.g., transfer, permissive reinstatement, or voluntary demotions) and/or who will be new to state civil services employment, you must be on the state examination list to be eligible for these positions. To apply for the exam, please click here and search by typing in the classification title.

You will find additional information about the job in the Duty Statement.

Special Requirements

The Statement of Qualifications (SOQ) serves as documentation of each applicant’s ability to present information clearly and concisely in writing. Please follow the instructions below; failure to include and complete the SOQ as instructed may result in the SOQ not being considered and in disqualification from the interview. Each question must be numbered and addressed in the same order as the questions below. The SOQ must be typed, no more than two pages in length, and 12-point Arial font.

SOQ# 1 Provide examples of how your education, knowledge, and experience make you the most qualified candidate for this position.

SOQ# 2 Describe, with an example, your experience supporting or administering enterprise level software systems in a statewide or large organizational environment. Include your role, the systems supported, and the impact of your work.

SOQ# 3 Tell me about your experience working with diverse stakeholders, including business teams, IT, and third-party vendors, in a large organizational setting. How did you navigate differing priorities and ensure alignment across groups?

Possession of Minimum Qualifications will be verified prior to interview and/or appointment. If you are basing your eligibility on education, you must include your unofficial transcript(s)/diploma for verification. Unofficial, original, or official sealed transcripts will be accepted and may be required upon appointment. Applicants with foreign transcripts/degrees must provide a transcript/degree U.S. equivalency report evaluation that indicates the number of units and degree to which the foreign coursework is equivalent. Please visit either of the following two websites for a list of evaluation agencies: https://www.naces.org/members or https://aice-eval.org . Please redact birthdates and social security numbers.

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply. Individuals who are eligible for a Training and Development assignment may also be considered for this position(s).

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process. Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).