Contractual Excel Sql Jobs (NOW HIRING)

Invenergy is North America's largest privately held developer, owner, and operator of power infrastructure. With 25 years of trusted execution, we deliver reliable, affordable energy through a diverse portfolio that includes natural gas, solar, land-based wind, energy storage, transmission, and domestic manufacturing. Headquartered in Chicago, we develop, own, and operate large scale projects that power communities and support the energy future.

This position will be open for application for at least 3 calendar days from the posting date. This position will remain open for application based on business need, which may be before or after the 3-day posting window.

Position Overview

The Sr. Analyst, Thermal Settlements and Portfolio Analytics will be reporting to the Manager of Thermal Settlements and Portfolio Analytics. This role is uniquely positioned to leverage the juncture of Thermal Settlements, International Settlements and Risk Management. The role will support efforts to improve settlement and reporting for domestic and international assets. The Sr. Analyst will settle physical and financial energy commodity transactions for assigned thermal electricity generation projects while translating their knowledge of project transactions into relevant risk analyses. The Sr. Analyst will leverage their knowledge and experience to create reports, guide process improvements, and provide input to Risk-related initiatives, both domestic and international.

Responsibilities:

• Create and maintain Excel templates with validated power generation and price detail for energy customers and hedge counterparties in accordance with contractual provisions.

• Validate physical and financial transactions through our ETRM with counterparties on assigned thermal projects.

• Collaborate cross-functionally to improve the data integrity of our ETRM.

• Identify needs and implement steps to create and maintain reporting and tools visible to decision makers across the relevant company footprint.

• Identify and/or support process improvement and systems implementation initiatives relating to Settlements, Credit Risk, Market Risk, and Accounting best practices.

• Build and maintain inventory of international operating project processes with regards to risk management and settlements across all technologies and recommend and implement supporting and validating procedures to assist local teams.

• Accurately report to FERC, Statistics Canada, and MIRA as regulations require.

• Prepare ad-hoc forecasts and analyses as needed.

Minimum Qualifications:

• BA or BS in Economics, Mathematics, or related field.

• 2-4 years of relevant experience required, energy project settlement experience preferred.

• Energy industry experience. Understanding of energy commodity markets and regional power/independent system operators. Experience in a trading environment with an ETRM such as Allegro preferred.

• Excellent analytical, quantitative, and modelling skills with strong attention to detail and a demonstrated ability to develop models in Excel. SQL, Power BI, Copilot, and Databricks skills preferred.

Preferred Qualifications:

• Ability to work independently, exhibiting strong self-motivational habits, while also being able to coordinate projects across functional teams.

• Understanding of market risk analytics with gas and power trading activity.

• Strong communication, negotiation, and interpersonal skills.

• Ownership of and follow-through on commitments, with a demonstrated ability and desire to continuously improve.

• Excellent organizational skills and ability to prioritize effectively.

• Ability and desire to work in a fast-paced, entrepreneurial environment with tight timelines.

$62,000.00 - $82,000.00 USD Annual
Bonus: 15%

The base pay range reflects the minimum and maximum target salary for the position. Invenergy considers a number of factors when determining base pay offers such as the scope and responsibilities of the position and the candidate's experience, education and skills.
In addition to base pay, the total annual compensation package may also include eligibility to participate in our bonus program(s) which are designed to reward individual and company performance. Your recruiter can share more about bonus eligibility for this position during the hiring process.
Invenergy offers a variety of other benefits including medical, dental and vision insurance, 401k, paid time off, etc.

Invenergy LLC is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a protected veteran, or disability.