Capital Management Analyst - Hybrid: EC & RC Reporting

Socket.dev; Edmonton; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

ATB Financial in Canada is seeking a Capital Management Analyst to drive the monthly Economic Capital reporting and support Regulatory Capital. You will leverage Python and SQL to build models, maintain data pipelines, and create dashboards for executive decision-making.

The role involves cross-functional collaboration, data governance, and forecasting support, with a hybrid on-site schedule and exposure to Monte Carlo simulations.

Qualifications

• Bachelor’s degree in Business, Finance, Economics, Computer Science, Mathematics or related field; CFA/FRM/PRM designation is a strong asset.
• High proficiency in Python (Jupyterlab) and SQL (Google BigQuery) for data manipulation and financial modeling.
• Experience navigating cloud environments such as GCP and maintaining Google Sheet workbooks for reporting.
• Solid understanding of Finance, Banking, Capital Management, EC, EL, RC, and Monte Carlo simulations.
• Strong analytical skills to process large datasets, perform trend and sensitivity analysis, and document model outputs clearly.
• Attention to detail in validating data inputs from multiple sources into centralized EC reporting systems.

Responsibilities

• Manage the end-to-end monthly Economic Capital reporting lifecycle to ensure timely and accurate metrics for key stakeholders.
• Maintain data pipelines and execute modeling workflows to produce robust analytical insights across capital portfolios.
• Develop and maintain capital dashboards and executive reports to support strategic risk management and executive decision-making.
• Monitor credit quality, perform trend analysis, and track portfolio dynamics to support risk assessment and capital allocation.
• Partner with internal teams to integrate risk parameters and ensure comprehensive coverage of banking book exposure.
• Support data governance standards, promotion of validated data assets, and continuous optimization of reporting processes.
• Contribute to quarterly capital forecasts, annual budget preparation, and early warning signal analysis.

Skills

Python

SQL

BigQuery

Data analysis

GCP

Financial modeling

Monte Carlo simulations

Education

Bachelor’s degree in Business, Finance, Economics, Computer Science, Mathematics

CFA/FRM/PRM designation in progress

Tools

Google BigQuery

Google Cloud Platform (GCP)

JupyterLab

Google Sheets

Job description

ATB Financial in Canada is seeking a Capital Management Analyst to drive the monthly Economic Capital reporting and support Regulatory Capital. You will leverage Python and SQL to build models, maintain data pipelines, and create dashboards for executive decision-making.

The role involves cross-functional collaboration, data governance, and forecasting support, with a hybrid on-site schedule and exposure to Monte Carlo simulations.