Analyst, Middle Office

Venture Global LNG; Houston (TX); On-site; USD 75,000 - 110,000; Full time

Job summary

Venture Global LNG in Houston is seeking an Analyst, Middle Office Commodity Solutions to support our Commodity Systems including the ETRM, Price Repository, Commercial Applications and related interfaces.

The role requires 1+ years of experience in commodity trading, strong Excel and SQL skills, and familiarity with ETRM/CTRM systems. You will produce high-quality reports, support Back Office processes, and collaborate with technical staff to drive system improvements.

Qualifications

• 1+ years of experience in Commodity/Energy Trading domain with emphasis in Natural Gas and LNG trading.
• 1+ years experience in designing, coding, configuring, testing, and debugging reports, plugins, and interfaces.
• Excellent MS Excel skills including macros and VBA, creating dynamic reports with PivotTables, building formulas, charts.
• Experience with Java, JavaScript, VBA and other programming languages.
• Experience with SQL/PostgreSQL is required.
• Strong understanding of relational database concepts.
• Strong Object-Oriented, analytical and problem-solving skills.
• Good written and oral communication skills.
• Excellent interpersonal skills.
• Must be self-motivated, independent, and resourceful.

Responsibilities

• Work with team members to produce high quality deliverables for business needs.
• Develop ad hoc reports as required by business to manage position, risk, provide control and security data information, audit reports.
• Provide reports for Back office (Accounting & Settlement).
• Assess the ETRM and related systems architecture currently in place and work with technical staff to provide solutions and process improvement.
• Daily Support: Collaborate with stakeholders involved in CTRM/ETRM; perform daily monitoring; inform stakeholders about technical problems; coordinate with Vendors; support business with system issues; provide audit support; coordinate with Software vendors.

Skills

Excel VBA

PivotTables

SQL

PostgreSQL

Java

JavaScript

Data analysis

Education

Bachelor's degree

Tools

ETRM

Job description

We Are Seeking Qualified Applicants For The Position

Analyst, Middle Office

Located

Houston

Summary

We are seeking an Analyst, Middle Office Commodity Solutions to support our Commodity Systems including the ETRM, Price Repository, Commercial Applications and related interfaces.

General Description Duties & Responsibilities

• Work with team members to produce high quality deliverables for business needs.
• Develop ad hoc reports as required by business to manage position, risk, provide control and security data information, audit reports.
• Provide reports for Back office (Accounting & Settlement).
• Assess the ETRM and related systems architecture currently in place and work with technical staff to provide solutions and process improvement.
• Daily Support:
  • Collaborate with stakeholders involved in the commodity trading and risk management (CTRM) / energy trading and risk management (ETRM) business.
  • Perform daily monitoring to ensure system functionality is working properly.
  • Inform various stakeholders about any technical problems.
  • Coordinate with Vendors as needed.
  • Support the business with system issues to ensure business processes are not interrupted.
  • Provide audit support for ETRM security, change management activities, and audit population reports.
  • Coordinate with Software vendor to understand system functionality including operations, security, and reporting to provide support to business.
• Change Management and Regression testing:
  • Work closely with Front/Middle/Back Office, Operations and Finance business users to provide production support
  • Gather, document, and deliver requirements and use cases through to user acceptance and implementation.
  • Assist in developing technical requirements for ETRM based on new or changing business needs.
  • Assist in the integration of ETRM solutions with third party systems when needed.
  • Support the business in enhancements as needed as LNG implementation and other liquefaction facilities come online.
  • Assist in configurations required as our business expands including updates to contract templates, reporting, curve and location setup, etc.
  • Assist in regression testing and reviewing changes for Service Packs or patches for the Commodity Systems.
• Perform other tasks as assigned.

Qualifications

Required experience

• 1+ years of experience in Commodity/Energy Trading Business domain with emphasis in Natural Gas and LNG trading.
• 1+ years experience in designing, coding, configuring, testing, and debugging reports, plugins, and interfaces.
• Excellent MS Excel skills including task automation using macros and VBA, creating dynamic reports with PivotTables, building formulas, building charts and graphs.
• Experience working with Java, JavaScript, VBA and other programing languages.
• Experience with SQL/PostgreSQL is required.
• Strong understanding of relational database concepts.
• Strong Object-Oriented, analytical and problem-solving skills.
• Good written and oral communication skills.
• Excellent interpersonal skills.
• Must be self-motivated, independent, and resourceful.

Preferred Experience

• Experience working with an ETRM/ or CTRM system preferred.

Required Education

• Bachelor’s degree or greater in Computer Science, Engineering, Finance, Accounting, Economics, or a directly related IT field.

Venture Global LNG is an Equal Opportunity Employer. We do not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law.