Application Deadline:
12/06/2026
Address:
100 King Street West
Job Family Group:
Data Analytics & Reporting
Come join Wealth Data Foundations as we transform how data is built, trusted and consumed, creating cloud-first, AI-ready foundations that unlock the next generation of Analytics and AI innovation & shape the future of Wealth data.
In this role, you will have the opportunity to work across DataOps, Data Governance, Analytics and business teams to design and deliver trusted Wealth data products. You will help turn business needs into scalable data solutions, improve the quality and usability of our data, and contribute to the cloud-first foundation enabling Analytics and AI across Wealth.
Key Accountabilities
Supports the design, development and curation of Gold datasets, pipelines and data products , including transformations, business rules, calculations and data requirements.
Defines and implements data quality rules, controls and validation checks for Data Foundations datasets and Gold data products.
Performs data profiling, validation and reconciliation to identify data completeness, accuracy, consistency and integrity issues.
Monitors data quality results and identifies exceptions, anomalies and control failures .
Manages data issues through identification, investigation, root-cause analysis, remediation and closure .
Works with DataOps, source-system teams and other stakeholders to resolve upstream and pipeline-related data issues.
Supports testing, release readiness and production validation of new and changed Gold datasets, pipelines and data products.
Develops and maintains metadata, lineage, data definitions, transformation rules, data mappings and data quality documentation .
Partners with Data Governance to operationalize applicable data standards within Wealth Data Foundations.
Works with Analytics and business teams to support the appropriate use and reuse of trusted Data Foundations products .
Identifies opportunities to improve data quality, controls, automation, standardization and reuse .
Focus is primarily on business/group within BMO; may have broader, enterprise-wide focus.
Exercises judgment to identify, diagnose and solve problems within given rules.
Works independently on a range of complex tasks, which may include unique situations.
Broader work or accountabilities within Wealth Data Foundations may be assigned as needed.
Takes measured risks while protecting the bank by applying the Risk Management Framework in the execution of the role, in line with the Risk Culture and approved Risk Appetite, making sound and risk-informed decisions that align to business strategy, protect assets and adhere to applicable policies, standards, procedures, laws and regulations.
Qualifications
Foundational level of proficiency
Data governance
Data privacy
Data security
Enterprise data management
Cloud data platforms
Data warehousing
Metadata and data lineage
Critical thinking
Systems thinking
Intermediate level of proficiency
SQL/Python and data analysis
Data curation and transformation
Data quality
Data profiling, validation and reconciliation
Data integration
Data modelling
Data issue management and root-cause analysis
Metadata management and data lineage
Business and data requirements analysis
Testing and quality assurance
Verbal & written communication skills
Collaboration & team skills
Analytical and problem-solving skills
Influence skills
Data-driven decision making
Typically between 4–6 years of relevant experience in data, technology, analytics or a related field or an equivalent combination of education and experience.
Technical proficiency gained through education and/or business experience.
Salary :
$55,500.00 - $120,000.00
Pay Type:
Salaried
The above represents BMO Financial Group’s pay range and type.
Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be…