Transportation Data Lead (JC-533545)

Position DetailsJob Code #: JC-533545Position #(s): 680-167-4616-003Working Title: Transportation Data Lead Classification: PUBLIC UTILITIES REGULATORY ANALYST V$9,631.00 - $12,054.00New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.Shall Consider: PUBLIC UTILITIES REGULATORY ANALYST IV$8,766.00 - $10,973.00# of Positions: 1Work Location: United StatesTelework: HybridJob Type: Permanent, Full TimeDepartment InformationConsumer Protection and Enforcement Division (CPED)/ Transportation Licensing & Analysis Branch (TLAB)/Transportation Analysis Section (TAS) Department Website: http://www.cpuc.ca.gov/ Job Description And DutiesThis role sits within the CPUC's Transportation Licensing and Analysis Branch (TLAB), which regulates TNCs like Uber and Lyft and AV passenger service providers including Waymo. The position is a hybrid technical and policy role: you will help design and maintain the systems and workflows used to manage very large, complex transportation datasets, then work with policy staff to turn regulatory and transportation questions into reproducible analyses, findings, and recommendations.Responsibilities:Manage the ingestion, validation, cleaning, storage, retrieval, transformation, documentation, and curation of large and complex TNC and AV datasets, including confidential regulatory data, to ensure data quality and usability.Maintain and improve data pipelines, storage and retrieval systems, and cloud-based data environments used to organize and analyze TLAB data; coordinate technical requirements and issue resolution with contractors and internal partners that support the data infrastructure.Conduct research and develop reproducible analyses using programming, query, statistical, and visualization tools to answer regulatory and transportation policy questions, identify trends, assess compliance or program impacts, and support policy recommendations.Work closely with transportation policy and program staff to translate policy, regulatory, planning, and operational questions into analytical approaches, data requirements, and useful work products.Communicate analytical methods, findings, limitations, and recommendations to technical and nontechnical audiences, including managers and senior decision-makers.mprove TLAB's data practices by documenting workflows, developing reusable analytical tools, and evaluating new technical approaches and automation that can improve the reliability and efficiency of data management and analysis . Special RequirementsAuthenticity of Application MaterialsApplication materials must reflect your own knowledge, experience, and qualifications in your own words. Generic or templatized responses that do not address the specific requirements of this position, or that appear to misrepresent your qualifications, may result in disqualification from the selection process. Reviewers are specifically evaluating whether your responses demonstrate direct, personal familiarity with the work described.ResumePlease submit a resume. Read and follow the instructions carefully. The resume should be no smaller than 11-point font, single-spaced, and not exceed two typewritten pages. Place your name and job control number JC-533545 in the header. Include your education and work history in reverse chronological order with bulleted descriptions of your relevant experience. Your resume will be scored based on writing quality, clarity, and organization. Submittals that do not follow these instructions may not be scored.Cover LetterPlease submit a cover letter. Read and follow the instructions carefully. The cover letter should be no smaller than 11-point Arial font, single-spaced, and not exceed one typewritten page. Use a standard letter format of your choosing. Place your name and job control JC-533545 number in the header. The cover letter should, in your own words, briefly introduce yourself and explain why you are interested in this specific position, including your interest in transportation, public service, and using technical data skills to inform policy or regulatory decisions. Explain what in your background makes this combination of technical and policy work a good fit. Your cover letter will be scored based on the specificity and relevance of your response, demonstrated interest in the role, and writing quality, clarity, and organization. Submittals that do not follow these instructions may not be scored.SOQPlease submit a Statement of Qualifications (SOQ). Read and follow the instructions carefully. The SOQ must be no smaller than 11-point Arial font, single-spaced, no more than two typewritten pages, and organized in the order described below. Place your name and job control number JC-533545 in the header. Number sections according to the questions listed below. Submittals that do not follow these instructions may not be scored.Your SOQ will be scored for writing quality and for the specificity, depth, and applicability of your experience to the areas below. Reviewers are looking for clear evidence of your personal technical contributions; describe what you personally designed, built, analyzed, managed, or decided rather than only describing the work of a team. Transportation experience should be identified where requested. Note that unnumbered introductory paragraphs to the SOQ are unnecessary and will not be scored for content.Describe one or two examples that demonstrate your experience designing, maintaining, or improving data workflows for large or complex datasets. Explain the scale and complexity of the data, your personal role, and how the data were ingested, validated, stored, transformed, queried, and analyzed. Identify the programming languages, query tools, cloud platforms, data warehouses or data lakes, and other tools you personally used. Describe a significant technical or data-quality challenge and how you addressed it, including how you ensured the resulting data and analysis were accurate and reproducible.Describe an example in which you translated a policy, regulatory, planning, program, or operational question into an analytical approach and used data to inform a decision or recommendation. Explain the question, your analytical approach, the findings and limitations, how you communicated the results to nontechnical decision-makers, and the outcome. A transportation example is preferred; if you do not have direct transportation experience, use the most analogous example and explain how your experience would apply to transportation policy.Describe an example of leading or managing a complex data project involving multiple stakeholders, technical partners, contractors, or data providers. Explain your role in defining requirements, establishing schedules and deliverables, coordinating work, resolving technical or data-quality issues, and ensuring timely delivery. Describe the outcome and any lessons that changed how you managed the project. Final Filing Date: 10/8/2026Required Application Package DocumentsThe 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 required and must be included.Other - Cover Letter is required. Please see “Special Requirements” for instructions.Statement of Qualifications - (SOQ) is required. Please see “Special Requirements” for instructions.