5602 Utility Specialist - Utility Data/Software Specialist
|Department||Public Utilities Commission|
|Date Opened||3/10/2020 08:00:00 AM|
|Filing Deadline||7/20/2020 5:00:00 PM|
|Salary||$48.29 - $71.40/hour; $8,370.00 - $12,376.00/month; $100,438.00 - $148,512.00/year|
|Job Type||Permanent PBT|
5602 Utility Specialist
Utility Specialist - Utility Data/Software Specialist
San Francisco Public Utilities Commission
4/1/2020 Update: Announcement deadline has been extended to continuous opening. Applicants who are interested are encourage to apply as soon as possible, since the announcement may close at any time without notice.
This is a Position-Based Test conducted in accordance with CSC Rule 111A.
Who are we?
San Francisco Public Utilities Commission (SFPUC)
Headquartered in San Francisco, we have 2,300 employees working in seven counties with a combined annual operating budget of over $900 million.
Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.
Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.
We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at www.sfwater.org
We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality. As you explore career opportunities with us, download our career guide and learn about what you can expect during the hiring process.
Under general direction of one of the Power Wholesale and Retail Services, Retail Services or Energy Data Systems managers, Utility Specialists hired under this announcement will operate software, perform data analysis, and act as subject matter experts (SMEs) for critical operational functions of the electric utility, which include power scheduling, settlements, load forecasting, meter data management, and energy accounting.
The position requires experience in utilizing and managing utility software to conduct complex analysis, perform operational tasks, manage data, and create reports. Successful candidate must have the ability to interpret and work within regulations, contracts and policy directives; translate technical terms and concepts for non-technical users; suggest and document process improvements; and ability to use independent judgment within established policies and problem solve.
This position requires strong written and verbal communication skills. Utility Specialists should be able to work both independently and collaboratively in a team environment, have excellent problem-solving skills, and be able to keep management and key project stakeholders informed of important project milestones and events.
Acts as a business expert on data that is sent to/received from the California Independent System Operator (CAISO), PG&E, EPA, and other agencies and providing expertise for assigned specialty area
Creates or generates reports from databases using SQL or with business intelligence software
Assists with tracking environmental attributes and commodities for our utilities' load, generation and trades
Communicates technical ideas and concepts to business users, vendors, and to non-technical persons
Performs data analysis on large sets of meter, account, billing, and power scheduling data
Assists with administration of, and operating various utility software packages, which may include energy forecasting, meter reading, meter data management, energy accounting, GIS, hydro modeling, and power scheduling software
Participates in the analysis and development of business requirements for utility database, process and software improvements; and for compliance reporting
Develops user and technical documentation for software and business processes, creating written reports, and other written deliverables
Monitors operations to ensure compliance with policy directives, laws, regulations and contractual constraints
Supervises Utility Analysts and other technical personnel
Class 5602 Utility Specialist performs other related duties as required.
This recruitment has 3 vacancies available. Please see below for specific position descriptions.
Energy Scheduling and Settlements
Under the direction of the Energy Scheduling & Settlements Manager, the Utility Specialist will perform a wide variety of duties related to energy scheduling and complex procurement planning analysis. This position will utilize scheduling software tools to submit day-ahead and real-time schedules, execute energy trades to maximize revenue and minimize costs, as well as perform complex modeling and analysis to develop short and long-term procurement plans.
The mandatory work hours for the position above is from 7:30 a.m. to 4:30 p.m.
Retail Data Specialist
This position will report to the Retail Services Manager. Primary responsibilities will include: maintaining and developing models to forecast load over short, medium, and long-term horizons; doing analysis on large sets of data; preparing/managing various reports for compliance with local, state and federal agencies; monitoring operations (generation, loads, trade activity) for compliance with risk management and reporting requirements; and documenting and improving upon business processes around forecasting, reporting, and other Retail Services functions.
Energy Data Systems Specialist
This position will report to the Energy Data Systems manager. Primary responsibilities will include: managing software implementation projects, including performing testing; conducting analysis on large sets of data; developing reports in Cognos; acting as a SME on power scheduling; tracking environmental attributes for load, generation and trades; managing power scheduling software; and becoming an SME for data required by PG&E, CAISO, billing, and government reporting.
Equal Employment Opportunity: The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.
If you are interested in a job like this, we are looking for people that have the following:
Possession of a baccalaureate degree from an accredited college or university preferably with major coursework in Law, Engineering, Environmental Studies, Natural Resources, Computer Science, Business Administration, Mathematics, Statistics, Economics or other field related to the utility business; AND
Four (4) years of verifiable journey-level work experience in one or more of the following areas: planning, scheduling, cost estimating and resource projecting for mid to large scale projects; water supply management and planning; power operations planning and scheduling; analysis, interpretation and application of utility contracts and regulations in either water, power (electric and/or natural gas), telecommunications, or a wastewater program; utility market and environmental analysis and planning; power supply and transmission rates and contracts; generation, transmission or distribution planning and design; or long-term utility systems planning.
SUBSTITUTION: Additional qualifying experience may be substituted for the degree requirement on a year-for-year basis.
SPECIAL CONDITION: Two (2) years or twenty-four (24) months of verifiable experience utilizing and managing utility software including conducting complex data analysis and business process analysis, creating business requirements, and interfacing /liaising with IT software vendors.
Knowledge of or familiarity with electric industry and markets;
Experience with report and presentation design (e.g., in Excel and PowerPoint);
Experience utilizing databases and reporting tools;
Experience conducting analysis of large data sets;
Knowledge of or familiarity with software used by the electric utility (forecasting, meter data, billing, energy accounting)
The above minimum qualifications reflect special conditions associated with the position to be filled. They may differ from the standard minimum qualifications associated with this classification.
Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted. All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included in the “Education” and “Training and Employment Record” sections of the City and County of San Francisco online application by the filing deadline. A resume does NOT substitute for this section of the City application and will not be considered in determining whether you meet the minimum qualifications.
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.
Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.
If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456.
Verification of required work experience typically must be on the employer’s letterhead, and must include the applicant’s name, job title, description of job duties, dates of employment, hours per week, and signature of the employer, supervisor, or appropriate representative.
Employees of the City and County of San Francisco may submit performance evaluations showing duties performed to verify qualifying City experience. City employees will receive credit for the duties of the class to which appointed. Credit for experience obtained outside of the employee's class will be allowed only if recorded in accordance with the provisions of Civil Service Commission Rules. CCSF employees will not receive credit for experience obtained outside of their classification unless recorded in accordance with the provisions of the Civil Service Rule 110.9.1/111A.11.2.
Experience claimed in self-employment will only be accepted if supported by documents verifying income, earnings, business license and experience comparable to minimum qualifications above. Copies of income tax papers or other documents listing occupation and total earnings must be submitted.
Verification of required valid licensure/certification typically must be a photocopy of the license/certificate including the name of the issuing agency as well as the name of the license/certificate holder, license/certificate number, and expiration date.
How To Apply
Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.
Select the desired job announcement
Select “Apply” and read and acknowledge the information
Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
Follow instructions on the screen
Need help completing the application?
Computers are available for the public from 8:00 a.m. to 5:00 p.m., Monday through Friday, to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.
We communicate by email.
You may be contacted by email about this announcement and, therefore, it is your responsibility to ensure that your registered email address is accurate and kept up-to-date. Also, you must ensure that email from CCSF is not blocked on your computer by a spam filter. To prevent blocking, you should set up your email to accept CCSF mail from the following addresses: @sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu. You will receive a confirmation email that your online application has been received in response to every announcement for which you apply. You should retain the confirmation email for your records. Failure to receive the email means that the online application was not submitted or received.
Word of advice:
All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.
Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.
Have questions about the application process?
If you have any questions regarding this recruitment or application process, please contact the exam analyst,Tiffany Tran, by telephone at 415-554-1670, or by email at TDTran@sfwater.org.
Minimum Qualifications Questionnaire (MQSQ - Qualifying)
Applicants will be prompted to complete a Minimum Qualifications Questionnaire as part of the online application process. All applicants must complete the Minimum Qualifications Questionnaire and it must be submitted with the application by the final filing deadline. The information provided on the Minimum Qualifications Questionnaire must be consistent with the information on the application and is subject to verification. Applicant responses to the Minimum Qualifications Questionnaire will be used to assist in determining if applicants meet the minimum qualifications for the position.
Supplemental Questionnaire Exam (Weight: 100%)
Applicants will be prompted to complete a supplemental questionnaire exam that must be submitted during the online application process. All applicants must complete the supplemental questionnaire. The purpose of the Supplemental Questionnaire Exam is to evaluate the experience, knowledge, skills and abilities that candidates possess in job-related areas, which have been identified as critical for this position and include, but are not limited to knowledge of: basic concepts and terminology related to electric utility agency operations markets, and procedures; utility software including energy forecasting, meter reading, meter data management, energy accounting, geographic information system (GIS) and power scheduling software; Ability to: conduct analysis, including financial, rate and statistical analysis; conduct research analysis; use independent judgment within established policies and problem solve; work collaboratively in a team environment; translate technical terms and concepts for non-technical users; computer skills, including data processing and querying/analysis; strong written communication skills; record keeping and organizational skills; and other job-related duties and responsibilities.
A passing score must be achieved on the Supplemental Questionnaire Exam in order to continue in the selection process and be placed on the eligible list.
Candidates will be placed on the eligible list in rank order according to their final score. Candidate scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.
The department may administer additional position-specific selection procedures to make final hiring decisions.
Candidates scores on this examination may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.
The certification rule for the ranked eligible lists resulting from this examination will be Rule of 10 Scores. The department may administer additional position-specific selection procedures to make final hiring decisions.
Eligible List/Score Report:
A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.
The duration of the eligible list resulting from this examination process will be 6 months, and may be extended with the approval of the Human Resources Director.
Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list/score report resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see https://sfdhr.org/sites/default/files/documents/ASO-Level-Chart.pdf?documentID=21246.
As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:
Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.
Having a conviction history does not automatically preclude you from a job with the City.
If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.
Terms of Announcement and Appeal Rights:
Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.
The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.
Reasonable Accommodation Request: Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at: http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities
Veteran’s Preference: Information regarding requests for Veterans Preference can be found at: http://www.sfdhr.org/index.aspx?page=20#veteranspreference
Seniority Credit in Promotional Exams: Information regarding requests for seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit
General Information concerning City and County of San Francisco Employment Policies and Procedures: http://www.sfdhr.org/index.aspx?page=20
Copies of Application Documents: http://www.sfdhr.org/index.aspx?page=20#copies Right to Work: http://www.sfdhr.org/index.aspx?page=20#identification. All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.
Exam Type: Combined Promotive and Entrance
Issued: March 10, 2020
Micki Callahan, Human Resources Director
Department of Human Resources
Recruitment ID: PBT-5602-097421 (01104308, 01058925, 01133443)
PUC - TDT (415) 554-1670
All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.