RESEARCH DATA SPECIALIST III

Caltrans is seeking a Research Data Specialist III for its Transportation Asset Management (TAM) division in Sacramento, CA. The role involves leading business intelligence (BI) and geospatial information systems (GIS) initiatives, developing dashboards, and supporting data governance. The specialist will collaborate with various stakeholders to implement asset management policies and tools, impacting transportation infrastructure decisions across California. Strong data analytics and communication skills are essential.
Job Posting:
Transportation Asset Management (TAM) Business Intelligence (BI) and Geospatial Information System (GIS) Specialist

Department of Transportation

JC-469315

-

Transportation Asset Management (TAM) Business Intelligence (BI) and Geospatial Information System (GIS) Specialist

RESEARCH DATA SPECIALIST III

Job Description and Duties

Headquarters Asset Management is seeking a highly qualified candidate for a Research Data Specialist III position to further the implementation of transportation asset management at Caltrans. Caltrans is leading the nation in the field of transportation asset management, guiding highway infrastructure investments, project selection, maintenance, and improvements. We are seeking a motivated Research Data Specialist III with strong data analytics, business intelligence (BI) and geospatial system information (GIS), and communication skills to be the programs BI and GIS technical expert.

Primary tasks include establishing and maintaining the framework and suite of BI and GIS dashboards, visualizations, and data products to support infrastructure investment decisions for assets, needs, projects, portfolios, and programs. The BI and GIS technical expert is the technical lead on website development of BI tools, GIS tools, and development of scripts to automate data connections to BI and GIS tools. This thought-provoking work will impact Caltrans' policy makers, operational needs, and associated risks. Example analysis may be on climate change adaptation, highway safety, supporting the future of transportation across California. These critical skills will be utilized across all programs within Caltrans to assess potential impact on assets, programs, portfolios and projects across California and to provide a variety of requests to query, validate, format, and organize structured and unstructured data or to develop data models, utilize business intelligence software programs, evaluate geospatial information system mapping, or to forecast trends. This is a great opportunity to gain a broad scope of knowledge across all transportation programs and districts statewide.

The BI and GIS technical expert is the technical lead for Transportation Asset Management Systems (TAMS) BI and GIS implementation covering data governance, data documentation, data quality, developing data standards and data publishing and is the TAMS data custodian and develops and manages the TAMS data quality management plan, training, and supports AMS help desk. The BI technical expert works closely and collaboratively with a diverse set of internal and external transportation managers, staff, partners, and stakeholders in the development, implementation, and adoption of enterprise-level Asset Management BI policy, procedures, guidance, standards, and platforms in the department. The BI technical expert will work independently, meet deadlines on a regular basis, and work with all levels of staff in the Department. The BI and GIS technical expert will support the development and implementation of TAM and TAMS geospatial and geographic information system (GIS) visualization and will collaborate on BI geospatial integrations.

Eligibility for hire may be determined by your score on the Research Data Specialist 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. The Research Data Specialist Exam is located here:
CalCareers

The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.

Apply today to join our team! We especially encourage applicants to check out our

Caltrans Career Compass

tool! The

Caltrans Career Compass

is a tool to assist and help candidates understand and succeed in applying to Caltrans positions.

PARF# 56-5-183 / JC-469315

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

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.
• RESEARCH DATA SPECIALIST III

Additional Documents
• Job Application Package Checklist
• Duty Statement

Department Information

Caltrans Mission:
Provide a safe and reliable transportation network that serves all people and respects the environment.

Caltrans Vision:
A brighter future for all through a world-class transportation network.

The Caltrans workforce is made up of diverse and unique individuals who contribute to our organizational success. Caltrans is about celebrating diversity, valuing one another, and recognizing that Caltrans is strong not in spite of the diverse attributes of our workforce, but because of our diversity.

Department Website:

www.dot.ca.gov

Frequently Asked Questions for an Applicant:

http://dot.ca.gov/jobs/docs/faq-ct-applicants-081617.pdf

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

Special Requirements

Knowledge of Environmental Systems Research Institute Inc. (ESRI) GIS software and BI software for both desktop and server environments and ArcGIS and desire knowledge or experience but not required with relational database management systems such as Oracle database 11g or PostGIS SQL; programming languages such as Javascript and Python; business intelligence tools such as Tableau and Power BI, and web development utilizing application programming interfaces.

Employee will work in a climate-controlled office under artificial light. However, because of periodic problems with the heating and air conditioning, the building temperature may fluctuate. Infrequent travel may be required to various districts statewide and out of state. Must have the ability to work on a keyboard, manual dexterity, sitting for long periods, develop and maintain cooperative relationships, and the ability to focus for long periods of time. Be able to multi-task, adapt to changes in priorities and complete tasks or projects with short notice. Must deal effectively with pressure, maintain focus and remain optimistic and persistent under adversity. Must remain alert in lengthy meetings to collect information. The incumbent may be asked to telework for extended periods of time based on state requirements and will be requested to work in the office based on the business needs of the TAM office.

This position may be eligible for telework. The amount of telework is at the discretion of the Department and based on Caltrans’s evolving telework policy. Caltrans supports telework, recognizing that in-person attendance may be required based on operational needs. Employees are expected to be able to report to their worksites with minimum notification if an urgent need arises. The selected candidate will be required to commute to the headquartered location as needed to meet operational needs. Business travel may be required and reimbursement considers an employee’s designated headquartered location, primary residence, and may be subject to CalHR regulations or applicable bargaining unit contract provisions. All commute expenses to the headquartered location will be the responsibility of the selected candidate.

Your Statement of qualification must be typed in arial 12pt font and must include “Statement of Qualification” in the header. Please provide the question and responses to each of the following five separate questions. For each response, please include years of experience, experience, level of expertise, and cite specific examples that best demonstrate qualifications. A resume or cover letter may not be substituted for the statement of qualification. Applications not following these instructions may be screened out.

1) Describe your experience and knowledge of asset management related principles and describe how you have applied them in previous roles.

2) Elaborate on your experience, tools and techniques conducting business intelligence (BI) analyses to evaluate project benefits, performance, or other relevant metrics that inform decision-making and data governance.

3) Elaborate on your experience, tools and techniques conducting geospatial system information (GIS) analyses to evaluate assets, projects, needs, performance, or other relevant metrics that inform decision-making and data governance.

4) Describe your experience using software tools, such as advanced spreadsheet functions, numerical analysis software, database systems, scripting/programming languages, or other analytical tools, (besides the ones described in question 2 and 3) for the analysis and presentation of assets, projects, needs, performance, or other relevant metrics data.

5) Describe your experience in preparing, writing, or editing reports, presentations, developing and conducting training, developing guidance, and other communication materials for both technical and non-technical audiences.

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.

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).

How To Apply

Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included.
If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

Department of Transportation

N/A

Attn:
Caltrans DHR Contact

Certification Services MS-90

P O Box 168036

Sacramento,
CA
95816-8036

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Department of Transportation

Drop-Off Address

Caltrans DHR Contact

Classification and Hiring Unit - ECOS

1727 30th Street, MS 90

Sacramento,
CA
95816

Closed on weekends and State holidays.

08:00 AM
-
05:00 PM

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:
• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov.
All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is optional. It may be included, but is not required.
• Statement of Qualifications -
• Statement of Qualifications (SOQ) is required. Please see the Special Requirements section for SOQ instructions.

Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

Desirable Qualifications

In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:

Providing a resume is desirable. Information provided on the state application, SOQ, and resume (optional), will be considered to determine candidates to be interviewed.

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.