Nat Gas Middle Office Analyst: PnL, Data, and Reporting

Centalion; Stamford (CT); On-site; USD 120,000 - 180,000; Full time

Job summary

Centalion is a leading global energy trading company seeking a Middle Officer for the Nat Gas desk in Stamford, CT. You will oversee daily trading positions, coordinate PnL reconciliation across traders, Ops, and back office, and deliver detailed reports to leadership.

The role requires 2-5 years in a middle office, experience with trading/ETRM systems, and strong Excel, data analysis, and communication skills.

Qualifications

• Bachelor's degree (or equivalent).
• 2-5 years in a middle office role supporting a Nat Gas trading team (North America markets experience preferred).
• Hands-on experience with trading/ETRM systems; proficiency in SQL or scripting languages is a plus.
• Understanding of complex Nat Gas structures is preferred.
• Expert-level competency in Excel modeling, data analysis, and reporting.
• Proven ability to lead and enhance process-driven projects.
• Proactive, self-starting, disciplined, and highly detail-oriented.
• Exceptional verbal and written presentation skills, capable of engaging with stakeholders at all levels.

Responsibilities

• Oversee daily trading positions, PnL, Ad-Hoc business requests, etc.
• Coordinate daily reconciliation of pricing exposure and PnL between Nat Gas traders, Operations (Ops), and back office.
• Swiftly confirm positional accuracy and PnL; prepare detailed daily reports for senior leadership.
• Review and ensure reliability of data and cost information in the in-house Energy Trading & Risk Management (ETRM) system.
• Develop, implement, and monitor forward-curve models within ETRM; ensure seamless front-to-back integration and adherence to market values.
• Continuously check the accuracy and consistency of Nat Gas forward curves against actual market prices.
• Improve daily processes including market data validation, trade completion, and regulatory reporting specific to the Nat Gas desk.
• Manage and verify Nat Gas-related intercompany transactions across geographic desks/offices.
• Validate futures trades in ETRM against clearinghouse and exchange data to ensure accuracy.
• Maintain daily coordination with Operations (e.g., planning) and back-office teams to support Nat Gas trade execution and settlement.
• Oversee mark-to-market valuation of physical Nat Gas trades recorded in ETRM; allocate hedges in line with defined strategies.
• Reconcile cost inputs in ETRM with Ops' records and external invoicing providers.
• Oversee the reconciliation of month-end results with accounting; manage the translation of trading outcomes into financial statements.
• Serve as backup for other energy desks' Middle Officer duties as operationally required.
• Work closely with the Front Desk, IT, Operations, Finance, and Credit to support Nat Gas trading operations and risk controls.

Education

Bachelor's degree

Tools

SQL

Scripting languages

Job description

Centalion is a leading global energy trading company seeking a Middle Officer for the Nat Gas desk in Stamford, CT. You will oversee daily trading positions, coordinate PnL reconciliation across traders, Ops, and back office, and deliver detailed reports to leadership.

The role requires 2-5 years in a middle office, experience with trading/ETRM systems, and strong Excel, data analysis, and communication skills.