Data Business Analyst Lead

Final date to receive applications:11/06/2026

Address:

VIRTUAL(R)59 - REMOTE/TELETRAVAIL - ON - BMOJob Family Group:

Data Analytics & Reporting We are seeking an experienced Lead Data Business Analyst to support the BMO Global Asset Management (BMO GAM) business as part of the Investment Solutions and Delivery  this role, you will drive the end-to-end delivery of data-centric investment solutions, from requirements gathering and documentation through data analysis, testing, and final implementation, ensuring solutions enable accurate, timely, and fact-based investment and business decisions.

You will partner closely with Investment teams, Investment Operations, Risk, Compliance, Institutional Sales, Technology, Data Platform teams, external service providers and other business areas to translate business objectives into clear, testable data and solution requirements.

You will help ensure that delivered solutions satisfy approved business outcomes, data requirements, control expectations, and acceptance criteria.

You will also contribute to the strategy and roadmap for investment data quality, data modeling, reporting, and analytics, including clear documentation of data definitions, data lineage, and business processes across the investment data lifecycle.

Key Responsibilities:

Requirements Gathering & Documentation Leads requirements gathering sessions with Portfolio and/or Product Managers, Investment Operations, Risk, Compliance, Institutional Sales, Technology, and other stakeholders to understand business objectives, pain points, and data needs.

Translates business objectives into clear business requirements documents (BRDs), functional specifications, user stories, and acceptance criteria for investment solutions.

Documents current- and future-state business processes, data flows, control points, dependencies, and operational procedures, and keeps them up to date.

Maintain end-to-end traceability from approved business outcomes and requirements through data rules, solution design, test cases, defects, implementation evidence, and final business acceptance.

Assess proposed solutions against the underlying business objective and challenge approaches that do not adequately satisfy approved requirements.

Data Knowledge & Management Serves as a subject-matter expert on investment data, including securities, holdings, transactions, performance, benchmarks, reference data, and related investment datasets.

Develops and maintains source-to-target data mappings, data dictionaries, business rules, transformation requirements, and supporting data documentation.

Documents end-to-end data lineage from external and internal sources through to downstream reporting and analytics, supporting data governance, controls, and auditability.

Perform root-cause analysis of data discrepancies, process breaks, and control issues, working across business, operational, technical and vendor interests to determine underlying causes and appropriate remediation.

Analyzes, profiles, and reconciles data from multiple sources using SQL and Python to identify gaps, data quality issues, and root causes, enabling more efficient processes and streamlined reporting.

Structures data into multiple dimensions and granularities (e.g. products, positions, transactions) to support reporting and analytics.

Rationalizes legacy data sources, ensuring clear stewardship, proper documentation, reduction of technical debt, and alignment with modern data architecture principles.

Testing & Quality Assurance Plans and coordinates user acceptance testing (UAT), including test strategy, test scenarios, test cases, and test data, and obtains business sign-off prior to production release.

Validates data outputs against requirements and source systems and…