ETRM IT Business Analyst

Colonial Group, Inc. • Houston, TX

9d • Onsite

About The Position

The IT Business Analyst I – ETRM supports business users of energy trading and risk management software at Colonial Oil Industries, including traders, schedulers, supply and logistics, operations, and accounting teams. The role also helps configure and troubleshoot other systems used by these groups. The analyst learns how the ETRM platform supports the end-to-end trade lifecycle, from deal capture through accounting hand-off, and provides application support, investigates data questions, documents processes, gathers requirements, and supports testing and system projects.

The role is based in Houston, Texas, with occasional travel to Savannah, Georgia, or other Colonial offices. Prior commodity trading knowledge is not required; the company will teach the domain and seeks analytical aptitude, curiosity, attention to detail, and a willingness to learn.

Requirements

• Completed or in-progress bachelor's degree 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 discrepancies.
• Strong written and verbal communication skills, including explaining technical findings to non-technical audiences.
• Solid Excel skills, including lookups, pivot tables, and working with large data sets.
• Precision and follow-through, particularly for settlement and invoicing work.
• Willingness to learn the commodity trading business and ask questions until answers make sense.
• Eligibility to work in the United States.

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 and how the ETRM platform supports each step.
• 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 to validate volumes, prices, positions, and invoice amounts across source systems and the ETRM database.
• Document current-state processes in written procedures, process maps, and swim-lane diagrams, and maintain reference material and terminology glossaries.
• Gather and write requirements for enhancements and projects, translating business needs 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; monitor them and perform basic troubleshooting.
• Contribute to implementation, upgrade, and system replacement projects, including data validation, reconciliation, cutover checklists, and post-go-live support.

What This Job Offers

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