Global Banking and Markets
Global Banking and Markets (GBM) conducts the Bank’s wholesale banking and capital markets business with corporate, government and institutional investor clients. GBM is a full-service wholesale bank and investment dealer in Canada and Mexico and offers a range of products and services in the U.S., Latin America and in select markets in Europe and Asia-Pacific.
More specifically, GBM provides clients with: corporate lending; transaction banking (including payments, trade finance and cash management); investment banking (including corporate finance and mergers & acquisitions); fixed income and equity underwriting, sales, trading and research; prime services (prime brokerage and stock lending); foreign exchange sales and trading; commodity derivatives; and collateral management.
Purpose:
The Analyst, Data Engineering & BI (Business Intelligence) Developer is part of the Client Insights & Analytics team within Global Banking and Markets. The role supports business strategy and decision-making by delivering end-to-end data and reporting solutions, including data modeling, data pipeline automation, and dashboard development.
This position bridges business intelligence and data engineering, translating business needs into scalable data solutions and actionable insights that enhance reporting, client strategy, and business performance.
What You’ll Do:
Data Engineering & Data Modeling
- Design, build, and maintain data pipelines to efficiently extract, transform, and load (ETL / ELT) data
- Develop and maintain robust data models to support analytics and reporting, ensuring consistency and reliability
- Perform data extraction, transformation, and mapping across multiple systems and large datasets
- Contribute to the development of analytical tools, models, and reusable data assets
Data Quality, Governance & Process Improvement
- Validate, reconcile, and monitor data across systems to ensure accuracy and integrity
- Investigate and resolve data discrepancies in collaboration with cross-functional teams
- Drive improvements in data processes, controls, and automation
- Apply best practices in data governance, transformation, and modeling
Business Intelligence & Reporting Delivery
- Design, develop, and maintain Power BI dashboards and reports to provide actionable insights to stakeholders
- Translate business requirements into scalable reporting and analytics solutions that support decision-making
- Conduct quantitative and qualitative analysis, interpre