Analyst, Middle Office

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.