Middle Office Analyst

Insight Global

Houston (TX)

On-site

USD 100,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading company in oil and gas is seeking a Middle Office Analyst in Houston. The role focuses on producing daily Profit & Loss reports, trade validation, and maintaining ETRM systems. Candidates should have a strong analytical background and 4+ years of experience in a trading analytics role. This full-time position offers a competitive salary range based on skills and experience.

Qualifications

4+ years in commodities trading middle office analytics role.
Knowledge of physical oil markets and hedging strategies.
Experience with ETRM systems.

Responsibilities

Responsible for accurate P&L reports for traded commodity products.
Perform daily trade validation and reconciliation.
Support month-end and quarter-end close processes.

Skills

Analytical skills

Attention to detail

Quantitative skills

Excel

VBA

Python

Power BI

Education

Bachelor's degree in finance, economics, accounting, or related field

Tools

ETRM systems

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$100,000.00/yr - $120,000.00/yr

Direct message the job poster from Insight Global

The Middle Office Analyst will be responsible for accurate and consistent production of daily Profit & Loss reports for each of the commodity products traded by the Company This role requires product knowledge, strong quantitative and analytical skills, extreme attention to detail, and advanced Excel skills. Own the daily P&L reporting process, including validation, attribution, and commentary for front office and finance stakeholders. Enter and update trades in the Energy Trade and Risk Management (ETRM) system across various commodity groups and asset classes, including but not limited to Crude Oil, Refined Products, Agricultural Products, Metals, FX, and Equities. Perform daily trade validation and position reconciliation between front office systems (e.g., ETRM) and internal records; work closely with front office, risk, operations, and finance teams to resolve discrepancies promptly. Maintain and update the ETRM system, including book structures, instrument setup, and reference data management. Support month-end and quarter-end close processes, including reserve calculations, valuation adjustments, and coordination with the accounting team. Respond to ad hoc requests and provide market analysis and insights to traders and other stakeholders. Identify and implement process improvements, including automation of recurring tasks using Excel, VBA, Python, or Power BI. Monitor and escalate significant exposure, pricing, or valuation discrepancies impacting risk or P&L.

REQUIRED SKILLS AND EXPERIENCE

4+ years of experience in a commodities trading middle office analytics role with a background in accounting and finance, P&L calculation, exposure analysis, and trade support Knowledge of physical oil markets, contracts, pricing, hedging strategies, and industry knowledge Commodities knowledge must include, but not limited to: crude/refined products Experience with ETRM systems and a clear understanding of trade flow processes Bachelor's degree in finance, economics, accounting, or related field

Seniority level