ETRM IT Business Analyst

About the Role

Colonial Oil Industries uses Energy Trading and Risk Management (ETRM) software for its operations, which include supplying and marketing refined products and marine fuels. This software captures trades, schedules and moves product, tracks inventory, values positions, and settles and invoices counterparties. The IT Business Analyst I – ETRM role will support the business users of these systems (traders, schedulers, supply and logistics, operations, accounting) and assist with configuring and troubleshooting other essential systems. Domain knowledge of commodity trading is not required on day one; the company seeks individuals who are analytical, curious, detail-oriented, and interested in learning about physical and financial energy markets.

Key Responsibilities

• Learn the end-to-end trade lifecycle, including deal capture, confirmation, scheduling and logistics, inventory movement, valuation, settlement, invoicing, and accounting hand-off, and how the ETRM platform supports each step.
• Provide day-to-day application support by triaging user questions and issues, reproducing problems, documenting them clearly, and driving them to resolution with internal teams or the software vendor.
• Investigate data questions using SQL, validating volumes, prices, positions, and invoice amounts across source systems and the ETRM database.
• Document current-state processes through written procedures, process maps, and swim-lane diagrams; maintain reference material and terminology glossaries.
• Gather and write requirements for enhancements and projects, translating business needs into specifications for developers and configurators.
• Support testing by building test cases, executing functional and regression testing, and tracking defects to closure.
• Assist with user onboarding, security group and permission setup, and training material.
• Support system interfaces and scheduled jobs, such as market data feeds, pricing, and accounting exports, including monitoring and basic troubleshooting.
• Contribute to implementation, upgrade, and system replacement projects, including data validation, reconciliation, cutover checklists, and post-go-live support.

Requirements & Tech Stack

• SQL
• Excel (including lookups, pivot tables, working with large data sets)
• Analytical skills
• Problem-solving skills
• Quantitative reasoning (comfort with numbers, units, formulas)
• Attention to detail
• Written and verbal communication skills (ability to explain technical findings to non-technical audiences)
• Precision and follow-through
• Willingness to learn the commodity trading business and ask questions until understanding is achieved.

Qualifications

• Bachelor's degree completed or in progress in a quantitative or analytical field such as physics, mathematics, statistics, finance, economics, engineering, computer science, or information systems.
• Exposure to SQL or any relational database (preferred).
• Coursework, internship, or project work involving markets, derivatives, pricing, risk, or time-series data (preferred).
• Scripting or programming experience in any language (e.g., Python, C#, VBA, R) (preferred).
• Familiarity with process mapping, requirements documentation, or Agile delivery (preferred).
• Interest in refined products, marine fuels, or physical commodity supply and logistics (preferred).

Work Environment and Travel

• This position is based in Houston, Texas.
• Some travel to Savannah, Georgia or other Colonial offices will be required at times.

Eligibility to work in the United States is required.