Leads/conducts detailed data design-reviews and provides feedback in a constructive manner.
Performs data analysis and maintenance activities to proactively address the Bank’s needs for the identification, classification, modeling, storing, and accessing of information.
Understands data in terms of its business and technical lifecycle (CRUD), technical underpinnings of database theories (e.g. structured, unstructured), and various data modelling concepts in both the logical and physical domains.
Assists in creation, implementation/installation, configuration, change, and support of data models, databases, data marts, data warehouses. Administers and documents data backup and recovery plans, capacity plans and security plans.
Assists in planning and participates in tests for new products and data technology releases to ensure features and functions are acceptable and integrated across systems software and platforms.
Proactively investigates/troubleshoots database, technical and systems problems and directs/assures corrective action. Identifies and recommends process or system changes to avoid issues/problems. 24x7 duty may be required.
Performs complex technical, analytical and professional services involving program/member services, evaluation, database-driven Web sites, office operations.
Designs and implements methods to store, organize, and present data as well as automating data operations.
Interacts with key stakeholders to define, analyze, and deliver requirements that reflect the needs of both the business and end-customers
Decomposes business requirements and translates them into detailed data design specifications.
Designs and implements maintenance/backup plans to keep databases in optimal conditions to minimize potential customer data errors and loss.
Adheres to the corporate data standards and guidelines as well as Enterprise Architecture Standards.
Designs and implements security measures for databases.
Builds data solutions that utilize the enterprise monitoring/logging, and require minimal to zero maintenance, or programmer, DBA, or Operations intervention to perform standard business maintenance / configuration
Contributes to project management activities following BMO’s project management methodology and practices.
Manages resolution of problems and escalate as required.
Confirms timely and accurate escalation, within the FRFI, of material issues.
Embraces and promotes new processes and methodologies, including emerging technologies and agile as required, with the flexibility to align to the unique requirements of the project teams and deliverables.
Supports the execution of key improvement initiatives using data-driven insights to deliver positive financial and customer outcomes
Develops, recommends, and employs productivity aids in all aspects of assignments to accelerate delivery.
Anticipates and reduces complexity for others.
Understands the scope of complexity that exists across business value, technology, and interaction models.
Identifies opportunities to strengthen the capability at BMO, such as: sharing expertise to promote technical development, mentoring employees, building communities of practice and networks across technology.
Stays abreast of industry technical and business trends through benchmarking and/or participation in professional associations.