Financial Analyst III

Lorien; Houston (TX); On-site; USD 89,544 - 103,320; Part time

Job summary

A leading finance firm in Houston is seeking a Mid-Senior level professional for a Contract role focusing on P&L reporting and risk analysis in commodity markets. The ideal candidate will collaborate across functions to ensure accurate reporting and compliance with governance standards. Strong technical skills in Excel and ETRM systems like SAP are essential, along with knowledge in financial instruments and risk concepts. This is an excellent opportunity for those looking to enhance their career in the oil and gas industry.

Qualifications

• Strong understanding of commodity markets, derivatives, and financial instruments.
• Knowledge of the trade lifecycle, from deal capture through settlement.
• Solid understanding of risk concepts, valuation methodologies, and MTM processes.

Responsibilities

• Generate, validate, and publish daily P&L and exposure reports.
• Analyze and explain daily P&L movements.
• Validate trade capture between front-office and back-office systems.
• Partner with trading and risk management for operational alignment.
• Lead automation of reporting processes.

Skills

Advanced Excel

Experience with ETRM systems

Familiarity with Power BI

Knowledge of Python or SQL

Tools

SAP

Openlink/Endur

Allegro

FIS

Job description

Base pay range

$65.00/hr - $75.00/hr

Position Summary

This position is responsible for delivering accurate daily P&L, exposure reporting, valuation integrity, and risk analysis across a diverse set of commodity products. This role partners closely with trading, operations, accounting, and risk management teams to ensure timely reporting, strong control governance, and high‑quality analytics supporting commercial decision‑making.

Key Responsibilities

Daily P&L & Exposure Reporting

• Generate, validate, and publish daily P&L and exposure reports across crude oil, gasoline, distillates, fuel oil, renewables, and NGLs.
• Ensure accuracy of positions, mark‑to‑market valuations, realized/unrealized P&L, and exposure metrics.

P&L Attribution & Commentary

• Analyze and explain daily P&L movements, including key drivers such as price changes, position shifts, basis changes, and market events.
• Provide clear, concise commentary to trading, risk, and senior leadership.

Trade & Deal Validation

• Validate accurate trade capture between front‑office trade tickets and middle/back-office systems.
• Work with traders, scheduling, and operations teams to resolve discrepancies or breaks.
• Validate market data inputs, forward curves, and price assessments to ensure consistency and accuracy across valuation models.
• Monitor illiquid market inputs and elevate abnormalities as needed.

Cross‑Functional Collaboration

• Partner with trading, scheduling/logistics, accounting, and risk management to support timely reporting and operational alignment.
• Ensure risk numbers align with financial reporting requirements.

Process Optimization & Automation

• Lead or support standardization and automation of reporting processes.
• Contribute to enhancements in risk systems, dashboards, and analytical tools.

Governance & Controls

• Maintain documentation and controls to ensure compliance with internal policies, audit requirements, and regulatory standards.
• Support control testing, process documentation, and data governance activities.

Required Technical Skills

• Advanced Excel (complex formulas, lookups, pivots, automation techniques).
• Experience with ETRM systems such as SAP, Openlink/Endur, Allegro, or FIS.
• Familiarity with Power BI; knowledge of Python or SQL is a strong plus.

Required Knowledge Areas

• Strong understanding of commodity markets, derivatives, and physical/financial instruments.
• Knowledge of the trade lifecycle, from deal capture through settlement.
• Solid understanding of risk concepts, valuation methodologies, and MTM processes.

Seniority level

Mid‑Senior level

Employment type

Contract

Job function

Finance

Industries

Oil and Gas

Impellam Group and its brands are equal‑opportunity employers committed to diversity and inclusion. All qualified applicants will receive consideration without regard to race, color, religion, gender, sexual orientation, pregnancy or maternity, national origin, age, disability, veteran status, or any other factor determined to be unlawful under applicable law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application, interview process, pre‑employment activity, and the performance of crucial job functions.

If you require additional disability considerations, modifications, or adjustments please let us know by contacting [e-mail] or fill out this form to request accommodations.