Commercial Transactions Analyst (Crude Oil / NGL)

About the Role

As a Commercial Transactions Analyst, you will serve as the subject matter expert for actualization, pricing, and settlement activities within a Crude Oil / NGL portfolio. You will be responsible for gathering, validating, and maintaining volumetric, pricing, and fee-related information while ensuring accurate and timely transaction settlement.

Working closely with Trading, Scheduling, Risk, Finance, Treasury, Contract Administration, Business Development, and external counterparties, you will play a key role in supporting commercial operations, maintaining data integrity, and driving continuous process improvement. The ideal candidate combines strong commodity marketing experience with analytical expertise, attention to detail, and a collaborative mindset.

Key Responsibilities

As a member of the Commodity Transactions Team, you will:

• Manage volumetric data and actualization processes within ETRM systems and supporting records.
• Identify, validate, and allocate planned and unplanned fees associated with commodity movements and transactions.
• Support risk management and accounting activities, including month-end close processes and unmatched report management.
• Collaborate with Trading, Scheduling, Finance, and other business partners on volumetric, pricing, and fee-related inquiries.
• Ensure data accuracy, consistency, and compliance across systems and reporting processes.
• Identify opportunities for process improvements and automation.
• Support business continuity through documentation, training, and knowledge sharing.
• Prioritize activities to ensure timely invoicing, settlement, and cash collection.

Crude Oil / NGL Portfolio Responsibilities

• Actualize shipper balances, including purchases, sales, facility transfers, and commodity movements.
• Manage and actualize established fees, including tariffs and other contracted charges.
• Actualize unplanned fees, including demurrage and related costs.
• Enter and reconcile Bills of Lading (BOL) within ETRM systems for rail and truck movements.
• Prepare, maintain, and distribute weekly and monthly commodity pricing reports.
• Update and maintain non-risk price curves within ETRM systems.
• Administer monthly pricing for proprietary and internal transfer transactions.
• Calculate third-party transactions and confirm pricing with external counterparties on a monthly basis.
• Gather data for price forecasting activities and prepare forecast models and reporting.
• Reconcile volumetric movements, fees, and trucking charge recoveries.
• Manage terminal receipt reporting and related operational activities.

To support these activities, you will:

• Partner with Trading teams to understand contractual pricing structures and resolve pricing disputes.
• Work closely with Scheduling teams to understand commodity movements, pipeline gains and losses, and intercompany, interbook, and third-party transactions.
• Collaborate with Business Development teams to understand contractual fees, tariffs, and commercial agreements.

Key Deliverables

• Managing volumetric data, shipper balances, fees, pricing, and ETRM updates.
• Supporting accurate invoicing, cash collection, and financial reporting.
• Administering daily pricing reports, monthly proprietary pricing, intercompany pricing, and non-risk price curves.
• Supporting price forecasting activities and maintaining forecast models.
• Validating charges, investigating discrepancies, and resolving pricing and fee disputes.
• Supporting month-end accounting and risk management processes.
• Performing reconciliations, unmatched report reviews, and terminal reporting activities.
• Maintaining high standards of data integrity and regulatory compliance.
• Driving process optimization initiatives and automation opportunities.
• Providing subject matter expertise and operational support across the assigned portfolio.

Core Competencies

• Advanced knowledge of crude oil and NGL transaction processes, allocations, and reconciliations.
• Strong understanding of Bills of Lading, shipper balances, tickets, ETRM workflows, and related commercial processes.
• Excellent analytical skills with the ability to interpret pricing information, producer statements, and third-party invoices.
• Experience working with ETRM systems and related commercial software platforms.
• Strong problem-solving skills and attention to detail.
• Ability to collaborate effectively across Commercial, Scheduling, Risk, Finance, Treasury, Credit, Contract Administration, and Business Development teams.
• Strong verbal and written communication skills with the ability to present complex information clearly.
• A continuous improvement mindset focused on optimizing processes and enhancing operational efficiency.
• Adaptability and the ability to thrive in a fast-paced, evolving commercial environment.

Qualifications

• Minimum 5+ years of experience in a Commodity Marketing, Commercial Operations, Settlement, or Analyst role.
• Industry experience within crude oil, NGL, energy marketing, or commodity trading environments.
• Strong proficiency in Microsoft Excel, Word, and PowerPoint.
• Solid understanding of commodity transaction settlement processes and pricing methodologies.
• Experience with ETRM and marketing systems such as Allegro, RightAngle, Egistix, or similar platforms is considered an asset.
• Strong analytical and quantitative skills with the ability to identify trends, issues, and opportunities.
• Excellent organizational, planning, and time-management skills.
• Strong interpersonal and communication skills with an ability to work effectively across multiple stakeholders.
• Demonstrated ability to solve complex problems and recommend practical solutions.