Analyst II – ISO Settlements

Mitsui & Co. Energy Marketing and Services (USA), Inc.; Houston (TX); Sur place; USD 75 000 - 110 000; Plein temps

Résumé du poste

MEMS is seeking an ISO Settlement Analyst II to perform day-to-day ISO settlement activities, primarily for ERCOT, reviewing settlement data, reconciling data, and supporting disputes.

The role requires strong analytical skills, experience with ETRM or Bid-to-Bill systems, and advanced Excel/SQL capabilities, with collaboration across Trading, Risk Management, Accounting, and IT.

Bachelor’s degree and at least two years in ISO/RTO settlements preferred.

Qualifications

• 2+ years in ISO/RTO settlements or energy trading operations.
• Experience with data reconciliation or variance analysis preferred.
• Bachelor’s degree in Accounting, Finance, Economics, Business or related field.
• Experience with ETRM or Bid-to-Bill preferred.

Responsabilités

• Perform day-to-day ISO settlement activities, primarily for ERCOT, including review of settlement statements, charges, fees, and other settlement-related data.
• Monitor and complete settlement activities across applicable settlement cycles, including Initial, Final, and True-up settlements.
• Reconcile ISO settlement data with ETRM and other relevant data sources.
• Identify and investigate settlement discrepancies, variances, and exceptions, coordinating resolution with stakeholders.
• Support the preparation, tracking, and resolution of ISO settlement disputes.
• Provide accurate settlement data to Accounting for monthly and quarterly close.
• Coordinate with Trading, Risk Management, Credit, Accounting, IT/ETRM, and other teams on settlement and data-related matters.

Connaissances

Analytical skills

Numerical reasoning

Excel advanced

SQL

Power Query

Formation

Bachelor's degree

Outils

ETRM

Bid-to-Bill

Power Query

SQL

Data Visualization

Automation tools

Description du poste

The ISO Settlement Analyst II will perform day-to-day ISO settlement activities supporting MEMS’ power businesses, primarily in ERCOT. Responsibilities include reviewing settlement data, performing reconciliations, investigating discrepancies, supporting settlement disputes, and providing settlement information to Accounting and other internal teams. The position will also support process improvement and system implementation initiatives related to ISO settlements and may support other ISO/RTO markets as business needs evolve.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:

• Perform day-to-day ISO settlement activities, primarily for ERCOT, including the review of settlement statements, charges, fees, and other settlement-related data.
• Monitor and complete settlement activities across applicable settlement cycles, including Initial, Final, and True-up settlements.
• Reconcile ISO settlement data with ETRM and other relevant internal and external data sources.
• Identify and investigate settlement discrepancies, variances, and exceptions, and coordinate with relevant stakeholders as needed to resolve issues.
• Support the preparation, tracking, and resolution of ISO settlement disputes.
• Maintain settlement workpapers, reconciliations, supporting documentation, and other records related to settlement activities.
• Provide accurate and timely settlement data and supporting documentation to Accounting for monthly and quarterly financial close activities.
• Provide settlement information and related analysis to support collateral monitoring and other power business activities as needed.
• Coordinate with internal stakeholders, including Trading, ETRM, Risk Management, Credit, Accounting, and other relevant teams, on settlement and data-related matters.
• Coordinate with ISOs/RTOs, vendors, and other external parties as needed to obtain information and resolve settlement-related issues.
• Support settlement activities for other ISO/RTO markets, including PJM, as business needs evolve.
• Support improvements to settlement processes, reconciliations, and data flows to improve efficiency, accuracy, and consistency.
• Participate as a business user in the implementation and enhancement of Bid-to-Bill and other settlement-related systems and tools, including testing and data validation.
• Utilize Microsoft Excel and other available analytical tools to support settlement analysis, reconciliation, and process improvement.
• Support internal and external audit requests related to ISO settlement activities.
• Perform additional duties as assigned.

QUALIFICATIONS

• Strong analytical and numerical reasoning skills, with the ability to analyze, reconcile, and interpret complex, high-volume transactional data.
• Ability to independently perform recurring settlement activities while identifying exceptions and escalating significant issues appropriately.
• Strong problem-solving skills, including the ability to investigate settlement discrepancies, identify root causes, and coordinate resolution across multiple stakeholders and data sources.
• Strong attention to detail and ability to work accurately in a fast-paced environment with multiple deadlines and recurring settlement cycles.
• Ability to understand and work with ISO/RTO settlement statements, market data, transaction data, contracts, invoices, and related operational documentation.
• Advanced Microsoft Excel skills, including pivot tables, complex formulas, data reconciliation, and large data-set analysis.
• Experience with Power Query, SQL, data visualization, automation tools, or similar data-analysis technologies, preferred.
• Ability to understand end-to-end data flows and identify opportunities to improve settlement processes, controls, and automation.
• Strong verbal and written communication skills and the ability to work effectively with Trading, Risk Management, Credit, Accounting, IT/ETRM, and other internal and external stakeholders.

.

EDUCATION and/or EXPERIENCE

• At least 2 years of experience in ISO/RTO settlements, power market operations, energy trading operations, energy accounting, or a related analytical field.
• Experience with ETRM, ISO settlement, Bid-to-Bill, or other energy market systems preferred.
• Experience with data reconciliation, variance analysis, or other transaction-level analysis preferred.
• Bachelor’s degree in Accounting, Finance, Economics, Business, Energy, Data Analytics, or a related field.

LANGUAGE SKILLS:

Fluent verbal and written skills in English.

LICENCES, CERTIFICATES, REGISTRATIONS:

None

WORK ENVIRONMENT & PHYSICAL DEMANDS:

This job operates in a professional office environment and routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.

The role involves prolonged periods of sitting and may require routine movement around the office to communicate with different groups.

Disclaimer

This position description is not to be construed as an exhaustive statement of duties, responsibilities, or requirements. Employees may be required to perform any other job-related instructions as requested by their leader, subject to reasonable accommodation.

MEMS is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability.