ETRM IT Business Analyst

Colonial Group • Houston, TX

8d • Onsite

About The Position

Colonial Oil Industries supplies and markets refined products and marine fuels, using energy trading and risk management (ETRM) software to capture trades, schedule and move product, track inventory, value positions, and settle and invoice with counterparties. The IT Business Analyst I – ETRM supports business users—including traders, schedulers, supply and logistics, operations, and accounting—in their daily use of these systems, and helps configure and troubleshoot related applications. The company will teach the commodity-trading domain and is seeking someone analytical, curious, attentive to detail, and motivated to learn how physical and financial energy markets work.

The role offers exposure to traders, schedulers, and accountants; hands-on work with a live trading platform; and opportunities to contribute early to ETRM modernization, requirements, selection, and implementation work. The position is based in Houston, Texas, with occasional travel to Savannah, Georgia, or other Colonial offices.

Requirements

• Bachelor's degree, completed or in progress, in physics, mathematics, statistics, finance, economics, engineering, computer science, information systems, or a comparable analytical field.
• Strong quantitative and problem-solving skills, including comfort reasoning about numbers, units, and formulas and noticing when figures do not tie out.
• Strong written and verbal communication skills, including the ability to explain technical findings to non-technical audiences.
• Solid Excel skills, including lookups, pivot tables, and working with large data sets.
• Precision and follow-through, particularly because small errors in settlement and invoicing can have financial consequences.
• Willingness to learn the commodity trading business and ask questions until the answers make sense.

Nice To Haves

• Exposure to SQL or any relational database.
• Coursework, internship, or project work involving markets, derivatives, pricing, risk, or time-series data.
• Scripting or programming experience in any language, such as Python, C#, VBA, or R.
• Familiarity with process mapping, requirements documentation, or Agile delivery.
• Interest in refined products, marine fuels, or physical commodity supply and logistics.

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 it.
• Provide day-to-day application support by triaging user questions and issues, reproducing and documenting problems, and driving them to resolution with internal teams or the software vendor.
• Investigate data questions using SQL and validate volumes, prices, positions, and invoice amounts across source systems and the ETRM database.
• Document current-state processes using written procedures, process maps, and swim-lane diagrams, and maintain reference materials and terminology glossaries.
• Gather and write requirements for enhancements and projects, translating business language into specifications for developers and configurators.
• Build test cases, execute functional and regression testing, and track defects through closure.
• Assist with user onboarding, security group and permission setup, and training materials.
• Support system interfaces and scheduled jobs, including market data feeds, pricing, and accounting exports, through monitoring and basic troubleshooting.
• Contribute to implementation, upgrade, and system replacement projects through data validation, reconciliation, cutover checklists, and post-go-live support.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level