Analyst II - Treasury & Settlements

Mitsui & Co.; Houston (TX); On-site; USD 60,000 - 90,000; Full time

Job summary

MEMS is seeking an ISO Settlement Analyst II to manage day-to-day ISO settlement activities, primarily for ERCOT, reviewing statements, charges, and related data.

You will reconcile data with ETRM and other sources, investigate discrepancies, support disputes, and contribute to process improvements and system implementations across ISO markets.

Qualifications

• Strong analytical and numerical reasoning with high-volume data.
• Ability to perform recurring settlement activities and escalate issues.
• Proficient in data reconciliation and variance analysis.
• Advanced Excel and data-analysis tools experience.

Responsibilities

• Perform day-to-day ISO settlement activities, primarily for ERCOT, reviewing settlement statements, charges, fees, and 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 data sources.
• Investigate settlement discrepancies, variances, and exceptions; coordinate with stakeholders to resolve issues.
• Support preparation, tracking, and resolution of ISO settlement disputes.
• Maintain settlement workpapers, reconciliations, and related records.

Skills

Analytical thinking

Numerical reasoning

Attention to detail

Communication skills

Education

Bachelor’s degree in Accounting, Finance, Economics, Business, Energy, Data Analytics, or a related field

Tools

Microsoft Excel

Power Query

SQL

Job description

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.

LICENSES, 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.