Senior Revenue Data Foundations Analyst

BMO; Toronto; On-site; CAD 56,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Accident and life insurance

Retirement savings plans

Job summary

BMO Commercial Bank's Data Foundations team is seeking a data-savvy professional to maintain the accuracy and integrity of revenue data across Canada and the U.S. You will write SQL queries and Python scripts to reconcile data, investigate variances, and support automated data workflows that power reporting and decision-making.

This role offers exposure to financial data environments, governance, and collaboration with finance and analytics teams to improve data models and processing efficiency.

Qualifications

• Strong hands-on experience with SQL (required) – ability to query, join, and troubleshoot large datasets.
• Experience with Python (required) for data processing, automation, or scripting.
• Working knowledge of data reconciliation, data validation, or data quality processes.
• Basic understanding of accounting principles (revenue, GL, reconciliations).

Responsibilities

• Executes and supports end-to-end revenue data processes, including monthly reconciliation and investigation across multiple data sources.
• Performs data reconciliation between financial systems and internal data platforms, identifying variances and required adjustments.
• Writes and maintains SQL queries and Python scripts to extract, transform, validate, and reconcile data.
• Supports execution, monitoring, and troubleshooting of recurring data pipelines and batch processes.
• Collaborates with finance and business teams to validate outputs and resolve issues timely.
• Develops dashboards and reports to track reconciliation status and data quality.

Skills

SQL

Python

Data reconciliation

Data quality

Job description

BMO Commercial Bank's Data Foundations team is seeking a data-savvy professional to maintain the accuracy and integrity of revenue data across Canada and the U.S. You will write SQL queries and Python scripts to reconcile data, investigate variances, and support automated data workflows that power reporting and decision-making.

This role offers exposure to financial data environments, governance, and collaboration with finance and analytics teams to improve data models and processing efficiency.