Energy Data Portfolio Analyst

Full-time

Total Energies

Context & Environment
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.
Activities
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.
Candidate Profile
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.
Additional Information
TotalEnergies values diversity, promotes individual growth and offers equal opportunity careers.
Apply

Facebook

Email

X

LinkedIn

<
What We Offer
At TotalEnergies we know that you're more than what's on your CV. If this opportunity excites you, but your profile doesn't exactly match the description above...give it a try & apply. Diversity of perspectives & experiences make us stronger.
TotalEnergies celebrates diversity and is committed to Equal Employment Opportunity:
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, protected veteran status, disability status or any other category protected under applicable federal, state or local law. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures.
All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs.
TotalEnergies believes that diversity and inclusion among our teammates is critical to our success as a global company, and we seek to recruit, develop, and retain the most talented people from a diverse candidate pool.
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.
Please note: TotalEnergies is unable to sponsor employment visas or consider candidates on time-limited visa status for this position.
Ready to Power the Future of Energy Trading?
Apply now and be part of a team that's shaping the future of low-carbon energy.

Apply

Vacancy posted more than 2 months ago

Similar jobs that could be interesting for youBased on the Energy Data Portfolio Analyst in Washington DC vacancy

Data Manager/Analyst, US State Dept., Washington, District of Columbia, United States (Proposal Position)
The Opportunity:Tetra Tech is seeking a Data Manager/Analyst to support an upcoming program with the Department of State in the Bureau of European... ..., offering cutting-edge solutions in water, environment, energy, and international development. Our work has improved more...
Suggested
For contractors
Work at office
Worldwide
EGlobalTech
Washington DC
4 days ago
Data Analyst - TS/SCI Required
$110k - $180k
OverviewLMI is seeking a Data Analyst responsible for quality delivery of reporting and analysis as part of a Chief Financial Office for... ...collaboration, LMI serves the defense, space, healthcare, and energy sectors—helping agencies navigate complexity and outpace change...
Suggested
Full time
Contract work
Work at office
LMI
Washington DC
14 hours ago
Data Analyst (DBO) - TS/SCI required
$101.14k - $174.59k
Overview LMI is seeking a Data Analyst, with significant Power BI skills and experience, to support the Office of the Under Secretary... ...collaboration, LMI serves the defense, space, healthcare, and energy sectors—helping agencies navigate complexity and outpace change...
Suggested
Full time
Contract work
Work at office
LMI
Arlington, VA
14 hours ago
Data Analyst - Junior - Transition and Economic Development (HR | Exempt) [008H008Y1]
...Compliance, Business Process, IT Effectiveness, Energy & Sustainability, and Talent Management.... ...at DescriptionProSidian Seeks a Data Analyst - Junior - Transition and Economic... ...is a valued asset in your professional portfolio and adds to your credentials.ProSidian Employee...
Suggested
Full time
Temporary work
For contractors
Work at office
Flexible hours
Prosidian Consultng
Washington DC
3 days ago
Data Analyst (Chemical Manufacturing)
Wood is recruiting for a Data Analyst to join its US Onshore Operations Americas business. This position is on site in Washington, WV, United... ...solutions to an ever-broadening range of clients across the energy and materials industries globally. We deliver operations,...
Suggested
Daily paid
Permanent employment
Full time
Local area
Relocation
Visa sponsorship
Flexible hours
WOOD GROUP
Washington DC
4 days ago
Acquisition Policy Specialist - Clearance Required
$90.62k - $135.75k
...and collaboration, LMI serves the defense, space, healthcare, and energy sectors—helping agencies navigate complexity and outpace change.... ...with the Paperwork Reduction Act. Track requirements and manage data in government information systems.Prepare and proofread formal...
Full time
Contract work
Work experience placement
Shift work
LMI
Alexandria, VA
1 day ago
Energy Data Analyst | Evaluation Support [DOEOP043048]
...Compliance, Business Process, IT Effectiveness, Energy & Sustainability, and Talent Management.... ...at DescriptionProSidian Seeks a Energy Data Analyst | Evaluation Support [DOEOP043048] -... ...is a valued asset in your professional portfolio and adds to your credentials.ProSidian...
Full time
Contract work
Temporary work
For contractors
H1b
Work at office
Flexible hours
Prosidian Consultng
Washington DC
3 days ago
Senior Acquisition Specialist- Aviation - Clearance Required
$130k - $180k
...serves the defense, space, healthcare, and energy sectors—helping agencies navigate... ...OSW and Service actions on the assigned portfolio of programs.Reviewing reports, studies, and... ...contractual training, special projects, proposals, data calls, etc.).Representing DASW(PWPM) on...
Full time
Contract work
Work at office
LMI
Arlington, VA
14 hours ago
Senior Acquisition Specialist
$110k - $180k
...government, efficiently and effectively. With a focus on agility and collaboration, LMI serves the defense, space, healthcare, and energy sectors—helping agencies navigate complexity and outpace change. Headquartered in Tysons, Virginia, LMI is committed to delivering...
Full time
Contract work
For contractors
LMI
Washington DC
1 day ago
Energy Data Analyst | Energy Technical Consulting Services [DOEOP002007]
...practice spanning six solution areas including Risk Management, Energy & Sustainability, Compliance, Business Process, IT... ...for more information.Job DescriptionProSidian Seeks a Energy Data Analyst | Energy Technical Consulting Services [DOEOP002007] - DPLH Est...
Full time
Contract work
H1b
Work at office
Prosidian Consultng
Washington DC
3 days ago
Data/Systems Analyst (CONTRACT CONTINGENT)
...Compliance, Business Process, IT Effectiveness, Energy & Sustainability, and Talent Management.... ...Team to take ownership of assigned data and system analysis and support program goals... ...is a valued asset in your professional portfolio and adds to your credentials based on...
Contract work
For contractors
Flexible hours
Prosidian Consultng
Washington DC
4 days ago
Investment Analyst
...For more information, visit The Global Energy (CNGEN) unit, in collaboration with the... ...CNGEN is looking to recruit an Investment Analyst to work closelywith seasoned investment... ...management Monitoring existing investments in portfolio companies, including various types of...
Work experience placement
PDS Services
Washington DC
4 days ago
Investment Officer
...This position is part of the EDF Office of Energy Dominance Financing, Department of Energy. As a Managing Investment Officer, Utilities Vertical Lead, you will provide financing to American energy and manufacturing projects, including energy generation, transmission,...
Work at office
U.S. Department of Energy
Washington DC
4 days ago
Investment Officer
(Associate) Investment Officer - Energy Job #: req37815 Organization: IFC Sector: Investment Grade: GF Term Duration: 4 years 0 months... ...sector partners, investing in groundbreaking projects and using data, research, and technology to develop solutions to the most urgent...
Work at office
Worldwide
IFC - International Finance Corporation
Washington DC
3 days ago
Investment Officer
...August 10, 2026 Summary This position is part of the EDF Office of Energy Dominance Financing, Department of Energy. As a Managing... ...officials. Direct a team of Senior Investment Officers and Investment Analysts by establishing goals, evaluating employee performance,...
Work at office
Department of Energy - Agency Wide
Washington DC
14 hours ago
Data Analyst
...government services. Our human-centered, data-driven approach is focused on truly understanding... ..., your passion for service, your energy for solutioning, and your bias towards action... ...The Gist... We are seeking a Data Analyst - Lead who will lead analytical support...
For contractors
Local area
Amivero
Washington DC
3 days ago
FSM Capital Planning Investment Controls Analyst II
...Business Process, IT Effectiveness, Energy & Sustainability, and Talent... ...Planning Investment Controls Analyst II to support an engagement... ..., evaluate and test financial data for a number of recurring departmental... ...asset in your professional portfolio and adds to your credentials....
Full time
Temporary work
For contractors
Work experience placement
Work at office
Flexible hours
Prosidian Consultng
Washington DC
3 days ago
Munitions Acquisition Portfolio Analyst, Senior
$86.8k - $198k
Munitions Acquisition Portfolio Analyst, SeniorThe Opportunity: As an expert in defense acquisition, your unique background inspires you to think bigger, push further, and ask questions others don’t. We need your extensive industry knowledge and advisory skills to solve...
Full time
Contract work
Part time
Work at office
Local area
Remote work
Booz Allen Hamilton
Arlington, VA
4 days ago
Infrastructure Finance Analyst
...Seeks a Infrastructure Finance Analyst | Project Finance & Credit... ...department within the US Department of Energy [The Loan Programs Office (LPO... ...including finance workbooks, data books, due diligence findings,... ...asset in your professional portfolio, enhancing your credentials....
Full time
Contract work
Temporary work
For contractors
Work at office
Remote work
Flexible hours
Prosidian Consultng
Washington DC
1 day ago
Senior Financial Reporting Analyst
...safe and effective nuclear solutions for global security, clean energy, environmental restoration, nuclear medicine and space... ...nuclear innovation. Position Overview: The Financial Reporting Analyst at BWXT ensures the accuracy and integrity of financial reporting...
3 days per week
BWXT
Alexandria, VA
2 days ago
Financial Analyst
...Professionals to industries focused on Aerospace and Defense, Energy, Construction, and Healthcare/ IT. We strive for excellence and... ...Great Places to Work 2021, 2022, 2023 and 2024. Program Financial Analyst / Tool SME (Deltek Cobra, Oracle, and/or Microsoft tool-sets)...
Immediate start
ClearPlan LLC
Washington DC
1 day ago
Financial Analyst
$100k - $120k
...Financial Analyst Department: Buckstop Employment Type: Contract to hire Location: Washington... ..., logistics, reverse supply chains, energy, mining, and technology who have experienced... ...advisors, and auditors Ensure financial data accuracy and integrity across systems Energy...
Contract work
C10labs
Washington DC
14 hours ago
Financial Analyst
Fluence Energy, LLC is seeking an experienced professional for Portfolio Finance Management. This position involves managing the financial aspects of BESS projects, ensuring compliance with accounting guidelines, and interfacing with internal stakeholders and customers...
Fluence
Arlington, VA
3 days ago
Commercial Analyst
$80k - $100k
...growth‑oriented North American energy company headquartered in... ...seeking a motivated Commercial Analyst to join our Commercial Operations... ...and commercial strategy of a portfolio of power generation assets while... ...developments and provide clear, data‑driven insights. Extract,...
Work at office
Work from home
Capital Power Operations (USA) Inc
Washington DC
4 days ago
Data Management Specialist - Senior - Transition and Economic Development (HR | Exempt) [011K011Y1]
...Compliance, Business Process, IT Effectiveness, Energy & Sustainability, and Talent Management.... ...at DescriptionProSidian Seeks a Data Management Specialist - Senior - Transition... ...Clearance is a valued asset in your professional portfolio and adds to your credentials.ProSidian...
Full time
Temporary work
For contractors
Work at office
Flexible hours
Prosidian Consultng
Washington DC
3 days ago
Senior Transportation Data Specialist (Hybrid)
$81.15k - $137.95k
Title: Senior Transportation Data SpecialistLocation: Washington, DC or New York Area About... ...of transportation and the environment, energy, and communities. ICF’s work focuses on... ...established goals.Develops and manages a portfolio of projects in a particular area of expertise...
Full time
Contract work
Work experience placement
Work at office
Local area
ICF
Arlington, VA
14 hours ago
Mid-Level InfoSec Mobile Device Security Analyst
...Business Process, IT Effectiveness, Energy & Sustainability, and Talent... ...Mobile Device Security Analyst Consultant focusing on Cyber-Security... ...access, modification of data, and malicious activity. These... ...valued asset in your professional portfolio and adds to your credentials...
Full time
For contractors
Work experience placement
Internship
Work at office
Monday to Friday
Shift work
Prosidian Consultng
Washington DC
3 days ago
SCRM Financial and Economic Analyst - Clearance Required
$100k - $150k
OverviewThe SCRM Financial and Economic Analyst will support Department of War (DoW) supply... ...involves gathering and analyzing data to enable proactive industrial base decision... ...serves the defense, space, healthcare, and energy sectors—helping agencies navigate complexity...
Full time
Contract work
Work at office
LMI
Arlington, VA
14 hours ago
Senior Financial Analyst & Accountant
$96.74k - $153.57k
...Association (NEA) supports its strategic objective to focus the energy and resources of its 3+ million members toward the promotion of... ...) Demonstrated experience as a Controller or Financial Analyst adhering to GAAP, GAAS, FASB and federal, state, and local requirements...
Local area
Weekend work
Afternoon shift
National Education Association
Washington DC
2 days ago
Energy Budget/Financial Analyst
...areas including Risk Management, Energy & Sustainability, Compliance,... ...Seeks a Budget/Financial Analyst in CONUS/OCONUS - Washington,... ...ability to monitor budgeting data and contract details essential... ...valued asset in your professional portfolio and adds to your credentials.ProSidian...
Full time
Contract work
Temporary work
For contractors
Work experience placement
Work at office
Flexible hours
Prosidian Consultng
Washington DC
3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Energy Data Portfolio Analyst. Be the first to apply!