Structured Power Back Office Analyst

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

Job summary

TotalEnergies recherche un professionnel pour le Back Office énergie à Houston, responsable des confirmations, factures et paiements, et de la saisie des deals dans les systèmes Power/REC/HRCO. Vous travaillerez en lien avec les équipes Trading et Compliance.

Le candidat idéal possède une forte compétence en SQL, Python et Excel, avec expérience Power BI et automatisation (Alteryx/VBA), et une connaissance du marché NA power.

Qualifications

• Diplôme de premier cycle en comptabilité, finance, mathématiques, énergie ou domaine lié aux affaires.

Responsibilities

• Point de contact principal pour le Power Trading Desk et l'équipe Energy Data Management, répondre aux demandes opérationnelles et de facturation.

Skills

SQL

Python

Excel

Power BI

Alteryx

VBA

Data analysis

Education

Licence Bachelor ou équivalent en comptabilité/finance/maths/énergie/affaires

Tools

Simba

ICE Trade Vault

Contract Management systems

Simba SMS

Job description

Contexte et environnement

This role operates in a fast‑paced trading environment where the jobholder must be able to work both independently and as part of a team. Maintaining strong communication with internal departments and external counterparts while meeting industry and contractual deadlines is crucial. Reconciling discrepancies and resolving counterparty issues requires proactively seeking the information needed to solve problems effectively. In addition, reporting and monitoring obligations under the Dodd‑Frank Act, the Sarbanes‑Oxley Act, and other regulatory requirements demand a high level of diligence and attention to detail.

Activités

The role requires accurate and timely processing of confirmations, invoices, and payments in accordance with legal agreements, as well as ensuring all Power and REC deal entries in the trading book are correct and verified against exchange data. It involves performing daily checks on open positions and transactions across brokers, exchanges, and clearers, with the ability to identify errors during trade verification and perform manual calculations when necessary. Strong communication with both internal teams and external counterparties is essential to support smooth operations and resolve issues efficiently.

• The Back Office processes approximately 250,000 confirmations and 35,000 invoices and payments each year.
• Trading Division counterparties include upstream and downstream affiliates as well as major energy companies across Europe, the U.S., the Middle East, and Asia, along with clearing houses representing more than 12.9 billion USD in turnover.
• Work within Back‑Office operations in Houston, supporting both TGPNA and TGPL activities.
• Operate across U.S. power markets—wholesale and retail—including ERCOT, PJM, CAISO, MISO, SPP, Renewable Energy Certificates, and HRCO activities.
• Provide support and testing for ongoing system developments and assist with onboarding new systems, processes, and products.
• Participate in regular internal and external audits and meet all regulatory obligations.

Financial

• The Back Office processes approximately 250,000 confirmations and 35,000 invoices and payments each year.
• Trading Division counterparties include upstream and downstream affiliates as well as major energy companies across Europe, the U.S., the Middle East, and Asia, along with clearing houses representing more than 12.9 billion USD in turnover.

Non‑Financial

• Work within Back‑Office operations in Houston, supporting both TGPNA and TGPL activities.
• Operate across U.S. power markets—wholesale and retail—including ERCOT, PJM, CAISO, MISO, SPP, Renewable Energy Certificates, and HRCO activities.
• Provide support and testing for ongoing system developments and assist with onboarding new systems, processes, and products.
• Participate in regular internal and external audits and meet all regulatory obligations.

Key Responsibilities

• Serve as the primary point of contact for the Power Trading Desk and Energy Data Management team, addressing operational and invoicing inquiries.
• Perform daily, weekly, and monthly power reconciliations using advanced SQL, Python, and data‑transformation techniques.
• Build, maintain, and automate reconciliation workflows and reporting tools using Excel (advanced formulas, VBA), Power BI, and Python.
• Produce all required reports and statements supporting physical power activities across ERCOT, PJM, CAISO, and SPP in both wholesale and retail markets.
• Manage a portfolio of Power, REC, and HRCO trading counterparties and ensure accurate deal capture in the BOOK, PowerOptix, and ISO systems.
• Confirm trades daily with brokers and counterparties, validate trader deal sheets, and ensure timely Dodd‑Frank reporting for financial Power and REC OTC trades via ICE Trade Vault.
• Issue invoices within contractual and industry deadlines, reconcile counterparty invoices, and resolve pricing or volume discrepancies with Front and Middle Office.
• Coordinate settlements, provide payment instructions and cash‑flow forecasts to Treasury, and support Accounting with aged‑debt resolution and accrual analysis.
• Apply payment terms and netting rules in Simba and Contract Management systems and prepare settlement statements in Simba SMS.
• Review, distribute, and track all Power/REC/Swap/HRCO confirmations, ensuring timely follow‑up on outstanding items.
• Support onboarding of new counterparties and perform detailed contract reviews for Power, HRCO, and REC agreements.
• Assist internal teams and external partners with Back Office inquiries and participate in projects assigned by the Back Office Manager or Supervisor.
• Mentor junior team members, run management reports, and perform ad‑hoc analyses.
• Identify process and system improvements, support testing and implementation, and communicate operational risks with recommended mitigation measures.
• Conduct revenue and cost variance analyses to identify trends, billing discrepancies, forecast issues, and transaction anomalies.
• Generate monthly gross‑margin estimates and reconcile them against actuals through initial, final, and true‑up settlement cycles.
• Reconcile Virtual Power Purchase Agreement (VPPA) swaps and ensure Dodd‑Frank compliance.
• Monitor Renewable Energy Certificates (RECs) from confirmation through settlement across all North American markets.
• Process daily and monthly reconciliations for Battery Energy Storage System (BESS) activity in ERCOT and ensure timely actualizations for invoicing.

Profil du candidat

• Undergraduate degree in Accounting, Finance, Mathematics, Energy, or a business‑related field.
• Three to five years of experience in the power markets—both wholesale and retail—with a strong emphasis on data analysis.
• Experience with Power BI and automation tools such as Alteryx or similar platforms.
• Experience working with large structured datasets and developing scalable data models.
• Advanced programming and data‑engineering skills, including:
• SQL: complex queries, stored procedures, data modeling
• Python: data manipulation, automation, analytics
• Excel: expert‑level skills including VBA macros, Power Query, and advanced modeling
• Strong understanding of the North American power industry.
• Required knowledge of energy‑commodity markets.
• Ability to work under pressure with strong attention to detail, adaptability, and a focus on innovation and change management.
• Effective communication skills and a customer‑service mindset.
• Strong drive to improve processes and systems, supported by excellent IT skills (Excel, VBA, Power BI, Alteryx). The role may require developing new tools to secure and optimize processes and creating new reports to support evolving business needs.

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 Gas and Power (TGP)

is the trading arm of TotalEnergies in the field of low carbon energies (mainly gas, LNG and power). As such it operates in fast‑evolving market dynamics influenced by internal and external factors that require constant adaptation and evolution. Uncertainties specific to the trading environment (volatility of prices, supply & demand mismatches) are coupled with those coming from the broader energy sector (climate change policies, changes in the energy mix, developments of new energy sources, etc). In such context TGP helps to ensure growth and profitability to a key segment of the business in order to reach the objective of Carbon Neutrality by 2050.

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.

Informations supplémentaires

TotalEnergies valorise la diversité, promeut le développement individuel et offre des opportunités d'emploi égales à tous les candidats.