Utility Specialist - Risk Management & Business Analysis - Power Enterprise – SFPUC (5602) (164129) (EXEMPT)
San Francisco Public Utilities Commission · San Francisco, CA · 2 days ago
ResearchFull-time
We need to produce HTML fragment with sections: About the role? Actually the posting includes "WHO ARE WE?" description of organization, "Power Enterprise", "Role Description Project: Special Projects & Financial Feasibility", "Essential Functions", "Education", "Experience", "License And Certification", "Substitution", "Desirable Qualifications", "Verification Of Education And Experience", "Important Note", "What else should I know?" etc. We need to include sections only when posting has real specific content. We must not repeat job title as heading. We must not include Job ID etc as headings; fold minor metadata into short p or drop it. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning, duplicated lines, application instructions. So we need to strip out things like "How To Apply", "Job Analyst Information", "The City and County of San Francisco encourages..." etc. Also remove "Additional Information Regarding Employment with the City and County of San Francisco:" and its subpoints (Conviction History, Employee Benefits Overview, etc). Also remove "Verification Of Education And Experience" maybe? That's part of qualifications but it's more procedural; we need to preserve substantive information. The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." So we need to keep the content about qualifications, education, experience, desirable qualifications, etc. But we can omit procedural bits like "Verification Of Education And Experience" if it's just about process? It says "Every application is reviewed to ensure that you meet the minimum qualifications listed in the job ad." That's procedural but still substantive? Might be considered boilerplate. However we need to keep the qualifications themselves. The "Verification Of Education And Experience" section includes statements about needing to submit verification etc. That's more about application process; we can drop as it's application instructions. Similarly "Important Note" about making sure clear etc is also procedural. "What else should I know?" includes many subpoints like "Additional Information Regarding Employment..." which is boilerplate; we should drop.
Thus we keep sections: About the role? Actually we have "WHO ARE WE?" description of organization; we could make that as for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It suggests those are examples; we can use other headings if appropriate? It says use
About the organization
maybe. But the instruction says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It suggests those are examples; we can use other headings if appropriate? It says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't forbid other headings, but likely they expect those standard headings. However we can adapt: "About the role" could be the role description. "Responsibilities" could be essential functions. "Requirements" could be education/experience/license. "Qualifications" maybe desirable qualifications. "Skills" maybe not present. We'll need to decide.
We must not repeat job title as heading. The job title is not given explicitly in the snippet; maybe it's implied "Special Projects & Financial Feasibility" but not sure. We'll not add.
We need to output only HTML fragment.
Let's extract substantive content:
- About the organization: "WHO ARE WE? San Francisco Public Utilities Commission (SFPUC) Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year. 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 https://www.sfpuc.gov . 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. To learn more about working at the SFPUC, visit our career site at https://www.sfpuc.gov/about-us/careers-sfpuc Power Enterprise The Power Enterprise, within the SFPUC, has two separate power programs, Hetch Hetchy Power, San Francisco’s Publicly Owned Utility serving 150 MW of retail load, and CleanPowerSF, San Francisco’s Community Choice Aggregation program, serving 500+ MW of retail load. Power Enterprise serves this load with a combination of owned and purchased resources. SFPUC owns and operates the Hetch Hetchy Water and Power Project, which includes hydro-electric power generation in Moccasin, California; solar arrays throughout San Francisco; and biogas cogeneration facilities, which together produce cost-effective energy with a zero greenhouse gas (GHG-free) emission profiles. Both of these power programs’ supply portfolios exceed State minimum renewable content. Power Enterprise provides its retail customers with distributed energy resource programs. In addition to these retail electricity service offerings, Power Enterprise is responsible for San Francisco street and pedestrian lighting."
We can keep that as About the organization (maybe "About the role"? but it's about organization). We'll use About the organization
with paragraphs.
- Role Description / Project: "Project: Special Projects & Financial Feasibility Power Enterprise is experiencing a growing number of high-impact electricity service requests from large and strategically important customers, including SFO, the Steam Loop system, Port electrification initiatives, and other major infrastructure projects. These opportunities require rigorous and defensible financial evaluation to manage capital investment, cost recovery, and long-term risk exposure. To address this surge in complex project activity and to build structured evaluation capability, this position will lead financial feasibility analysis for these large, complex electricity service requests and strategic electrification initiatives, including development of detailed business case evaluations, scenario and risk analysis, and coordination of cross-functional inputs to support executive decision-making. In addition to supporting active high-priority projects, the position will develop and document financial modeling tools and evaluation methodologies during the project term to enable transition of this capability into regular business functions."
We can put under About the role
(or Responsibilities?). Actually this is role description. We'll use About the role.
- Essential Functions: list of duties. We'll make Responsibilities
with - items.
Extract each bullet:
Lead financial feasibility evaluations for large load projects and strategic electrification initiatives, including development of comprehensive business cases and valuation analyses (NPV, IRR, payback, and cost recovery assessment).
Develop and enhance project financial models to evaluate capital investment, revenue sufficiency, rate impacts, and long-term financial exposure.
Conduct project sensitivity, scenario, and risk analyses to assess load uncertainty, market volatility, regulatory changes, and potential stranded asset risk.
Collaborate with cross-functional teams (Customer Engagement, Engineering, Retail Services, Reg/Leg, and Finance) to gather inputs, validate assumptions, and ensure analytical consistency.
Improve model structure and functionality by incorporating validation checks, documentation, and version control practices to enhance reliability and transparency.
Develop and document consistent project evaluation methodologies, including cost estimation, forecasting approaches, discounting assumptions, and performance metrics.
Prepare clear, concise executive-level reports, presentations, and decision memoranda summarizing findings, risks, trade-offs, and recommendations.
Organize and maintain centralized records of assumptions, models, and historical analyses to support transparency, continuity, and audit readiness.
Provide training and structured knowledge transfer to internal staff and support implementation of documented processes to enable transition of analytical capability into regular business functions.
Perform other related duties.
We'll keep all.
- Education: "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;"
We'll put under
Education
as .
- Experience: "Four 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/infrastructure 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/clean water 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."
We'll put under
Experience
as maybe with list? It's a long sentence; we can keep as paragraph.
- License And Certification: "Specified positions may require possession of a valid California Class C driver's license."
We'll put under
License
maybe.
- Substitution: "Additional qualifying experience may be substituted for the degree requirement on a year-for-year basis. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted."
We could include under Experience or a separate Substitution heading. Might be considered part of qualifications. We'll include under Qualifications
maybe.
- Desirable Qualifications: list bullet points.
We'll put under Desirable Qualifications
with .
Now we need to ensure we don't include sections with filler like "commensurate with experience". Not present.
We must not include Pay, Schedule, Benefits sections because not stated.
We must not include repeated lines like "To learn more about our organization, please visit our website at https://www.sfpuc.gov ." That's okay.
We must not include application instructions like "How To Apply", "Job Analyst Information", etc.
We must not include EEO boilerplate.
Now produce HTML.
Structure:
About the organization
... (the WHO ARE WE paragraph plus Power Enterprise description)
About the role
... (Project description)
Responsibilities
- ... each bullet
Education
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;
Experience
Four 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/infrastructure 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/clean water 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.
License
Specified positions may require possession of a valid California Class C driver's license.
Substitution
Additional qualifying experience may be substituted for the degree requirement on a year-for-year basis. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
Desirable Qualifications
- Experience conducting complex financial feasibility, business case, and risk analyses for utility, energy, infrastructure, or other capital-intensive projects.
- Advanced financial modeling skills, including NPV, IRR, cost recovery, sensitivity, and scenario analysis.
- Knowledge of electric utility economics, rate design, power supply, and relevant energy market and regulatory frameworks.
- Strong analytical and problem-solving skills, including the ability to evaluate uncertainty, reconcile complex inputs, and develop well-supported recommendations.
- Strong written and verbal communication
About the organization
with paragraphs. - Role Description / Project: "Project: Special Projects & Financial Feasibility Power Enterprise is experiencing a growing number of high-impact electricity service requests from large and strategically important customers, including SFO, the Steam Loop system, Port electrification initiatives, and other major infrastructure projects. These opportunities require rigorous and defensible financial evaluation to manage capital investment, cost recovery, and long-term risk exposure. To address this surge in complex project activity and to build structured evaluation capability, this position will lead financial feasibility analysis for these large, complex electricity service requests and strategic electrification initiatives, including development of detailed business case evaluations, scenario and risk analysis, and coordination of cross-functional inputs to support executive decision-making. In addition to supporting active high-priority projects, the position will develop and document financial modeling tools and evaluation methodologies during the project term to enable transition of this capability into regular business functions." We can put underAbout the role
(or Responsibilities?). Actually this is role description. We'll use About the role. - Essential Functions: list of duties. We'll makeResponsibilities
with- items.
Extract each bullet:
Lead financial feasibility evaluations for large load projects and strategic electrification initiatives, including development of comprehensive business cases and valuation analyses (NPV, IRR, payback, and cost recovery assessment).
Develop and enhance project financial models to evaluate capital investment, revenue sufficiency, rate impacts, and long-term financial exposure.
Conduct project sensitivity, scenario, and risk analyses to assess load uncertainty, market volatility, regulatory changes, and potential stranded asset risk.
Collaborate with cross-functional teams (Customer Engagement, Engineering, Retail Services, Reg/Leg, and Finance) to gather inputs, validate assumptions, and ensure analytical consistency.
Improve model structure and functionality by incorporating validation checks, documentation, and version control practices to enhance reliability and transparency.
Develop and document consistent project evaluation methodologies, including cost estimation, forecasting approaches, discounting assumptions, and performance metrics.
Prepare clear, concise executive-level reports, presentations, and decision memoranda summarizing findings, risks, trade-offs, and recommendations.
Organize and maintain centralized records of assumptions, models, and historical analyses to support transparency, continuity, and audit readiness.
Provide training and structured knowledge transfer to internal staff and support implementation of documented processes to enable transition of analytical capability into regular business functions.
Perform other related duties.
We'll keep all.
- Education: "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;"
We'll put under
Education
as. - Experience: "Four 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/infrastructure 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/clean water 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." We'll put under
Experience
asmaybe with list? It's a long sentence; we can keep as paragraph. - License And Certification: "Specified positions may require possession of a valid California Class C driver's license." We'll put under
License
maybe. - Substitution: "Additional qualifying experience may be substituted for the degree requirement on a year-for-year basis. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted." We could include under Experience or a separate Substitution heading. Might be considered part of qualifications. We'll include underQualifications
maybe. - Desirable Qualifications: list bullet points. We'll put underDesirable Qualifications
with- .
Now we need to ensure we don't include sections with filler like "commensurate with experience". Not present.
We must not include Pay, Schedule, Benefits sections because not stated.
We must not include repeated lines like "To learn more about our organization, please visit our website at https://www.sfpuc.gov ." That's okay.
We must not include application instructions like "How To Apply", "Job Analyst Information", etc.
We must not include EEO boilerplate.
Now produce HTML.
Structure:
- ... each bullet
- Experience conducting complex financial feasibility, business case, and risk analyses for utility, energy, infrastructure, or other capital-intensive projects.
- Advanced financial modeling skills, including NPV, IRR, cost recovery, sensitivity, and scenario analysis.
- Knowledge of electric utility economics, rate design, power supply, and relevant energy market and regulatory frameworks.
- Strong analytical and problem-solving skills, including the ability to evaluate uncertainty, reconcile complex inputs, and develop well-supported recommendations.
- Strong written and verbal communication
About the organization
... (the WHO ARE WE paragraph plus Power Enterprise description)
About the role
... (Project description)
Responsibilities
Education
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;
Experience
Four 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/infrastructure 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/clean water 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.
License
Specified positions may require possession of a valid California Class C driver's license.
Substitution
Additional qualifying experience may be substituted for the degree requirement on a year-for-year basis. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
Desirable Qualifications