Database Analyst

BMO•Toronto, ON

6d•CA$50,100 - CA$93,000•Onsite

About The Position

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.

Requirements

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
Typically between 3 - 5 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
Specialized knowledge from education and/or business experience.

Nice To Haves

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.

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.