Senior Analyst, Balance Sheet Strategy (12 Month Term)

ATB

Calgary

Hybrid

CAD 90,000 - 120,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work arrangement

Job summary

ATB in Calgary is seeking a Senior Analyst, Balance Sheet Strategy to transform complex data into actionable insights that inform balance sheet decisions. You will apply modelling techniques and data analytics to understand client and product behaviours and support related process improvements.

You will extract, clean, and analyze large datasets with SQL and Python, contribute to model governance, and deliver stakeholder-ready insights across treasury initiatives.

Qualifications

  • An undergraduate degree in Finance, Economics, Business, Statistics, or related quantitative field.
  • Pursuing CFA or FRM is considered a strong asset.

Responsibilities

  • Extract, clean, and synthesize large datasets using SQL.
  • Support modelling of loans and deposits with Python.
  • Ensure model governance and validation with MR/MRM processes.
  • Perform ad-hoc data analyses for downstream users.

Skills

SQL
Python
Data analysis
Stakeholder comm
Problem solving

Education

Undergraduate degree in Finance/Econ

Tools

Excel
Tableau

Job description

At ATB, we exist to make it possible for our clients, team members and communities. Our purpose is more than aspirational. It's a real commitment we live every day through our values (what we call the ATB ID).

Life at ATB is about more than work. In fact, we’re consistently recognized as one of Canada's top employers thanks to our high-care, high-performance culture, upheld by the three commitments we make to our team members:

Impact in action: No matter where you are in the organization, you're empowered to make an impact in the lives of our clients and communities.

Thrive together: We want you—the unique, authentic you—to feel safe and celebrated at work. We're on a continuous journey to build the most flexible and inclusive programs.

Ready for tomorrow: We want to enable your success through interesting and challenging work, performance enablement, and learning and development.

About the Role

As ATB’s next Senior Analyst, Balance Sheet Strategy, you will empower the Treasury Balance Sheet Strategy function by transforming complex data into actionable insights that drive key organizational decisions. This role plays an important part in ensuring that ATB's balance sheet position is sound through using modelling techniques and data analytics to understand client and product behaviours, as well as engaging in various process improvement projects. Additionally, this role supports industry research and targeted ad-hoc initiatives.

Accountabilities
Behavioural Modelling & Data Analysis
  • Complex Data Management: Extract, clean, and synthesize large, complex datasets from multiple internal and external sources using advanced SQL.
  • Modelling Support: Support the team in the execution, review, and ongoing maintenance of behavioural models for loans and deposits using advanced SQL and Python scripts. Perform regular model maintenance and monitoring to ensure ongoing accuracy and performance.
  • Model Maintenance & Governance: Partner closely with the Model Risk Management team on the validation process and ensure compliance with governance standards.
  • Ad-Hoc Quantitative Support: Perform targeted, ad-hoc data analysis as requested by the downstream model users.
Industry Research & Reporting
  • Metric Tracking: Gather and synthesize data from financial and management reports to track banking industry trends and peer performance. Monitor and evaluate key financial performance metrics, applying banking knowledge to understand broader market movements.
  • Stakeholder Insights: Aggregate complex financial data into clear summaries, collaborating with the team to communicate actionable insights to stakeholders.
Balance Sheet Strategy, Operations & Ad-Hoc Analysis
  • Data Quality & Independent Troubleshooting: Proactively identify data quality issues or anomalies, troubleshoot root causes, and independently execute data fixes to ensure reliable outputs.
  • Strategic Deep-Dives: Perform comprehensive ad-hoc analysis to support overarching balance sheet strategy and optimization initiatives.
  • Operational Efficiency: Continuously evaluate routine workflows and technical processes to identify opportunities for model enhancement and operational automation.
Knowledge, Skills and Experience
Accreditations:
  • An undergraduate degree in Finance, Economics, Business, Statistics, or a related quantitative field.
  • Possess or actively working towards a relevant financial professional designation (e.g., CFA, FRM) is considered a strong asset.
Core Skills & Experience:
  • 2-3 years of professional experience in a financial modelling, data analytics, risk management, or Treasury role.
  • Strong proficiency in SQL and Python (and/or similar programming languages) for complex data extraction, wrangling, and modelling support.
  • A strong understanding of a financial institution’s core product offerings, performance drivers, and broader strategic or regulatory issues.
  • A solid understanding of broader macroeconomic trends (e.g., interest rate cycles, inflation) and their direct implications on the banking sector and balance sheet performance.
  • Familiarity with core Treasury methods and practices, including Asset Liability Management (ALM), Interest Rate Risk (IRR) management, and liquidity management. Specific familiarity with behavioural modelling concepts and assumptions within the context of Asset Liability Management is considered an asset.
Interpersonal Skills:
  • Ability to communicate effectively, both written and verbally, within a professional business environment.
  • Strong interpersonal skills with the ability to collaborate effectively with the team and clearly communicate technical data insights to broader stakeholders.
  • A self-starter mentality with the capability to independently investigate data anomalies, implement fixes, and continuously drive operational efficiency.
Additional Information
  • This is a temporary 12 month term opportunity.
  • This position has a hybrid work arrangement. On average, this means 2 days on-site per week. Please note that this is subject to change due to business priorities.
Don’t meet all the requirements on the list?

A resume only goes so far in expressing who you are and the unique perspectives you bring. If you believe your skills and experience align with the role—but you might not check all the boxes—we want to hear from you. We encourage candidates from all work backgrounds, equity-seeking communities and experience levels to apply. If you’re seeking a career where your drive, perspective and growth are celebrated, we want to hear from you.

We’re dedicated to building a workforce reflective of those within our communities, and a culture where our team members are equipped with what they need to succeed—their way. Part of creating an inclusive workplace is recognizing our role in advancing Truth and Reconciliation. We are committed to meeting and exceeding the standards set out in the Partnership Accreditation in Indigenous Relations program created by the Canadian Council for Indigenous Business.

What happens next?

If you are shortlisted, you’ll hear from us after the posting closes. Check out our How We Hire page to learn more about our hiring process. If you need any accommodations throughout this process, please let us know at talentteam@atb.com

Stay in touch

We’re excited that you’re interested in a career with ATB. Follow us on LinkedIn, Facebook and Instagram to learn more about what our team is up to.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Analyst, Balance Sheet Strategy (12 Month Term)
Senior Analyst, Balance Sheet Strategy (12 Month Term)

ATB • Edmonton

Hybrid
CAD 90,000 - 130,000
Hybrid work arrangement
Strategy Analyst, Enterprise Strategy
Strategy Analyst, Enterprise Strategy

ATB • Calgary

On-site
CAD 80,000 - 110,000
Strategy Analyst, Enterprise Strategy
Strategy Analyst, Enterprise Strategy

Culture Alberta • Calgary

On-site
CAD 75,000 - 95,000
Finance Systems Support Analyst, Finance Architecture
Finance Systems Support Analyst, Finance Architecture

ATB • Calgary

Hybrid
CAD 85,000 - 110,000
Finance Systems Support Analyst, Finance Architecture
Finance Systems Support Analyst, Finance Architecture

Culture Alberta • Edmonton

Hybrid
CAD 80,000 - 105,000
Finance Systems Support Analyst, Finance Architecture
Finance Systems Support Analyst, Finance Architecture

Culture Alberta • Calgary

Hybrid
CAD 90,000 - 120,000
Hybrid work arrangement
Credit Realization Manager
Credit Realization Manager

Avenue.io Inc. • Calgary

Hybrid
CAD 110,000 - 160,000
Internal Assurance Partner, Client Focus Centre
Internal Assurance Partner, Client Focus Centre

ATB • Calgary

Hybrid
CAD 110,000 - 140,000
Everyday Banking Advisor - Chestermere (12 Month Term)
Everyday Banking Advisor - Chestermere (12 Month Term)

ATB Financial • Chestermere

On-site
CAD 42,000 - 60,000
Analyst, Investment Research and Solutions
Analyst, Investment Research and Solutions

ATB Financial • Toronto

On-site
CAD 74,000 - 101,000