Essential Duties / Responsibilities
- Lead and support the development of the models which support the strategic outcomes of the Regulated Go-To-Market team including the regulatory applications to the Alberta Utilities Commission that drive revenues exceeding C$1B annually.
- Support the development of robust models in support of financial planning and results for the Regulated Go-To-Market team including forecasting, scenario analysis, and decision implications including rate changes and rider calculations, as well as ongoing quality assurance and auditing of the revenue models.
- Directly support the development of regulatory applications including modelling of various forecast assumptions, responses to information requests, development of compliance filings, drafting and editing.
- Coordinate monthly regulated gas and electricity rate calculations approvals on behalf of the Regulated Go-To-Market team related to the Gas Cost Flow-through Rate (GCFR) and Rate of Last Resort (RoLR).
- Develop and present written material such as reports and PowerPoint presentations to explain and support analysis, recommendations, and outcomes, including as a witness during regulatory proceedings and hearings.
- Work closely with Finance and Operations teams to undertake monthly review and analysis of actual revenues and costs in comparison to the applied for or approved revenues and costs and analyze impacts to economic profit.
- Develop ad hoc and emergent business decision support analysis, modelling expertise and recommendations in support of the Regulated and, as necessary, Competitive Go-To-Market teams.
Working Conditions :
Open office environment.Ability to work from home while remaining effective and productive.Some overtime required as special projects arise.Some travel may be required.Minimum Requirements :
University degree in Finance, Accounting, Computer Science, Mathematics, Economics, Business or related discipline.Minimum 5 years of experience in a combination of financial analysis, business, operational effectiveness or related field.Proficiency with analytical tools with Excel (advanced functions, Power Query, Power Pivot).Advanced proficiency in managing and analyzing large datasets.Experience with data warehousing, large-scale data processing, and analytics, with exposure to machine learning techniques and their application in business decision-making.Preferred Qualifications :
Preference for candidates with experience within the energy industry, ideally in customer operations, finance, accounting, and / or commercial areas.Understanding of the Alberta regulatory utility industry.Knowledge of the Alberta retail natural gas and electricity market.Experience with Python, R, or comparable languages.Additional Knowledge, Skills and Abilities :
Superior analytical and financial modeling experience, including forecasting, scenario analysis, sensitivity modeling and ability to pass on these skills to team members. Skill test will be a requirement of the recruitment process.Strong ability to break down complex, ambiguous problems into structured analyses.Ability to work independently with minimal direction.Demonstrated problem solving skills with a high level of attention to detail and commitment to data accuracy.Ability to provide influence and direction to individuals at or above one’s level.Ability to translate technical findings into clear business recommendations.Excellent communication skills (written and verbal) and ability to present confidently to wide-ranging audience including leadership and external stakeholders.Ability to build dashboards and visualization using tools like PowerBI or similar platforms.Ability to excel in a fast paced, changing environment; effectively managing multiple activities and meeting deadlines.Strong capabilities in Word and PowerPoint.Demonstrate a strong commitment to continuous learning and process improvement.Ability to query data using tools such as SQL, Databricks, Snowflake, or similar data platforms.Experience working with AI tools and platforms is a plus.Physical Requirements :
Ability to work at a computer for long hours.