Use advanced Excel and SQL to support trade control operations as a Trade Control Analyst in Calgary, Alberta, with Capital Power. Validate transactions and strengthen daily controls.This permanent full time position supports Middle Office activities within Capital Power’s Commodity Risk Management framework. The analyst validates deals in the ETRM, reviews confirmations, maintains exception reporting, and checks data for settlement and risk purposes. The work includes audit support, workflow configuration, and automation using AI tools.Key Responsibilities:
Oversee daily deal checkout and validate ETRM transactionsReview and prepare bilateral transaction confirmationsMaintain audit logs and produce compliance exception reportsValidate data for settlement, invoicing,



and risk reportingDevelop, maintain, and execute Middle Office controlsRequirements:
Post-secondary education in business, finance, accounting, economics, audit, or riskOne to two years of relevant experience preferredExperience utilizing AI in solution generationAdvanced Microsoft Excel and intermediate SQL proficiencyExposure to ETRM systems and audit inquiries preferredApply trade validation, ETRM, Excel, SQL, and compliance skills to support accurate commodity trading controls at Capital Power.
J-18808-Ljbffr

📌 Trade Control Analyst Calgary Winnipeg
🏢 Capital Power
📍 Winnipeg