Full Time Data Analyst R Programming Jobs in Sacramento, CA

GDS Associates, Inc. has an exciting and challenging full-time opportunity with advancement and growth potential for an Energy Markets Analyst to work in our Planning & Advisory group. The analyst position will work in direct support of GDS' expanding Western Markets consulting team, offering the opportunity to shape the future of the energy transition.

The successful candidate will be responsible for transforming complex grid and market data into actionable insights that drive our technical advisement to clients across the Western Interconnection. Your work will directly support decision-making in CAISO, WECC, and emerging regional markets (like Markets+ or EDAM).

GDS is a nationwide multi-service engineering and consulting firm specializing in the energy utilities industry. We have a significant and growing practice in the power supply planning area representing electric utility and renewable/battery developer clients in the procurement, planning, and effective management of power supply resources in structured and unstructured markets across the U.S.

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.
  

• 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 plus: A foundational understanding of how wholesale electricity is bought and sold (Day-Ahead vs. Real-Time markets).
• Western Interconnection Familiarity a plus: 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.
  

GDS is an Equal Opportunity Employer. Please note that this position is not available for visa sponsorship.
Work Authorization: Citizens or Permanent Residents of USA. Cannot provide Visa sponsorship.
Salary is determined by various factors, including but not limited to location, the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements. The projected compensation range for this position is $67,800 - $90,000 (annualized USD). The typical salary range for this position is just one component of the firm's total compensation package.

GDS Associates, Inc. offers excellent benefits package to include:

• 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