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 3 days ago
Similar jobs that could be interesting for youBased on the Structured Power Back Office Analyst in Washington DC vacancy
- ...seeking a mid-level Contracts Data Analyst to support data organization,... ...Lead, this individual will structure incoming contracting data,... ...data workflows across Power BI, SharePoint, and Smartsheet... ...successful mission outcomes from the back office to the battlefield. Our team...StructuresBack officeFull timeContract work
- Blue Energy seeks an Origination Analyst passionate about energy markets and the nuclear transition. You will... ..., and help shape the next generation of nuclear power deals. This growth role offers exposure to deal structuring, customer engagement, and a fast-paced, cross-...Structures
- ...Operations Research Systems Analyst to support federal health IT... ...Defense programs. This is not a back-office analyst role. The successful... ...directly with client stakeholders, structure ambiguous problems, and... ...visualization tools such as Power BI, Tableau, SQL, Python, R,...StructuresBack officeContract workFor subcontractorFlexible hours2 days per week
$110.7k - $218.3k
...paced transaction deadlines. This is not a “back-office” position; this is front-line client... ...examples include but not limited to Tableau, Power BI, Excel Charts, etc.)Experience... ...availablePreferred:Strong working knowledge of data structures and database designKnowledge of GAAP,...StructuresBack officeLocal area- ...responsible for the Group's gas, power, LNG, dry bulk, and LPG... .... The TGPNA Middle Office team consists of more... ...3 to 5 Middle Office Analysts responsible for... ...select ISOs/RTOs, and structured transactions. Partner... ...effectiveness. Collaborate with Back Office, Finance, Credit...StructuresBack officeFull timeWork at officeVisa sponsorshipWork visaFlexible hours
- ...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- 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
$73k - $85k
...Business Analyst The Company: Censeo Consulting Group is a top... ...work from home and work in our office conveniently located in the... ...leaving for a meeting and being back in the office in time for post... ...Business Journal’s Philanthropy List #LI-Hybrid Powered by JazzHR...Back officeFull timeWork at officeRemote workWork from homeFlexible hoursNight shift$85k - $116.8k
...intellectually curious Data Platforms Analyst to help power our data-driven decision-making and audience... ...stakeholder requirements into structured analytics layersCollaborate with business... ...distance of our Washington, D.C. office, as this role requires on-site presence...StructuresWork at office$77k - $202k
...controllers and treasurers to optimise the structure of their finance functions and improve... ...standards of control, efficient back office opportunities and support to the business... ...mentor junior colleagues, and cultivate powerful client relationships while navigating complex...StructuresBack office- ...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 Logistics... ...analytics into daily operations using a powerful, governed data platform. Key... ...Translate ambiguous operational questions into structured analyses. Support live operations with timely...StructuresFull timeFlexible hours
$102.5k - $170.9k
...variety of ETL techniquesDevelop dashboards and visualizations in Power BISupport dashboard administration, including access management... ...LLP. Please see for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. All qualified applicants...StructuresLocal area$99k - $130k
...and sold. Anduril’s family of systems is powered by Lattice OS, an AI-powered operating... ...ABOUT THE TEAM We are seeking a Senior Analyst, Government Rates to join our dynamic, fast... ...drive efficiency across our accounting structure practices which impact our government contracts...StructuresFull timeContract workWork experience placement$62k - $141k
...AnalystThe Opportunity:As data analyst, you love diving into data... ...insights. With the abundance of structured and unstructured data, you... ...congressional requests, across multiple office branches to ensure a holistic... ...or data visualization with Power BI, Excel, or Tableau...StructuresFull timeContract workPart timeWork at officeLocal areaRemote work- ...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
$102k - $170k
...Public TrustWe are seeking a Data Analyst with strong child welfare... ...dashboards (preferred: Power BI)Experience with SQL and PythonAbility... ...preparing, transforming, and structuring data for reporting and... ...Community OutreachEmergency Back-Up Childcare ProgramMobility...StructuresFull timeRemote workFlexible hours$110k
...the rewards. The Business Analyst team shapes the strategy,... ...based in our Washington, D.C. office, with in-person attendance expected... ...Robinhood, we believe in the power of in-person work to... ...optimize business outcomes Structure and solve complex, ambiguous...StructuresRotational programFull timeWork at officeFlexible hoursShift work3 days per week- Wood is recruiting for a Data Analyst to join its US Onshore Operations Americas business... ...developing reports and dashboards using Power BI, including data modeling, Power Query... ...of relational databases, data structures, and data integration concepts.Ability to...StructuresDaily paidPermanent employmentFull timeLocal areaRelocationVisa sponsorshipFlexible hours
$72.7k - $149.2k
...Aircraft Carriers Activity Chief Information Office (ACIO) across all IT, IA, IS, and IM... ...understanding of NMCI and Flank Speed account structures and requirements. IT Operations... ...collection experience would be beneficial ~ Power Apps experience ~ Navy acquisition...StructuresFull timeContract workWork experience placementWork at officeRemote workFlexible hours- ...rewarded.About the PositionThe Data Analyst will support a U.S.... ...activities through the analysis of structured and unstructured data from... ...Excel, Access, and Purview), Power BI, Python, Tableau, and Splunk... ...supporting a Federal Office of Inspector General, Federal...StructuresFull timeFor contractorsWork at office
$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- ...Military Forces Analyst Federated IT Washington, District of Columbia, United States About... ...foreign military organizations, command structure, strategy and doctrine, capabilities, equipment... ...Knowledge of the INDOPACOM AOR and great power competition Knowledge of the IC and...StructuresRelocationFlexible hours
$55.2k - $126k
...Program Analyst The Opportunity: As a project management spe... ...visualization using resources like MS Power Platform. The real impact... ...~ Experience pulling structured or unstructured data into dashboards... ...be performed at a Booz Allen office or customer facility, where...StructuresFull timeContract workPart timeWork at officeLocal areaRemote work$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- ...semantic search. Building on structured metadata intake and validation... ...coordination; coach junior analysts on intake standards and catalog... ...in SharePoint/PowerApps/Power Automate or similar low-code... ...Community OutreachEmergency Back-Up Childcare ProgramMobility...StructuresFull timeInterim roleFlexible hours
$117.72k - $132.55k
...impact at scale. Every dollar we invest is structured to multiply, generating durable returns... ...past decade, CGC has demonstrated the power of public‑private investment by helping... ...President of Information Technology, the Senior Analyst, Technology Governance & Controls is...StructuresContract work- ...Based Earnings: Competitive commission structure with performance-based incentives and unlimited... ...Sales & Administrative Support: Back-office and marketing support so you can focus... ...national resources, proven systems, and powerful sales tools to help our agents close...StructuresBack officeWork at officeLocal area
$100k - $125k
...Data Analyst I Position Overview 2ndWave is seeking a Data Analyst I to provide professional... ...Collect, clean, validate, and organize structured and semi-structured data from Government... ...visualization or reporting tools (e.g., Power BI, Tableau). ~ Strong attention to...StructuresFull timeRemote workMonday to FridayFlexible hours
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
- pay analyst Washington DC
- design analyst Washington DC
- internal audit analyst Washington DC
- open source analyst Washington DC
- production control analyst Washington DC
- legislative analyst Washington DC
- trade analyst Washington DC
- accessibility analyst Washington DC
- soc analyst Washington DC
- hybrid analyst Washington DC


