Energy Data Strategist: ISO Settlements & Analytics

TotalEnergies Group; United States; Vor Ort; USD 90.000 - 130.000; Vollzeit

Zusammenfassung

TotalEnergies is seeking an Energy Data Portfolio Analyst to join the EDM team in the U.S. The role focuses on accurate settlement, volumetric, and financial data across power and gas portfolios, with emphasis on data governance, automation, and cross-team collaboration.

You will design and maintain data workflows using SQL, Alteryx, Python, and Power BI, support ISO settlements, and provide reporting to Front, Middle, Back Office, and Finance to enable transparent decision-making.

Qualifikationen

• 2–3 years of experience in North American power and gas markets.
• Solid understanding of ISO settlements and imbalance mechanisms.
• Experience with ETRM systems and settlement data platforms.
• Strong analytic and modeling skills using SQL, Python, Alteryx, and Power BI.
• Ability to translate contracts into operational and system requirements.

Aufgaben

• Ingest, validate, reconcile and book data across ERCOT, CAISO, PJM, and gas portfolios.
• End-to-end settlement of physical and financial transactions.
• Support shale netback processes including monthly settlements and accrual analysis.
• Translate ISO market constructs into structured workflows and settlement models.
• Investigate data discrepancies and coordinate with ISOs, producers, and internal teams.
• Develop automated workflows with SQL, Alteryx, Python, and Power Automate.
• Build centralized data repos and Power BI reporting for imbalance analytics.
• Support system onboarding and integration, including testing and readiness assessments.
• Support QSE reporting for solar and storage asset settlements.
• Manage renewable portfolio data integrity and ISO settlement constructs.
• Analyze DAM vs RT exposure and imbalance drivers.
• Ensure data integrity across expanding portfolios.
• Monitor ISO rule changes and regulatory developments.
• Support retail billing automation and scalable settlement architecture.
• Produce operational, commercial, regulatory reporting.
• Contribute to continuous improvement of data governance.

Kenntnisse

ETRM systems

ISO settlements

Power BI

SQL

Python

Alteryx

Data governance

Financial reconciliation

Analytics

Cross-functional

Tools

Alteryx

Python

SQL

Power BI

Jobbeschreibung

TotalEnergies is seeking an Energy Data Portfolio Analyst to join the EDM team in the U.S. The role focuses on accurate settlement, volumetric, and financial data across power and gas portfolios, with emphasis on data governance, automation, and cross-team collaboration.

You will design and maintain data workflows using SQL, Alteryx, Python, and Power BI, support ISO settlements, and provide reporting to Front, Middle, Back Office, and Finance to enable transparent decision-making.