Senior Energy Trading Data & Analytics Analyst

AES Corporation; Houston (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

AES Clean Energy Services LLC in Houston seeks a Senior Analyst for Commercial Operations to lead data-driven energy trading activities and analytics. You will model ISO settlements, implement PPA/contract setups, and drive data flows across ETRM, Bid-to-Bill, and portfolio optimization platforms.

You will utilize SQL, Python and Power BI to transform business requirements into scalable analytics, collaborating with trading desks, operations, and IT teams to ensure data quality and actionable

Qualifications

• Bachelor degree or foreign equivalent degree in Energy sciences, engineering, mathematics or related field and 3 years of data integration experience OR
• Master's degree or foreign equivalent degree in Energy sciences, engineering, mathematics or related field and 1 year of data integration experience.
• Knowledge of U.S. power systems and organized power markets (CAISO, ERCOT, PJM, NYISO, NEISO, MISO).
• Experience with data integration, analytics and ETRM concepts (Energy Trading and Risk Management).
• Strong SQL, Python, data visualization and data quality control skills.

Responsibilities

• Lead Allegro modeling to ensure accurate ISO settlements and setup PPA/contract in Adapt2 and PCI & ETRM systems.
• Oversee the full trade lifecycle from sourcing inputs to trade mapping and position details.
• Support integration of realized data for AES Clean Energy assets into ETRM and Bid-to-Bill systems.
• Transform commercial requirements into ETRM solutions using SQL, Python, PowerBI, Excel and related tools.
• Build and lead VM dashboard analytics to track plant performance and portfolio optimization.
• Design dashboards and views for asset-specific insights guiding trading strategies.
• Collaborate with Digital, Operations, S2G and settlements to support VM GCP database.
• Ensure data quality through automated monitoring and data integrity protocols.
• Maintain data flows across trading, settlements, scheduling and market operations.
• Develop scalable data transformation solutions compatible with ETRM systems.

Skills

Advanced SQL (T-SQL)

Python programming

Data visualization tools

Data analysis

Data integrity principles

Education

Bachelor or Master in Energy sciences, engineering, mathematics or related field

Tools

SQL Server

Google Cloud Platform

Microsoft Cloud environments

Job description

AES Clean Energy Services LLC in Houston seeks a Senior Analyst for Commercial Operations to lead data-driven energy trading activities and analytics. You will model ISO settlements, implement PPA/contract setups, and drive data flows across ETRM, Bid-to-Bill, and portfolio optimization platforms.

You will utilize SQL, Python and Power BI to transform business requirements into scalable analytics, collaborating with trading desks, operations, and IT teams to ensure data quality and actionable