Commercial Structuring Analyst

Overview

Develop and maintain Excel/SQL models to analyze commercial pricing, margins, and risk.

Key Responsibilities

• data integrity
• process automation
• stakeholder interaction
• pricing engine
• gross margin
• analytical modeling

Tasks

-Build processes and checks to identify data integrity issues or leakage, and create resolution plans and address them -Create processes and reports to track certain post-sale commercial activities, such as Add/Delete, Material Adverse Change, etc -Interact with Sales, Supply, Load Forecasting, IT, and Risk (as needed) on in-depth cross functional investigation or research projects -Work closely with IT Systems / developers to ensure the calculation logic is accurately reflected in various automated pricing engines -Design / maintain / troubleshoot Gross Margin reporting and analytical models in Excel/SQL

Requirements

• bachelor's
• 2+ years
• excel
• vba
• sql
• problem solving

What You Bring

-Bachelor's Degree in a quantitative analysis or related field -2+ years of relevant wholesale or retail energy experience. -Strong Excel modelling and VBA skills, and Fluent in SQL querying / development -Strong business acumen, attention to detail, problem solving skills, and data-driven decision making capabilities Excellent written and verbal communication skills -Must be well-organized and comfortable working in a fast-paced work environment -Experience with developing advanced pricing/analytical models and risk management related to retail energy is a plus -Excellent analytical skills -Health and wellbeing tools and resources and more…

People Also Searched For

Benefits

-Performance based bonuses -Competitive Compensation -Comprehensive benefits package -Hybrid Working Model

About Just Energy

-

Sector Specialisms