Energy Commercial Structuring Analytics Associate
for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. We need to extract content from posting. Let's parse. First part: "In accordance with Washington state law, we are highlighting our comprehensive benefits package, which is available to all eligible US based employees. Benefits for this role include: Health, dental, vision, life, disability insuranceRetirement Benefits: 401(k) with company matchPaid Time Off: 20 days of vacation per year, accruing at a rate of 6.15 hours per pay period for the first five years of employmentSick Time: 40 hours/year (increased to 69 hours/year for Seattle) including 5 discretionary sick days per instance Maternity Leave (Short-Term Disability + Baby Bonding): 28-30 weeksBaby Bonding Leave: 18 weeksHolidays: 13 paid days per year Applicants in San Francisco: Qualified applications with arrest or conviction records will be considered for employment in accordance with the San Francisco Fair Chance Ordinance for Employers and the California Fair Chance Act. Note: By applying to this position you will have an opportunity to share your preferred working location from the following: San Francisco, CA, USA; Austin, TX, USA; New York, NY, USA; Kirkland, WA, USA." We need to remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The part about San Francisco Fair Chance is legal? It's about EEO? Might be considered legal boilerplate. The note about preferred working location maybe location info but not required? Might be considered metadata; we can fold minor metadata into a short
or drop it. The location list maybe not essential but could be considered part of job posting; but we can include as a short paragraph under maybe "Location" but we don't have a heading for location. We could include it in a
after benefits maybe. Then "Minimum qualifications: Bachelor's degree in a technical field, or equivalent practical experience.5 years of experience in technical program management, financial analytics, commercial structuring, or corporate strategy.Experience developing investigative frameworks, maintaining financial benchmarks, and presenting agreement approval materials to cross-functional stakeholders (e.g., Accounting, Finance)." Then "Preferred qualifications: 5 years of experience in energy project or infrastructure project financial analytics and financial structuring and strategic analysis.Experience leading, working, or supporting agreement negotiations and drafting in the infrastructure field, preferably power generation or power infrastructure.Experience with financial analysis for energy transactions, including project financial modeling across various energy agreement types ranging from utility supply to PPAs, etc.Ability to build strong relationships with both internal and with external partners.Excellent communication and influencing skills." Then "About The Job A problem isn’t truly solved until it’s solved for all. That’s why Googlers build products that help create opportunities for everyone, whether down the street or across the globe. As a Technical Program Manager at Google, you’ll use your technical expertise to lead complex, multi-disciplinary projects from start to finish. You’ll work with stakeholders to plan requirements, identify risks, manage project schedules, and communicate clearly with cross-functional partners across the company. You're equally comfortable explaining your team's analyses and recommendations to executives as you are discussing the technical tradeoffs in product development with engineers. In this role, you will support the financial analytics engine behind frameworks, partnerships, energy supply agreement, and generation strategy that underpin Google's Americas data center energy team. You will assist in financial and structuring analytics related to the negotiations and execution of energy agreement retail, wholesale, deregulated and regulated energy markets. You will track industry financial trends, maintain financial structuring benchmarks, support deal teams in financial analysis and modeling through transactions and strategic planning. As part of deal teams you will help prepare and present agreements for approval while ensuring alignment across accounting and finance partner teams." Then "Individual pay is determined by factors including job-related skills, experience, and relevant education or training. US: $163000 - $236000 (USD) + 15% bonus target + equity + benefits" Then "Responsibilities Learn more about benefits at Google . Support the commercial structuring analytics program, helping to build energy strategy. Structure and evaluate energy agreements in support of the Americas data center portfolio.Be responsible for assisting in the evaluation of transactions across partnerships, portfolio frameworks, utility energy supply, IPP energy supply, PPAs, and other types of energy agreements.Assist in maintaining up-to-date benchmarks for industry standard financial metrics, project capex/opex benchmarks, etc.Play a role in transactions, helping to shape deal teams' approach to negotiations and structured solutions.Prepare and present agreement approval materials and work with cross-functional partners in Accounting, Finance, etc to align on a common set of agreement analytics and metrics. Help develop a standard set of modeling tools and focus on automation over repetitive, manual work." Then EEO boilerplate etc to be removed. Thus we need sections: - About the role (or About The Job) -> we have a paragraph describing role. Use
About the role
thenwith that content. - Responsibilities -> we have list of duties. Use
Responsibilities
then- items.
- Minimum qualifications -> could be under Requirements or Qualifications. The instruction: use headings like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we can put minimum qualifications under Requirements or Qualifications. Probably Requirements for minimum qualifications, Qualifications for preferred qualifications. Or combine. We'll decide: Requirements heading for minimum qualifications; Qualifications heading for preferred qualifications.
- Skills: maybe we have "Ability to build strong relationships... Excellent communication and influencing skills." That's under preferred qualifications but could be skills. Could put under Skills.
- Benefits: we have benefits list.
- Pay: we have salary range and bonus etc.
- Schedule: not mentioned; we should not create Schedule section.
We must not include filler like "commensurate with experience". Not present.
We must preserve all substantive info.
Let's extract benefits text: "Health, dental, vision, life, disability insuranceRetirement Benefits: 401(k) with company matchPaid Time Off: 20 days of vacation per year, accruing at a rate of 6.15 hours per pay period for the first five years of employmentSick Time: 40 hours/year (increased to 69 hours/year for Seattle) including 5 discretionary sick days per instance Maternity Leave (Short-Term Disability + Baby Bonding): 28-30 weeksBaby Bonding Leave: 18 weeksHolidays: 13 paid days per year"
We need to format nicely maybe as list items.
We'll split into items:
- Health, dental, vision, life, disability insurance
- Retirement Benefits: 401(k) with company match
- Paid Time Off: 20 days of vacation per year, accruing at a rate of 6.15 hours per pay period for the first five years of employment
- Sick Time: 40 hours/year (increased to 69 hours/year for Seattle) including 5 discretionary sick days per instance
- Maternity Leave (Short-Term Disability + Baby Bonding): 28-30 weeks
- Baby Bonding Leave: 18 weeks
- Holidays: 13 paid days per year
We could also note location note but maybe drop as minor metadata. Could include a short paragraph after benefits: "Preferred work locations: San Francisco, CA; Austin, TX; New York, NY; Kirkland, WA." But that's location info; not required but could be considered minor metadata. The instruction: "do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short
or drop it." Location could be considered minor metadata; we can include a short p. Now responsibilities list: Let's extract bullet points. Responsibilities paragraph: "Support the commercial structuring analytics program, helping to build energy strategy. Structure and evaluate energy agreements in support of the Americas data center portfolio.Be responsible for assisting in the evaluation of transactions across partnerships, portfolio frameworks, utility energy supply, IPP energy supply, PPAs, and other types of energy agreements.Assist in maintaining up-to-date benchmarks for industry standard financial metrics, project capex/opex benchmarks, etc.Play a role in transactions, helping to shape deal teams' approach to negotiations and structured solutions.Prepare and present agreement approval materials and work with cross-functional partners in Accounting, Finance, etc to align on a common set of agreement analytics and metrics. Help develop a standard set of modeling tools and focus on automation over repetitive, manual work." We need to split into sensible items. Could be each sentence. - Support the commercial structuring analytics program, helping to build energy strategy. - Structure and evaluate energy agreements in support of the Americas data center portfolio. - Be responsible for assisting in the evaluation of transactions across partnerships, portfolio frameworks, utility energy supply, IPP energy supply, PPAs, and other types of energy agreements. - Assist in maintaining up-to-date benchmarks for industry standard financial metrics, project capex/opex benchmarks, etc. - Play a role in transactions, helping to shape deal teams' approach to negotiations and structured solutions. - Prepare and present agreement approval materials and work with cross-functional partners in Accounting, Finance, etc to align on a common set of agreement analytics and metrics. - Help develop a standard set of modeling tools and focus on automation over repetitive, manual work. Now minimum qualifications: "Bachelor's degree in a technical field, or equivalent practical experience.5 years of experience in technical program management, financial analytics, commercial structuring, or corporate strategy.Experience developing investigative frameworks, maintaining financial benchmarks, and presenting agreement approval materials to cross-functional stakeholders (e.g., Accounting, Finance)." We need to split: maybe three items. - Bachelor's degree in a technical field, or equivalent practical experience. - 5 years of experience in technical program management, financial analytics, commercial structuring, or corporate strategy. - Experience developing investigative frameworks, maintaining financial benchmarks, and presenting agreement approval materials to cross-functional stakeholders (e.g., Accounting, Finance). Preferred qualifications: list. - 5 years of experience in energy project or infrastructure project financial analytics and financial structuring and strategic analysis. - Experience leading, working, or supporting agreement negotiations and drafting in the infrastructure field, preferably power generation or power infrastructure. - Experience with financial analysis for energy transactions, including project financial modeling across various energy agreement types ranging from utility supply to PPAs, etc. - Ability to build strong relationships with both internal and with external partners. - Excellent communication and influencing skills. Skills: maybe we could put the ability and communication under Skills heading. But we already have them under Preferred qualifications. Could also have Skills separate. But we need to avoid duplication. The instruction: "Prefer a few substantive sections over many thin ones." So maybe combine Preferred qualifications and Skills into one Qualifications section? But we have headings for Qualifications and Skills separate. Could put preferred qualifications under Qualifications, and skills under Skills (ability to build relationships, communication). However the preferred qualifications already include ability and communication; we could move those to Skills and keep rest under Qualifications. Let's do that. Thus: Qualifications (preferred qualifications except skills): items 1-4 (excluding ability and communication). Skills: ability to build strong relationships..., excellent communication and influencing skills. Now Pay: "Individual pay is determined by factors including job-related skills, experience, and relevant education or training. US: $163000 - $236000 (USD) + 15% bonus target + equity + benefits" We need to output as
Pay
thenwith that sentence. Now Benefits:
Benefits
then- items.
Now About the role:
About the role
thenwith the paragraph. Now Responsibilities: as above. Now
- items.
Now About the role: