2027 Winter - GRM, ALM Risk Data & Automation Analyst Intern (4 Months)

Job Description

What is the opportunity? Group Risk Management - Balance Sheet and Liquidity Risk (GRM-BSLR) provides independent second line oversight of all balance sheet and liquidity risks at the enterprise level. As a Co-op Student, you will work on the data engineering behind ALM risk reporting & analytics, and support the transformation of our risk practices – building and extending data pipelines, scripting away manual processes, automating data quality checks, and applying AI tooling to work that has traditionally been done by hand. What will you do? Contribute to the design, build, and optimization of ETL/ELT pipelines that ingest, transform, and consolidate ALM risk data from multiple sources into a centralized data platform Engineer validation logic in SQL and Python that reconciles risk data against source systems and pinpoints the root cause of discrepancies Convert ad-hoc checks into an automated, rule-driven data quality process with clear pass/fail reporting Apply AI-assisted tooling to accelerate pipeline development, validation, and documentation Move recurring data and reporting jobs onto a scheduler/orchestrator so they run and alert without manual intervention Monitor pipeline runs, resolve failures, and investigate data issues What do you need to succeed? Currently enrolled at a Canadian post-secondary institution in computer science, data science, financial engineering, mathematics, statistics, or a related quantitative discipline Exposure to ETL/ELT concepts and data transformation logic Python for data manipulation, pipeline scripting, and automation SQL and working knowledge of relational databases Familiarity with AI coding assistants (e.g., GitHub Copilot, Claude Code) Self-driven, comfortable with ambiguity, and able to communicate clearly with non-technical stakeholders Nice-to-have Cloud data warehouse experience (e.g., Snowflake) for querying and transforming large datasets Job scheduling or workflow orchestration (e.g., Airflow) fo