Energy Data Portfolio Analyst

TotalEnergies; Houston (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

TotalEnergies Trading & Shipping recherche un Analyste EDM pour assurer l’intégrité et la qualité des données de portefeuille, et soutenir le reporting et les clôtures. Vous collaborerez avec les équipes Front/Middle/Back Office et IT dans un environnement multi‑marchés et ISO, en veillant à la fiabilité des systèmes ETRM et des plateformes associées.

Le profil idéal dispose d’une formation en ingénierie/finance, d’une expérience en marchés nord‑américains, et de compétences en SQL, Python,

Qualifications

• Formation en ingénierie, mathématiques, finance ou énergie
• 2–3 ans d’expérience sur les marchés nord‑américains énergie (électricité/gaz)
• Connaissance des mécanismes ISO et enjeux financiers
• Expérience ETRM et plateformes de données de règlement
• Compétences en SQL, Python, Alteryx et Power BI pour modéliser et automatiser les flux
• Capacité à interpréter les termes contractuels et à les traduire en exigences opérationnelles
• Expérience de travail en collaboration avec Front/Middle/Back Office et IT
• Aptitude à résoudre des problèmes et à analyser les causes profondes des écarts de P&L
• Autonomie et organisation dans un environnement rapide et multi‑marchés
• Esprit d’équipe et capacité à travailler avec des parties prenantes internes et externes

Responsibilities

• Gérer l’ingestion, la validation et l’allocation des données de portefeuille sur ERCOT, CAISO, PJM et portefeuilles gaz physiques.
• Réaliser l’actualisation et la reconciliation des transactions physiques et financières avant règlement financier.
• Soutenir les processus de netback et les settlements mensuels, ajustements et analyses de coût.
• Traduire les concepts ISO (imbalance, services auxiliaires, congestion, RUC) en workflows et modèles de règlement.
• Résoudre les écarts de données et coordonner avec les ISO, producteurs, gatherers et équipes internes.
• Développer des workflows automatisés (SQL, Alteryx, Python, Power Automate).
• Concevoir et maintenir des dépôts de données et des rapports Power BI pour l’analyse d’imblance et la transparence commerciale.
• Participer à l’onboarding système et tests d’intégration.
• Soutenir les rapports QSE et le règlement pour les actifs solaires/batterie à grande échelle.
• Gérer l’évolution du portefeuille renouvelable dans ETRM et les règles d’intégration batterie.
• Analyser DAM vs Real‑Time, drivers d’imblance et impacts sur la performance.
• Assurer l’intégrité des données lors de l’ajout de nouveaux actifs et des évolutions ISO.
• Surveiller les évolutions des règles ISO et des exigences contractuelles.
• Contribuer à l’automatisation de la facturation de détail et à l’architecture de règlement.
• Produire des rapports opérationnels, commerciaux et réglementaires pour la transparence.

Skills

SQL

Python

Power BI

Alteryx

Analyse

Connaissance marchés nord‑américains

Education

Bachelor / équivalent en ingénierie, mathématiques, finance ou énergie

Tools

ETRM

ETRM systems

Job description

Contexte et environnement A fast‑paced trading environment requires the jobholder to work both autonomously and collaboratively to deliver quick, high‑quality results. The role operates within a rapidly evolving energy market shaped by environmental and regulatory changes, demanding adaptability and strong analytical judgment. Because many systems are developed in‑house, the position requires close coordination with other departments and IT teams to implement updates and improvements. Clear and concise communication with internal and external stakeholders is essential, particularly when conveying market data and its implications for contractual obligations.

Activités The Energy Data Management (EDM) team serves as the centralized control function for portfolio data integrity across power and natural gas markets. The team consolidates, validates, and operationalizes volumetric, contractual, and market data across renewable generation (solar and battery storage), large commercial and industrial portfolios, retail activity, and shale netback operations.

Contexte et environnement A fast‑paced trading environment requires the jobholder to work both autonomously and collaboratively to deliver quick, high‑quality results. The role operates within a rapidly evolving energy market shaped by environmental and regulatory changes, demanding adaptability and strong analytical judgment. Because many systems are developed in‑house, the position requires close coordination with other departments and IT teams to implement updates and improvements. Clear and concise communication with internal and external stakeholders is essential, particularly when conveying market data and its implications for contractual obligations. Activités The Energy Data Management (EDM) team serves as the centralized control function for portfolio data integrity across power and natural gas markets. The team consolidates, validates, and operationalizes volumetric, contractual, and market data across renewable generation (solar and battery storage), large commercial and industrial portfolios, retail activity, and shale netback operations. EDM ensures accurate and controlled representation of physical activity within the ETRM system and related data platforms. This oversight protects financial accuracy and maintains operational transparency ahead of settlement and invoicing cycles. The team operates in a multi‑system environment and supports asset onboarding into balancing perimeters, ongoing ISO data reconciliation, and continuous validation of interval‑level and contractual data across multiple markets. EDM also enables scalable data governance, automation‑driven workflows, and structured reporting frameworks used by Front Office, Middle Office, Back Office, Finance, Trading Systems, and external stakeholders. Key Responsibilities:

• Manage the timely ingestion, validation, reconciliation, and booking of allocation, settlement, meter, price, billing determinant, and contract data across ERCOT, CAISO, PJM, and physical gas portfolios. Ensure accurate and controlled representation of all activity within the ETRM system and related data platforms.
• Perform end‑to‑end actualization of physical and financial transactions, including ISO settlements, producer/gatherer/pipeline statements, group‑affiliated contracts, renewable volumes, and retail activity prior to financial settlement.
• Support shale netback processes by completing monthly settlements, prior‑period adjustments, accrual analysis, cost validation, and contract structure maintenance. Ensure alignment between commercial agreements and operational models.
• Translate ISO market constructs—such as imbalance mechanisms, ancillary services, congestion, RUC, resettlements, DAM/RT adjustments, and three‑part offers—into structured workflows, data logic, and settlement models.
• Investigate and resolve data discrepancies, quantity mismatches, and pricing variances across ISO statements, counterparty invoices, and internal reports. Coordinate with ISOs, producers, gatherers, pipelines, and internal Front, Middle, and Back Office teams.
• Develop and maintain automated workflows using SQL, Alteryx, Python, and Power Automate to streamline data ingestion, reconciliation, booking, and control validation.
• Build and support centralized data repositories and Power BI reporting solutions to deliver imbalance analytics, performance monitoring, and commercial transparency.
• Support system onboarding and integration efforts, including testing, validation, workflow design, and operational readiness assessments.
• Support QSE reporting and settlement processes for utility‑scale solar and battery storage assets, including interval‑level data validation, imbalance tracking, ancillary services analysis, and multi‑cycle settlement reconciliation.
• Manage increasing renewable portfolio complexity by ensuring accurate operational and financial representation of generation, charging and discharging activity, and ISO settlement constructs within ETRM and reporting systems.
• Analyze DAM versus Real‑Time exposure, imbalance drivers, and performance impacts for renewable and thermal assets. Contribute to commercial transparency and contract back‑testing.
• Ensure data integrity across expanding portfolios, including new asset onboarding, scalable settlement processes, and evolving ISO battery integration rules.
• Monitor ISO rule changes, market design updates, and contractual developments. Assess operational and system impacts to maintain compliance and scalability.
• Support retail billing automation and scalable settlement architecture using SQL, automation frameworks, and AI‑enabled validation tools.
• Produce operational, commercial, regulatory, and counterparty reporting to support transparency and informed decision‑making.
• Contribute to continuous improvement of control frameworks, documentation standards, and data governance practices across energy data workflows.

Accountabilities: The Energy Data Portfolio Analyst is responsible for ensuring the accuracy, completeness, and integrity of settlement, volumetric, and financial data across assigned portfolios. The role ensures that physical and financial positions are correctly represented within trading and reporting systems, and that reconciliations are completed in a timely and controlled manner. The Analyst identifies, investigates, and resolves discrepancies that may affect P&L, invoicing, or operational transparency, while maintaining close coordination with Front Office, Middle Office, Back Office, Finance, and Trading Systems. The position also includes responsibility for implementing structured controls, improving data processes, and supporting system alignment to maintain reliable and scalable data governance.

Profil du candidat

• Undergraduate degree (or equivalent) in Engineering, Mathematics, Finance, or Energy.
• 2–3 years of experience in North American power and/or gas markets, with demonstrated exposure to ISO settlements, contract actualization, and financial reconciliation processes.
• Strong understanding of ISO market constructs—including imbalance mechanisms, ancillary services, congestion, RUC, and resettlements—and their financial implications.
• Experience working with ETRM systems and settlement data platforms in a trading or energy‑portfolio environment.
• Strong analytical and modeling skills, with hands‑on experience in Alteryx, Python, SQL, and Power BI or comparable tools.
• Ability to interpret contractual terms and translate them into operational and system requirements.
• Proven experience collaborating cross‑functionally with Front Office, Middle Office, Back Office, Finance, and IT teams.
• Strong problem‑solving and root‑cause analysis capabilities, particularly in financial reconciliation and P&L investigations.
• Ability to operate independently in a fast‑paced, multi‑market trading environment while maintaining strong attention to detail and organizational discipline.
• A collaborative team player who works effectively with internal teams, partners, and external stakeholders.
• Ability to work autonomously while staying well‑organized.

What We Offer At TotalEnergies we know that you're more than what's on your CV. TotalEnergies is a multi-energy company that produces and markets energies on a global scale: oil and biofuels, natural gas and green gases, renewables and electricity. Our 105,000 employees are committed to energy that is ever more affordable, clean, reliable and accessible to as many people as possible. Active in more than 130 countries, TotalEnergies puts sustainable development in all its dimensions at the heart of its projects and operations to contribute to the well‑being of people.

About the company: TotalEnergies is a multi-energy company that produces and markets energies on a global scale: oil and biofuels, natural gas and green gases, renewables and electricity. Our 105,000 employees are committed to energy that is ever more affordable, clean, reliable and accessible to as many people as possible. Active in more than 130 countries, TotalEnergies puts sustainable development in all its dimensions at the heart of its projects and operations to contribute to the well‑being of people.

TotalEnergies Trading & Shipping (T&S), an international trading company, puts its expertise to use in the global energy markets. With its biomass blending and trading activity, TotalEnergies T&S is an active participant in the development of sustainable biofuels. Our maritime transport expertise also helps to reduce the carbon footprint of sea transportation and we recently announced the time chartering of new vessels equipped with LNG propulsion.

Our Culture: We are committed to meet the energy needs of a growing population while fulfilling our ambition to be a major player in the energy transition. The volatility of the energy trading markets requires excellence in risk management and a culture of innovation. Our people flourish in an environment that promotes expertise, entrepreneurship spirit, agility and a purpose‑driven culture, generating boundless opportunities to learn, grow and achieve collaborative success while ensuring safety in all our operations. We look for passion, ambition and open‑mindedness. While we evolve in a demanding and ever‑changing industry, we cultivate a friendly workplace where team spirit and respect guide our daily routine, and where the diversity of our people and their skills create a nourishing experience for all of us. Please note: TotalEnergies is unable to sponsor employment visas or consider candidates on time‑limited visa status for this position.