Rainbow Energy Marketing Corporation has been engaged in the wholesale power marketing and trading business since 1994. Our company is growing, and we are looking to add a Senior Settlements Analyst to the team. Must be a self-starter, effective problem-solver, and able to work as a team player. Experience in Energy/Oil/Gas industry preferred but not required.
This position will be responsible for daily monitoring of ISO settlements, will ensure timely and accurate settlement of all physical and financial transactions related to power generation including Broker settlements, identify and resolve billing discrepancies and provide support for other activities. The successful candidate is expected to become a subject matter expert in the assigned power markets and in the business functional area. The incumbent will directly collaborate with team members, project groups, information technology and cross functional teams to support continuous process improvements and changing business needs.
o Identify any non-routine billings or unique agreements and develop processes for systematic reconciliation.
o Compare billing systems pricing information with contracts and amendments to ensure accuracy and completeness.
o Review completeness of monthly and other periodic billings.
o Contact counterparties to timely resolve billing discrepancies.
o Work and communicate with various internal groups to compile and analyze data, including Contract Administration, Front and Middle Offices, Accounting, Financial Reporting, Treasury, Credit, Information Technology (IT) and Legal
o Acting as a change agent to identify and implement process improvements to promote best practices
o Interface with auditors to provide information and support as requested
· Advanced fundamental Excel skills required
· Natural problem solver who welcomes and promotes change
· Strong verbal and written communication skills
· Motivated, self-directed, and results-driven approach to work, also takes ownership of assigned tasks.
· Personal commitment to integrity, achievement of departmental and business goals, and outstanding customer service
· Two or more years of progressive experience in energy/generation industry with a minimum of two years in settlements using an ETRM's and shadow settlement tools is preferred.
· Proficiency in Microsoft office with advanced Excel skills (Pivot tables, VLOOKUP, complex IF/THEN statements).
· Experience with multiple power markets (e.g., PJM and ERCOT) preferred
Pay Range: $80,000.00 to $87,500.00 per year/based on experience
Work Location: Bismarck, ND office (In person)