ETRM IT Business Analyst

About the Role

The ETRM IT Business Analyst role supports business users of energy trading and risk management (ETRM) software, which handles trade capture, product scheduling and movement, inventory tracking, position valuation, and settlement/invoicing. This role also assists with configuring and troubleshooting other essential systems. No prior commodity trading business knowledge is required; aptitude, work ethic, analytical thinking, curiosity, and attention to detail are valued.

Key Responsibilities

• Learn the end-to-end trade lifecycle within the ETRM platform, from deal capture to accounting hand-off.
• Provide day-to-day application support, triaging user issues and driving them to resolution.
• Investigate data questions using SQL, validating data across source systems and the ETRM database.
• Document current-state processes, process maps, and terminology glossaries.
• Gather and write requirements for enhancements and projects, translating business needs into technical specifications.
• Support testing, including building test cases, executing functional and regression testing, and tracking defects.
• Assist with user onboarding, security setup, and training material development.
• Support system interfaces and scheduled jobs, including monitoring and basic troubleshooting.
• Contribute to system implementation, upgrade, and replacement projects, including data validation, reconciliation, and post-go-live support.

Requirements & Tech Stack

• SQL or any relational database exposure (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).

Qualifications

• 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, with comfort reasoning about numbers, units, and formulas.
• Strong written and verbal communication skills, capable of explaining technical findings to non-technical audiences.
• Solid Excel skills, including lookups, pivot tables, and working with large datasets.
• Precision and follow-through, recognizing the impact of small errors.
• Willingness to learn the commodity trading business and ask clarifying questions.