RESEARCH DATA ANALYST II

State of California; San Francisco (CA); Hybrid; USD 74,000 - 96,000; Full time

Job summary

Public Utilities Commission in San Francisco, CA seeks a Research Data Analyst II to collect, analyze, and map broadband data, and to present findings visually using ArcGIS and Tableau. The role involves GIS workflow design, geocoding, and contributing to CASF reports and public information.

The position requires collaboration with Regional Consortia and outside contractors, and includes a hybrid work arrangement with in-office and telework options.

Qualifications

• Experience designing and maintaining GIS workflows, FGDBs and creating shapefiles and maps using ESRI ArcGIS.
• Ability to present quantitative and qualitative data visually using charts, tables, maps and other methods to produce reports and presentations.
• Experience collaborating with project teams and outside contractors; applying project management principles (schedules, tasks, milestones, deliverables).

Responsibilities

• Assist with collection, verification, analysis, interpretation, organization, quality control, storage and mapping of broadband data for CASF funding evaluation.
• Create shapefiles and maps for CASF webpages, reports and other uses; geocode granular data.
• Maintain mapping and location data in the Grant Management System; prepare staff reports and memos.
• Respond to inquiries from CASF Regional Consortia, agencies and the public; update CASF website and public information.

Skills

ArcGIS

ArcMap

ArcGIS Pro

Tableau

Tools

ArcGIS Pro

ArcGIS Online

ArcMap

Job description

Job Posting: Research Data Analyst II

Public Utilities Commission

JC-527537

Research Data Analyst II

$6,647.00 - $8,573.00 per Month

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

Final Filing Date: 8/25/2026

Job Description and Duties

Individuals interested in applying for this vacancy must have eligibility.

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.

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

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.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

• RESEARCH DATA ANALYST II

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details

Job Code #: JC-527537

Position #(s): 680-331-5731-001

Working Title: Research Data Analyst II

Classification: RESEARCH DATA ANALYST II

$6,647.00 - $8,573.00 Effective July 1, 2025, CalHR launched the Personal Leave Program (PLP) 2025 with Pay Differential 386. PLP 2025 temporarily reduces state employee pay in exchange for leave hours to help address budget shortfalls. Salary ranges in this posting exclude the temporary reduction. For details, visit.

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

# of Positions: 1

Work Location: San Francisco County

Telework: Hybrid

Job Type: Permanent, Full Time

Department Information

Communication Division/Broadband Video, Market Branch/CASF Infrastructure

Department Website: http://www.cpuc.ca.gov/

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 Work4CA guide.

It is strongly encouraged to apply through your CalCareer Account at www.jobs.ca.gov

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 https://www.naces.org

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

Benefits Summary

Contact Information

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.

Department Website: http://www.cpuc.ca.gov/

Human Resources Contact:
Talent Acquisition Unit
(916)