ETRM IT Business Analyst

Colonial Group; Houston (TX); On-site; USD 70,000 - 100,000; Full time

Job summary

Colonial Oil Industries in Houston, TX is seeking an IT Business Analyst I – ETRM to learn and support our energy trading and risk management platform. You will work with traders, schedulers, and operations to troubleshoot issues and document requirements.

The role emphasizes data validation with SQL, process documentation, test-case development, and onboarding. Some travel to Savannah and other Colonial offices may be required.

Qualifications

• Bachelor's degree in physics, mathematics, statistics, finance, economics, engineering, CS, information systems, or related analytical field.
• Strong quantitative and problem-solving abilities with comfort handling numbers and formulas.
• Clear written and verbal communication to explain technical findings to non-technical audiences.
• Solid Excel skills, including lookups and pivot tables, with large data sets.
• Accurate, precise work in settlement/invoicing with attention to detail.
• Willingness to learn the commodity trading business and ask questions until understood.

Responsibilities

• Learn the end-to-end trade lifecycle and how the ETRM platform supports each step.
• Provide day-to-day application support: triage questions, reproduce problems, document, and drive resolution.
• Investigate data questions using SQL and validate volumes, prices, positions, and invoices.
• Document current-state processes with procedures, maps, and glossaries; keep reference material current.
• Gather and write requirements for enhancements and translate into specifications for developers.
• Support testing: build test cases, run functional/regression tests, track defects to closure.
• Assist with user onboarding, security, and training materials.
• Support system interfaces and scheduled jobs, monitor and troubleshoot.
• Participate in data validation, reconciliation, cutover checklists, and post-go-live support.

Skills

Quantitative skills

Communication

Excel skills

Attention to detail

Learning mindset

Numerical reasoning

Education

Bachelor's degree in analytical field

Tools

SQL

Excel

Job description

ABOUT THE ROLE

Colonial Oil Industries supplies and markets refined products and marine fuels, and that business runs on energy trading and risk management (ETRM) software - the systems that capture trades, schedule and move product, track inventory, value positions, and settle and invoice with counterparties. The IT Business Analyst I – ETRM role supports the business users who live in those systems every day (traders, schedulers, supply and logistics, operations, accounting), along with helping to configure and troubleshoot the other systems these groups rely on daily.

You do not need to know the commodity trading business on day one. You need to be analytical, curious, careful with detail, and genuinely interested in learning how physical and financial energy markets work. We will teach you the domain; we are hiring for aptitude and work ethic.

KEY RESPONSIBILITIES

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

QUALIFICATIONS

Required

• Bachelor's degree, completed or completing, in physics, mathematics, statistics, finance, economics, engineering, computer science, information systems, or a comparable analytical field.
• Strong quantitative and problem-solving skills; comfort reasoning about numbers, units, and formulas, and the instinct to notice when something does not tie out.
• Strong written and verbal communication — the ability to explain a technical finding to a non-technical audience.
• Solid Excel skills, including lookups, pivot tables, and work with large data sets.
• Precision and follow-through. In settlement and invoicing work, small errors carry real dollars.
• Willingness to learn the commodity trading business and to ask questions until the answer makes sense.

Preferred

• 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 (Python, C#, VBA, R).
• Familiarity with process mapping, requirements documentation, or Agile delivery.
• Interest in refined products, marine fuels, or physical commodity supply and logistics.

WHAT SUCCESS LOOKS LIKE

• 90 days: You can navigate the ETRM system confidently, handle routine user requests independently, and describe the trade lifecycle in your own words.
• 6 months: You own a functional area of support, write your own requirements and test cases, and answer data questions with SQL without hand-holding.
• 12 months: You are a trusted point of contact for a business group and contribute meaningfully to enhancement and project work.

WHY THIS ROLE

ETRM is a narrow, well-paid specialty at the intersection of commodity markets, accounting, and enterprise systems, and there is no college major that produces it. This role is a deliberate on-ramp: direct exposure to traders, schedulers, and accountants, hands-on work in a live trading platform, and

the kind of domain knowledge that takes most people years to assemble. COI is actively modernizing its ETRM footprint, so you will see requirements, selection, and implementation work early rather than years into your career.

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.