Analyst - Energy Markets

Responsibilities

• Data Pipeline Management: Assist in the extraction and cleaning of large structured and unstructured datasets from CAISO OASIS, CAISO/WECC reports, and FERC Electronic Quarterly Reports.
• Market Monitoring: Track and report on Locational Marginal Prices (LMP), transmission congestion, and curtailment trends across the west.
• Dashboard Development: Create and maintain automated Power BI or Tableau dashboards that visualize key client metrics such as congestion, renewable curtailment, renewable penetration, and generator availability.
• Regulatory Analysis: Monitor and summarize stakeholder proceedings from the California Public Utilities Commission (CPUC), CAISO, and FERC that impact Western wholesale market design.
• Ad-Hoc Market Forensics: Conduct "post-mortem" analyses on high-price events, grid stress days, adverse market settlement outcomes, to identify the root causes in support of client management strategic decision making.

Requirements

• Education: Bachelor's degree in Economics, Engineering, Mathematics, Data Science, or a related field.
• Experience: 1+ years of experience in the energy industry (consulting, utility, or regulatory agency).
• Energy Market Fundamentals: A foundational understanding of how wholesale electricity is bought and sold (Day-Ahead vs. Real-Time markets).
• Western Interconnection Familiarity: Familiarity with the geography of the West, the unique role/impact of hydroelectric power and solar curtailment in the region, and the on-going development of energy markets.
• Skills: SQL: Ability to write queries to pull data from relational databases. Data Visualization: Proficiency in Tableau or Power BI to build interactive reports. Excel: Advanced skills (Pivot Tables, Power Query, VBA) for quick "back-of-the-envelope" modeling. Scripting: Basic knowledge of Python (Pandas/NumPy) or R for automating repetitive data tasks. High degree of organizational aptitude: The ability to manage multiple projects, tasks, and clients simultaneously.

Qualifications

• Work Authorization: Citizens or Permanent Residents of USA. Cannot provide Visa sponsorship.
• Salary Range: $67,800 - $90,000 (annualized USD).
• Job Benefits: Flex Benefits (Flexible Hours, Telecommuting), Competitive Pay, Health Benefits (Medical, Dental & Vision, Company Paid Life, Long Term & Short-Term Disability), Paid Time Off (Vacation, Sick, Floating Holiday, Holidays), 401(k), Employee Assistance Program (EAP), Tuition Reimbursement.