Database Analyst, Winter 2027 (Co-op/Internship) - 8 months

Bank of Montreal; Toronto; On-site; CAD 45,000 - 100,000; Full time

Benefits offered by this job

Health insurance

Tuition reimbursement

Accident and life insurance

Retirement savings plans

Job summary

Bank of Montreal invites co-op/intern students to join its campus program, offering exposure to analytics platforms, data governance, and cloud/data engineering practices. You’ll participate in mentorship programs, engineering initiatives, and a networked campus community, with opportunities for real impact from day one.

Responsibilities focus on developing and scaling data platforms, ensuring data quality and security, and collaborating with stakeholders to drive data-driven outcomes within a

Qualifications

• Foundational level of proficiency: IT Operating Model.
• Building and managing relationships.
• Managing change.
• Negotiation and influencing.
• Critical thinking.
• Database / repository design.
• Database management.
• Data security and privacy control.
• System and technology integration.
• Data integration.
• Analytical Platforms.
• Systems thinking.
• Technology delivery management.
• Data Consumption Lifecycle.
• Verbal & written communication skills.
• Collaboration & team skills.
• Analytical and problem solving skills.
• As a full-time employee, we would require 3-5 years of experience, however as part of the BMO campus program, we are looking for motivated individuals with a strong desire to learn.
• Specialized knowledge from education and/or business experience.

Responsibilities

• Develops, maintains, and manages an analytics platform and core operations enabling the delivery of data products and data management processes.
• Ensures data storage and processing meets quality, traceability and security needs defined in data governance guidelines.
• Improves and scales operational data flows across different source and destination systems to meet data modeling, data science, machine learning requirements.
• Supports faster, safer cloud data migration process.
• Supports innovation of tools, methods and data structures to improve the management and protection of data.
• Manages all aspects of data platform operations including production support.
• Scales and standardizes data functions for cloud-based and/or on-premises platform.
• Builds and leads the production support function and associated processes for production issues, establishes a tiered support model, and manage escalations.
• Works with stakeholders to drive innovation and results through usage of the digital platform.
• Leverages platform tools to optimize campaigns and functionality.
• Establish processes and systems in collaboration with Data Management Tools and Enterprise Support teams to proactively monitor and alert all aspects of EDA's (Enterprise Data and Analytics) data platform and workflows Establish and evangelize operational best practices, frameworks, and processes across all aspects of data platform operations
• Focus may be on a business/group.
• Thinks creatively and proposes new solutions.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works mostly independently.
• Broader work or accountabilities may be assigned as needed.
• Take measured risks while protecting the bank by applying our Risk Management Framework in the execution of your role, in line with our Risk Culture and within our approved Risk Appetite, making sound and risk informed decisions that align to business strategy, protect assets, and adhere to applicable policy documents (Frameworks, Policies, Standards, Procedures and Supporting documents), laws and regulations.

Skills

IT Operating Model

Relationships

Change management

Negotiation

Critical thinking

DB design

DB management

Data security

System integration

Data integration

Analytics platforms

Systems thinking

Delivery management

Data lifecycle

Communication

Collaboration

Analytical skills

Experience expectations

Specialized knowledge

Job description

As a co-op/intern student at BMO, you will have the opportunity to be heard, keep growing and make a difference. You will be part of our campus program to gain the skills and knowledge needed to take on roles similar to the description listed below. Our student experience is designed to integrate you to the BMO team from day one by adding value in the work you do.

You will have the opportunity to participate in programs such as the Women in Technology Mentorship Program, BMO Social Squad student-led activities, BMO Academy corporate learning platform, and access to various Employee Resource Groups to further develop your network within BMO.

Interested in learning more about our campus program? Stay up-to-date with BMO Campus Recruitment by following us on Instagram @BMO_on_Campus and joining our LinkedIn group BMO Campus Recruiting & Early Talent.

Note: Only students currently enrolled in an academic program and returning to their studies will be considered for Co-op/Internship opportunities.

Student who recently graduated are invited to apply to our New Grad opportunities which are available at https://jobs.bmo.com/ca/en/new-grad

Responsibilities

• Develops, maintains, and manages an analytics platform and core operations enabling the delivery of data products and data management processes.
• Ensures data storage and processing meets quality, traceability and security needs defined in data governance guidelines.
• Improves and scales operational data flows across different source and destination systems to meet data modeling, data science, machine learning requirements.
• Supports faster, safer cloud data migration process.
• Supports innovation of tools, methods and data structures to improve the management and protection of data.
• Manages all aspects of data platform operations including production support.
• Scales and standardizes data functions for cloud-based and/or on-premises platform.
• Builds and leads the production support function and associated processes for production issues, establishes a tiered support model, and manage escalations.
• Works with stakeholders to drive innovation and results through usage of the digital platform.
• Leverages platform tools to optimize campaigns and functionality.
• Establish processes and systems in collaboration with Data Management Tools and Enterprise Support teams to proactively monitor and alert all aspects of EDA's (Enterprise Data and Analytics) data platform and workflows Establish and evangelize operational best practices, frameworks, and processes across all aspects of data platform operations
• Focus may be on a business/group.
• Thinks creatively and proposes new solutions.
• Exercises judgment to identify, diagnose, and solve problems within given rules.
• Works mostly independently.
• Broader work or accountabilities may be assigned as needed.
• Take measured risks while protecting the bank by applying our Risk Management Framework in the execution of your role, in line with our Risk Culture and within our approved Risk Appetite, making sound and risk informed decisions that align to business strategy, protect assets, and adhere to applicable policy documents (Frameworks, Policies, Standards, Procedures and Supporting documents), laws and regulations.

Qualifications

• Foundational level of proficiency: IT Operating Model.
• Building and managing relationships.
• Managing change.
• Negotiation and influencing.
• Critical thinking.
• Database / repository design.
• Database management.
• Data security and privacy control.
• System and technology integration.
• Data integration.
• Analytical Platforms.
• Systems thinking.
• Technology delivery management.
• Data Consumption Lifecycle.
• Verbal & written communication skills.
• Collaboration & team skills.
• Analytical and problem solving skills.
• As a full-time employee, we would require 3-5 years of experience, however as part of the BMO campus program, we are looking for motivated individuals with a strong desire to learn.
• Specialized knowledge from education and/or business experience.

Salary & Benefits

• Salary: $45,000.00 - $100,000.00
• Pay Type: Salaried
• Health insurance
• Tuition reimbursement
• Accident and life insurance
• Retirement savings plans

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.

BMO is a leading bank driven by a single purpose: to Boldly Grow the Good in business and life. Everywhere we do business, we’re focused on building, investing and transforming how we work to drive performance and continue growing the good.

Who we are We’re proud to be fueling growth and expanding possibilities for individuals, families and businesses. More than 12 million customers count on us for personal and commercial banking, wealth management and investment services. As the 8th largest bank in North America by assets, we provide personal and commercial banking, wealth management and investment services to more than 12 million customers. In Canada, the United States and across the globe, we’ll continue to build, invest and transform to drive performance that serves the good that grows.