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 pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.
BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards
About Us
At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.
As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.
To find out more visit us at https://jobs.bmo.com/ca/en.
BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.
Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.
