Transportation Data Lead (JC-533545)
California Public Utilities CommissionPosition Details Job Code #: JC-533545 Position #(s): 680-167-4616-003 Working Title: Transportation Data Lead Classification: PUBLIC UTILITIES REGULATORY ANALYST V $9,631.00 - $12,054.00 New 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: 1 Work Location: United States Telework: Hybrid Job Type: Permanent, Full Time Department Information Consumer Protection and Enforcement Division (CPED)/ Transportation Licensing & Analysis Branch (TLAB)/Transportation Analysis Section (TAS) Department Website: http://www.cpuc.ca.gov/ Job Description And Duties This 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 Requirements Authenticity of Application Materials Application 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. Resume Please 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 Letter Please 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 expla…