Structured Power Back Office Analyst
Full-time
Total Energies
Context & Environment 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. Activities 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. Financial
Non-Financial
Key Responsibilities:
- 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.
- 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.
- X
Vacancy posted 19 hours ago
Similar jobs that could be interesting for youBased on the Structured Power Back Office Analyst in Washington DC vacancy
- ...are currently seeking a talented and motivated Senior Data Analyst / Power BI Developer for a for a full-time position. Position Overview... .... This role translates business data from a wide variety of structured and unstructured sources into usable enterprise information...StructuresFull time
- ...and financial commodity markets, including power, natural gas, LNG, environmental products... ...markets. The Senior Market Compliance Analyst (Power) supports the Market Compliance... ...potential impact of regulatory and market-structure changes on trading strategies, commercial...StructuresFull timeLocal areaVisa sponsorshipWork visa
$75k - $95k
...Job Description Job Description Senior Power BI & SharePoint Business & Data Intelligence Analyst (Power Platf o rm / Federal Category Management)... ...Power Automate SharePoint Lists / Dataverse for structured data storage SQL (preferred) – for querying and...Structures$87k - $104.55k
...Corporation, the largest US-based global power company with a team of 8,300 employees across... ...in the US. This Project Cost Control Analyst plays a critical role in supporting the financial... ...data in SAP within our cost breakdown structure (CBS/WBS). ~ Assist in the monthly...StructuresFor contractorsWorldwide$91.1k - $179.5k
...environment? As an experienced Epic ASAP Analyst, you will have the ability to share new... ...cloud infrastructure. These solutions are powered by engineering for business advantage,... ...for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All...StructuresLocal areaImmediate startNight shift$83.33 per hour
...existing business processes, organizational structure, workflow efficiencies, and governance... ...progressive leaders to drive change. That's the power of true partnership. TEKsystems is an... ...using AI tools.Job SummaryJob number: JP-006303251Profession: Business/Systems AnalystStructuresContract workTemporary workImmediate startRemote work$26 - $28 per hour
...Speech And Voice Ai Analyst Welo Data is hiring Portuguese (Portugal)-speaking analysts... ..., speech, and language datasets that power production AI systems. Role Details... ...High attention to detail; comfort with structured, repetitive workflows ~ US work authorization...StructuresFull timeVisa sponsorshipWork visa$169.28k - $197.2k
...Your Talent, Their Success. Powering the mission of the United States... ...-time Supervisory Program Analyst, GG-0343-15 to work at HQ US.... ...equities within the corporate structure and requirements governance... ...civilian personnel, Field Grade Officers, and contractor teams....StructuresFull timeFor contractorsRelocation package- ...conservation organizations, seeks aCompensation Analyst. The Compensation Analyst supports WWF's... ...compensation programs, including salary structures, annual merit increases, promotions,... ...of the challenges we face through the power of collective action and innovation....StructuresRelocation
- ...approaches and techniques.Program Analysts have the knowledge, skills,... ...managers, contracting officers, and external stakeholders to... ...platforms, and leveraging Excel, Power Query, and Power BI to automate... ...fosters problem solving, structured thought and creativity. (mandatory...StructuresFor contractors
- ...FSR Analyst Employment Type: Full-Time, Mid-Level Department: Administrative and... ...analytics into daily operations using a powerful, governed data platform. CGS brings motivated... ...ambiguous operational questions into structured analyses. Support live operations...StructuresFull timeFlexible hours
- ...BigBear.ai is seeking a Senior All Source Analyst to conduct analysis using intelligence... ...for objectivity, source validation, and structured analytic techniques. Mentor and... ...BigBear.ai is a leading provider of AI-powered decision intelligence solutions for national...Structures
$26 - $28 per hour
...Data Labeling Analyst Welo Data is looking for detail-oriented and reliable individuals... ...focused on building the datasets that power real-world AI systems. You'll be working... ...ensure models are trained on accurate, well-structured, and representative inputs. While...StructuresFull timeWork experience placementRemote workVisa sponsorship- Analytica is seeking a Data Analyst to support the Defense Health Agency (DHA). This role... ...a 401(k) match.Responsibilities:Analyze structured and unstructured datasets from multiple... ...dashboards and data visualizations using Power BI or TableauCollaborate with...Structures
$135k - $147k
...growth. We benchmark roles against external market data and use structured leveling frameworks to ensure fairness, consistency, and... ...heights in your career. We are Meltwater. Inspired by innovation, powered by people. Meltwater is an Equal Opportunity Employer and Prohibits...StructuresLocal areaFlexible hours$55.2k - $126k
...data visualization using resources like MS Power Platform.The real impact of project... ...or project managementExperience pulling structured or unstructured data into dashboards or analytic... ...primarily be performed at a Booz Allen office or customer facility, where employees will...StructuresFull timeContract workPart timeWork at officeLocal areaRemote work- ...Emerging and Disruptive (E&D) Technology Analyst to analyze and assess future technology... ...associated strategic risks. Apply structured analytic techniques and rigorous tradecraft... ...BigBear.ai is a leading provider of AI-powered decision intelligence solutions for national...StructuresWorldwide
- ...Senior Compensation Analyst The Senior Compensation Analyst will... ...and maintain robust salary structures, job levelling, and internal... ...with experience using Excel, Power BI and Workday including Advanced... ...knowledge of Microsoft Office Suite (Word, PowerPoint, Excel...StructuresPermanent employmentWork at office
$75.2k - $158.1k
...modernization decision. As a Data Analyst on our FEMA ITSA program, you... ...decisions. You'll conduct structured interviews with system owners... ...headquarters and regional offices, capturing the operational... ...or reporting tools (Tableau, Power BI, or similar) Knowledge of...StructuresContract workFor contractorsWork experience placementWork at officeLocal areaFlexible hours- ...Subject Matter Expert (SME) All Source Analyst to conduct analysis using intelligence... ...including source validation, objectivity, and structured analytic techniques. Serve as a... ...BigBear.ai is a leading provider of AI-powered decision intelligence solutions for national...Structures
$82.97k - $110.63k
...the trusted network for the AI-powered world, connecting people,... ...Senior Corporate Development Analyst will support all aspects of merger... ...opportunity Assist in the structuring and management of projects... ...of proficiency with Microsoft Office suite, including but not...StructuresTemporary workWork at officeRemote workRelocation$125.1k - $225.2k
...seeking a highly skilled Readiness Data Analyst to support the Office of the Deputy Principal Cyber Advisor... ...data using tools such as Tableau and Power BI. Translate complex operational... ...requirements, and organizational structures. Provide technical and analytical...StructuresWork at officeFlexible hours$28.41 - $56.83 per hour
...Description Strategic Sourcing Analyst – Memory and Storage products... ...supplier spend, pricing, cost structures, capacity, lead times, and... ...applications, and expertise to power everything from industry innovations... ...encourage employees to give back to their communities through...StructuresHourly payContract workTemporary workFlexible hours- ...Configuration Management (CM) Analyst to support enterprise IT... ...detail, experience working within structured CM methodologies, and a... ...Washington, DC Hybrid - 2 days in office and 3 days remote Clearance... .... Familiarity with Power BI or other data visualization...StructuresFor contractorsWork at officeRemote work
- ...proper role of air, space and cyberspace power within a Joint/Combined Force. Duties:... ...experience requirements described in the Office of Personnel Management (OPM) Qualification... ...capabilities, weapons systems, size and structure of allied/partner air forces. FEDERAL...StructuresFull timeTemporary workPart timeWork experience placementWork at officeTrial period
$34 per hour
...Data Labeling Analyst Welo Data is looking for detail-oriented and reliable individuals... ...focused on building the datasets that power real-world AI systems. You'll be working... ...ensure models are trained on accurate, well-structured, and representative inputs. While...StructuresWork experience placementRemote work$50k - $175k
...Technology, Inc. is seeking a Program Analyst to provideprogram management,... ...business support to the FAA Office of Commercial Space... ...using advanced Excel, PowerApps, Power BI, SharePoint, or comparable... ...with FAA organizational structures, processes, and terminology....StructuresContract workFor contractorsWork at office- ...Analyst Position at M&C Saatchi World Services M&C Saatchi World... ...are comfortable working with structured datasets, collaborating... ...intelligence platforms such as Power BI, Tableau, Google Analytics... ...regularly to the Washington DC office space. • Language Requirements...StructuresContract workLive inWork at officeLocal areaImmediate startFlexible hours
$96.41k - $115k
...Niner 9th Way Insignia is seeking a Data Analyst to support a government customer in... ...identifying trends, gaps, anomalies, and structural risks, and translating business needs into... ...to work closely with ETL Developers, Power BI Developers, Power Apps Developers, Technical...StructuresContract workLocal area$61.7k - $109.4k
...Technology Analyst At Accenture Federal Services, nothing matters more than helping... ...agencies solve complex challenges through the power of technology, data, and human ingenuity... ...mindset and a passion for applying structured thinking to real-world problems. What...StructuresContract workLive inLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Structured Power Back Office Analyst. Be the first to apply!
Related searches
- etl analyst Washington DC
- utilities analyst Washington DC
- remediation analyst Washington DC
- allocation analyst Washington DC
- industry analyst Washington DC
- packaging analyst Washington DC
- medicare analyst Washington DC
- remote analyst Washington DC
- IT governance analyst Washington DC
- invoice analyst Washington DC


