Research Data Analyst II

Job Description and Duties

Individuals interested in applying for this vacancy must have eligibility. If you are new to state service or need to gain eligibility to this classification, please Click Here to open the examination bulletin and follow the instructions on “How to apply”.

The examination is a separate process from applying for this vacancy.  Please be sure to follow all instructions for each process.  

Virtual interviews via web portals or phone may be offered as deemed appropriate and feasible by the hiring manager – standard in-person interviews will still be offered if conditions permit.

Under the general supervision of a Program & Project Supervisor, the incumbent will assist with the collection, verification, analysis, interpretation, organization, quality control, storage and mapping of broadband eligibility and subscriber data used to evaluate location eligibility, income and other data for determining project funding from the California Advanced Services Fund Broadband Infrastructure Grant Account .

The person in this position will conduct analytical and statistical data collection using multiple platforms including but not limited to ArcMap, ArcGIS Pro, ArcGIS online and Tableau to incorporate and present data visually using charts, graphs, tables, maps and other appropriate methods in order to produce compelling reports and presentations.

Other Duties include:

• Investigate broadband availability and subscriber data, along with demographic data, for the CASF program;
• Analyze, collect and geocode granular location and demographic data to create shapefiles and maps for CASF webpages, reports and other uses.
• Assist with creation and maintenance of Mapping and Location data portion of Grant Management System
• Review challenges to CASF projects, determine validity, reconcile changes to applications and projects
• Respond to inquiries and assist Regional Broadband Consortia and potential applicants.
• Prepare written reports including but not limited to: staff proposals, white papers, memos and Commission resolutions
• Prepare written reports regarding the CASF program; analyze program data and prepare necessary summary charts/tables
• Respond to inquiries from the CASF Regional Consortia, governmental agencies and members of the public as needed regarding the CASF program.
• Maintain and update CASF website and public information related to the CASF program.

You will find additional information about the job in the .

Working Conditions

This position requires travel.

This is a hybrid position that will require the selected candidate to report to their assigned headquarter office a minimum of two (2) days a week. Hybrid positions may be eligible for telework under California Government Code Section 14200 for eligible applicants residing in California. In accordance with CPUC Telework Policy, telework arrangements are subject to change and may be reevaluated at any time.

Special Requirements

Prepare and submit a response for each question below. The SOQ should provide specific details and examples that clearly demonstrate how your training, experience, and education qualifies you for the position. Refer to the job description and duties, and duty statement to prepare your response. Applicants who do not submit a completed SOQ and writing that exceeds the page limit will not be considered or scored. All information in the SOQ is subject to verification. The SOQ must be no smaller than 11-point Arial font, single-spaced, and no more than two pages.

Please number your responses in the same order as the questions are listed, 1- 3. Do not consolidate your responses.

1. Describe and provide examples that demonstrate your expertise with designing and maintaining GIS workflows, FGDBs and creation of shapefiles, maps using the ESRI ArcGIS platform.
2. Describe your expertise and provide examples of presenting quantitative and qualitative data visually using charts, tables, maps and other methods to produce reports and presentations.
3. Describe your experience working with project teams, outside contractors and implementation of project management principles (e.g., schedules, tasks, milestones, deliverables).   

For helpful guidance on writing an effective SOQ, please see the

It is strongly encouraged to apply through your CalCareer Account at

Electronic applications submitted through your CalCareer Account are highly recommended and will be received/processed faster than other methods of filing .

If you are using education to meet the minimum qualifications for this position,  you must submit a copy of your transcript or diploma . An official transcript will be required prior to appointment.

Applicants who completed their education outside the United States (with foreign degrees/transcripts) must obtain and submit verification of United States course/degree equivalency by the application deadline. Foreign education credential evaluation services can be found at 

Employment information on the STD 678 State Application MUST be complete with dates, duties and responsibilities, and contact names and phone numbers of supervisors. Resumes, or referring to resumes, will not be accepted in place of the completed STD 678. Applicants who fail to submit a completed STD 678 will not be considered.

Only the most qualified candidates will be invited to an interview.

Per CCR 249.3, this job control may be used to fill subsequent vacancies.   

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:

• Familiarity with broadband policies and data in California and at the national level.
• Familiarity with Microsoft Excel platform advanced functions including but not limited to pivot tables, data management, table construction and report design.

Benefits

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 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 required and must be included.
• Statement of Qualifications - (SOQ) is required. Please see “Special Requirements” for instructions.