Data Analyst and Database Expert

2 days ago


Fredericton, New Brunswick, Canada BMO Financial Group Full time

Company Overview

BMO Financial Group is an innovative company driven by a shared purpose: to empower individuals and businesses through financial services. Our team members are passionate about creating lasting, positive change for our customers, communities, and people. By working together, innovating, and pushing boundaries, we transform lives and businesses around the world.

We value our contract workers as integral members of our team, offering them respect, recognition, and opportunities for growth and impact. We strive to help them make an immediate difference from day one – for themselves and our customers.

Job Description

We are currently seeking a highly skilled Oracle DBA professional on a 10-month contract to join our established institution and work with multiple groups within BMO.

This role offers a unique opportunity to build effective skills and confidence, exposing you to various lines of business and providing ample opportunities for learning, growth, and development. You will have access to a dynamic work environment with a great culture and global presence.

The key responsibilities of this position include:

  • Performing data analysis and maintenance activities to proactively address the bank's needs for identifying, classifying, modeling, storing, and accessing information;
  • Understanding data in terms of its business and technical lifecycle (Create, Release, Update, and Delete), technical underpinnings of database theories (e.g., structured, unstructured), and various data modelling concepts in both the logical and physical domains;
  • Administering and documenting data backup and recovery plans, capacity plans, and security plans;
  • Assisting in planning and participating in tests for new products and data technology releases to ensure features and functions are acceptable and integrated across systems, software, and platforms;
  • Proactively investigating and troubleshooting database, technical, and systems problems, directing corrective action;
  • Identifying and recommending process or system changes to avoid issues/problems;
  • Recommending and implementing solutions based on analysis of issues and implications for the business;
  • Identifying emerging issues and trends to inform decision-making;
  • Leading/conducting detailed data design reviews and providing feedback in a constructive manner;
  • Performing complex technical, analytical, and professional services involving program/member services, evaluation, database-driven Web sites, office operations;
  • Designing and implementing methods to store, organize, and present data, as well as automating data operations;
  • Interacting with key stakeholders to define, analyze, and deliver requirements that reflect the needs of both the business and end-customers;
  • Decomposing business requirements and translating them into detailed data design specifications;
  • Designing and implementing maintenance/backup plans to keep databases in optimal conditions to minimize potential customer data errors and loss;
  • Designing and implementing security measures for databases;
  • Building 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;
  • Identifying opportunities to strengthen the capability of the technology organization at BMO, such as sharing expertise to promote technical development, mentoring employees, building communities of practice and networks across technology;
  • Staying abreast of industry technical and business trends through participation in professional associations, practice communities & individual learning;
  • Focusing primarily on business/groups within BMO, may have broader, enterprise-wide focus;
  • Providing specialized consulting, analytical, and technical support;
  • Exercising judgment to identify, diagnose, and solve problems within given rules;
  • Working independently and regularly handling non-routine situations;
  • Broad work or accountabilities may be assigned as needed.

Qualifications and Requirements

We are looking for a highly experienced Database Administrator with a strong background in Oracle, SQL, and MySQL. The ideal candidate should have at least 5 years of experience in Database Administration, with a proven track record of delivering high-quality results and driving business outcomes.

The estimated salary for this position is $120,000 - $150,000 per year, depending on your level of experience and qualifications. This figure is based on national averages and market rates for similar positions in the industry.

About the BMO Contractor Talent Network

BMO is committed to creating an inclusive, equitable, and accessible workplace where everyone feels valued and empowered to contribute their best work. As part of our contractor talent network, you'll have access to exclusive job opportunities, career development resources, and a supportive community of professionals who share your values and goals.


  • Business Analyst

    3 weeks ago


    Fredericton, New Brunswick, Canada East Coast Dental Group Full time

    We are looking for a Business Analyst to join our company. As a Business Analyst, you will be responsible for analyzing business needs and developing solutions to meet those needs. Your primary focus will be on data insights, ensuring that our business operations are data-driven and informed by accurate insights.This is a great opportunity for someone who is...

  • Business Analyst

    2 weeks ago


    Fredericton, New Brunswick, Canada GJLC2 FOOD SERVICES INC Full time

    We are seeking a skilled Business Analyst - Data Insights to join our team. The ideal candidate will have a strong analytical mindset and excellent communication skills.Key responsibilities include:Collaborating with cross-functional teams to identify business needsDeveloping and maintaining data visualizations and reportsProviding data-driven insights to...


  • Fredericton, New Brunswick, Canada IVARI Full time

    Job Title: Business Systems Analyst - Life Insurance Domain ExpertAbout the Role:As a Business Systems Analyst at IVARI, you will utilize your expertise in Life Insurance domain knowledge, analytical skills, and requirement gathering techniques to understand business needs and elicit, analyze, document, and communicate business and system requirements for...


  • Fredericton, New Brunswick, Canada IVARI Full time

    Job SummaryIVARI is seeking a highly skilled Business Systems Analyst to join our team. As a Business Systems Analyst, you will be responsible for utilizing your knowledge of the Life Insurance domain, analytical skills, and requirement gathering techniques to understand business needs and elicit, analyze, document, and communicate business and system...


  • Fredericton, New Brunswick, Canada BMO Financial Group Full time

    About the RoleBMO Financial Group is seeking a highly skilled Senior Database Administrator to join our team. This is a 10-month contract opportunity.ResponsibilitiesAs a Senior Database Administrator, you will be responsible for performing data analysis and maintenance activities to proactively address the Bank's needs for the identification,...


  • Fredericton, New Brunswick, Canada SUN PHARMA Full time

    Job SummarySun Pharma is seeking a highly skilled Quality Assurance Data Analyst to join our team. As a key member of our Quality Assurance department, you will be responsible for performing critical in-depth reviews of scientific data for Quality Control laboratory documents.Key ResponsibilitiesConduct thorough reviews of raw data from in-process,...

  • Data Analyst

    1 week ago


    Fredericton, New Brunswick, Canada BBD Insights Inc.] Full time

    h1, h2, h3 {color: #00698f;} p {font-size: 14px;}Job Title: Data EngineerJob DescriptionBBD Insights Inc. is seeking a skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data systems.Key Responsibilities:Design and implement data pipelines and architecturesDevelop and...

  • Culinary Expert

    4 weeks ago


    Fredericton, New Brunswick, Canada Jack's Pizza and donair Full time

    Culinary Expert Job DescriptionAt Jack's Pizza and donair, we are seeking a skilled Culinary Expert to join our team. The ideal candidate will have a strong background in cooking and kitchen management, with the ability to plan menus, estimate food requirements, and train staff in food preparation and handling.Key Responsibilities:Plan and implement menus,...


  • Fredericton, New Brunswick, Canada Meridia Recruitment Solutions Full time

    Job Summary:We are seeking an experienced Industrial Automation and Cybersecurity Expert to join our team at Meridia Recruitment Solutions. This role is responsible for administering and maintaining the refinery process control and automation systems.About the Role:The successful candidate will be responsible for working with various groups to keep the...


  • Fredericton, New Brunswick, Canada BMO Financial Group Full time

    At BMO Financial Group, we're driven by a shared Purpose: Boldly Grow the Good in business and life. As a contract worker on our team, you'll be valued, respected, and heard, with opportunities to grow and make an impact.BMO Capital Markets Technology is seeking an experienced developer to join our project team for a 12-month contract. You will play a...


  • Fredericton, New Brunswick, Canada IVARI Full time

    Job Title: Business Systems AnalystAbout the Role:As a Business Systems Analyst at IVARI, you will play a key role in understanding the business needs of our organization and developing solutions to support our external websites and internal web applications. You will work closely with our Enterprise Web Services team to provide end-to-end support through...

  • Marketing Expert

    3 weeks ago


    Fredericton, New Brunswick, Canada Pur&Simple Restaurant Full time

    We are seeking a Marketing Expert to join our team at Pur&Simple Restaurant. The ideal candidate will have a Bachelor's degree and 3-4 years of experience in marketing.Key ResponsibilitiesConduct market research and analyze data to inform marketing strategiesDevelop and implement promotional campaigns to increase brand awareness and drive salesCollaborate...


  • Fredericton, New Brunswick, Canada Meridia Recruitment Solutions Full time

    Business Valuation ExpertMeridia Recruitment Solutions is seeking an experienced Business Valuation Expert to join our client's team in Saint John.Ocean Capital Holdings Limited is a privately held company with interests in broadcasting, real-estate, construction, industrial distribution, and service. Their purpose is to have winning businesses and great...


  • Fredericton, New Brunswick, Canada Equest Full time

    We are seeking a skilled Clinical Business Analyst to join our team at Equest. This role involves leveraging expertise in hospital processes and patient health data to work closely with clinical and medical providers, supporting patient care delivery.Role OverviewThe Senior Clinical Business Analyst will be responsible for capturing requirements and aligning...


  • Fredericton, New Brunswick, Canada Mariner Full time

    Mariner is seeking a skilled Oracle APEX Developer to design, develop, and implement applications using the Oracle Application Express (APEX) platform. The ideal candidate will have a strong understanding of Oracle databases and APEX development and be adept at creating efficient and scalable solutions tailored to business needs.Key Responsibilities:Design...


  • Fredericton, New Brunswick, Canada CB Canada Full time

    Job Summary:CB Canada is seeking a skilled professional to join our team as a International Trade Data Specialist. In this role, you will be responsible for obtaining customer broker information on shipments coming into Canada by performing searches in various sources.Key Responsibilities:Search contact databases for broker information on file.Obtain phone...


  • Fredericton, New Brunswick, Canada Hart Stores Full time

    Job Title: Retail Sales Associate - Cash Handling ExpertJob Summary:Hart Stores is seeking a detail-oriented Retail Sales Associate - Cash Handling Expert to join our team. As a key member of our sales floor team, you will be responsible for providing exceptional customer service, operating a cash register, and maintaining accurate inventory records.Key...


  • Fredericton, New Brunswick, Canada BMO Financial Group Full time

    Job DescriptionBMO Financial Group is seeking a highly skilled Business Process Analyst to join their team on a 6-month contract basis.This is a collaborative, fast-paced, and friendly role within the Mutual Funds Governance and Retail Investments Process team.Define, develop, and monitor metrics and KPIs for Investments projects and processes across all...


  • Fredericton, New Brunswick, Canada CCH Incorporated Full time

    Job Title: Senior Financial Planning AnalystJob Summary:We are seeking an experienced Senior Financial Planning Analyst to join our team at CCH Incorporated. The ideal candidate will have a strong background in financial planning and analysis, with the ability to communicate complex financial information to all levels of the organization.Key...


  • Fredericton, New Brunswick, Canada Global Pharma Tek Full time

    Job Title: Senior Full Stack Developer - PWA ExpertThe role of a Senior Full Stack Developer at Global Pharma Tek involves working on complex problems, proposing alternative solutions, and breaking them down into workable tasks. The ideal candidate should have a strong understanding of front-end development using React JS framework, Node JS, Next JS, Svelte,...