Data Analyst and Database Expert

1 month 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.

  • Data Engineer

    2 weeks ago

    Fredericton, New Brunswick, Canada NeenOpal Inc. Full time

    At NeenOpal Canada Inc., we are seeking a highly skilled Data Engineer to design, develop, and maintain scalable data pipelines and ETL processes.About the RoleThis is an exciting opportunity for a motivated professional to join our global Business Analytics teams and support the implementation of data warehouse solutions tailored to client needs.Key...

  • Data Engineering Specialist

    2 weeks ago

    Fredericton, New Brunswick, Canada NeenOpal Inc. Full time

    Job OverviewNeenOpal Canada Inc. is a leading company in data analytics solutions, seeking an experienced Data Engineer to design, develop, and maintain scalable data pipelines and ETL processes.About the RoleThis is an exciting opportunity for a skilled Data Engineer to collaborate closely with our global Business Analytics teams to support the...

  • Hydrographic Data Processing Expert

    3 weeks ago

    Fredericton, New Brunswick, Canada Teledyne Technologies Inc. Full time

    Unlock your career potential as a Hydrographic Technical Support Consultant at Teledyne Technologies Incorporated.Company OverviewTeledyne Technologies Incorporated is a leading provider of enabling technologies for industrial growth markets that require advanced technology and high reliability. Our expertise spans across aerospace and defense, factory...

  • Business Systems Analyst

    4 days ago

    Fredericton, New Brunswick, Canada ALLTECH CONSULTING SVC INC Full time

    Job Summary:We are seeking an experienced Business Systems Analyst to join our team at Alltech Consulting SVC Inc. This is a unique opportunity to work with a high level of self-direction, strong interpersonal skills, and the ability to confidently engage and collaborate with project team members, subject matter experts, and stakeholders at all levels.About...

  • Data Insights Director

    3 weeks ago

    Fredericton, New Brunswick, Canada New Brunswick Liquor Co Full time

    Senior Business AnalystAbout the Role:The ideal candidate will lead our data insights team in developing reporting and presentations that uncover valuable business information. This strategic partner will contribute to business planning, drive operational effectiveness, and inform decision-making across the organization.About You:A minimum of six years of...

  • Data Integration Specialist

    2 weeks ago

    Fredericton, New Brunswick, Canada iLobby® Facility & Visitor Management Full time

    iLobby ® Facility & Visitor Management is seeking a highly motivated and detail-oriented Data Analyst to join our team for a 6-month contract role, with potential to become a permanent position.About the RoleThis opportunity requires a combination of manual data work and the ability to propose innovative solutions for data integration. The ideal candidate...

  • Senior GIS Analyst

    2 weeks ago

    Fredericton, New Brunswick, Canada Tree Nurseries Full time

    OverviewIrving Woodlands, a leading forestry company, is seeking a highly skilled Senior GIS Analyst to join its team in Eastern Canada or the state of Maine.

  • Business Systems Analyst

    3 weeks ago

    Fredericton, New Brunswick, Canada IVARI Full time

    Welcome to ivari, a leading Canadian life insurance company that's making a difference in the world. We're passionate about helping people protect their families and give them the best workplace possible.As a Business Systems Analyst at ivari, you will utilize your analytical skills and expertise in the Life Insurance domain to understand business needs,...

  • Polarion Expert: Software Development Specialist

    2 weeks ago

    Fredericton, New Brunswick, Canada L&T Technology Services Full time

    About L&T Technology ServicesWe are a global leader in the technology and engineering services space, with a strong presence in the digital transformation segment. Our team of experts is passionate about delivering cutting-edge solutions that drive business value for our clients.Job OverviewWe are seeking an experienced Polarion Expert to join our team in...

  • Automotive Collision Estimation Expert

    1 week ago

    Fredericton, New Brunswick, Canada Carsrus Full time

    Job Title: Automotive Collision Estimation ExpertCarsrus is seeking a skilled and experienced Automotive Collision Estimation Expert to join our team. The ideal candidate will have a strong understanding of automotive collision estimating principles and software, with the ability to work accurately and efficiently in a fast-paced environment.About UsCarsrus...

  • Senior Mineral Processing Expert

    2 days ago

    Fredericton, New Brunswick, Canada Woodgrove Technologies Inc. Full time

    Unlocking Efficiency in Global Mining OperationsWoodgrove Technologies Inc. is seeking a highly experienced Senior Mineral Processing Expert to join our team. As a key player in optimizing flotation circuits, conducting pilot plant studies globally, and providing expert metallurgical support during onsite commissioning, you will play a leadership role in...

  • Enterprise Onboarding Expert

    3 weeks ago

    Fredericton, New Brunswick, Canada iLobby® Facility & Visitor Management Full time

    About iLobby Visitor ManagementiLobby is the global leader in enterprise visitor management software, providing a cutting-edge platform that enhances day-to-day operations for major governments, banks, airports, manufacturers, and Fortune 500 companies worldwide.We help clients succeed in tracking, managing, and monitoring who is in their building – while...

  • Hydrographic Data Specialist

    4 days ago

    Fredericton, New Brunswick, Canada Teledyne Technologies Inc. Full time

    Job DescriptionTeledyne Technologies Incorporated is a leading provider of enabling technologies for industrial growth markets. We are seeking a Hydrographic Technical Support Consultant to join our CARIS Team in Canada.About the RoleThis position involves providing first-line technical support to customers, including email, phone, and online resources. The...

  • Software Development Expert

    2 weeks ago

    Fredericton, New Brunswick, Canada CMiC Full time

    About CMiCCMiC is a Toronto-based software company specializing in construction industry solutions. Our comprehensive platform empowers construction companies to manage their workflows efficiently.We offer both SaaS and Private Hosted platforms, featuring industry-focused modules for financials, payroll, project management, and budgeting. Our market presence...

  • Senior Real Estate Investment Financial Analyst

    2 days ago

    Fredericton, New Brunswick, Canada Avenu Properties Full time

    About Avenu Properties CorporationA distinguished leader in real estate investment and management, our company is based in Toronto, Ontario. Our dynamic portfolio encompasses a range of assets, from residential developments to income-generating properties, reflecting our commitment to excellence in modern real estate.Explore our diverse holdings, including...

  • Business Systems Specialist

    3 weeks ago

    Fredericton, New Brunswick, Canada ALLTECH CONSULTING SVC INC Full time

    Job Description:We are seeking a highly skilled Business Analyst to join our team at Alltech Consulting SVC Inc. This is an exciting opportunity for a motivated and experienced professional to work with our software development team, clients, and stakeholders to deliver high-quality solutions.Key Responsibilities:Support the software development team by...

  • Digital Marketing Strategist

    2 weeks ago

    Fredericton, New Brunswick, Canada Jewlr Full time

    Job Title: Digital Marketing Strategist - Paid Search ExpertAbout Jewlr:Jewlr is a leading online destination for personalized jewelry. Our mission is to create meaningful gifts and keepsakes for our customers.Job Description:We are seeking an experienced Digital Marketing Strategist to join our team. As a key member of our growth and performance marketing...

  • Senior Underwriting Expert

    3 weeks ago

    Fredericton, New Brunswick, Canada Equitable Life of Canada Full time

    Opportunity Overview"> We are seeking an experienced Senior Underwriting Consultant to join our team in Waterloo, ON.">About the Role"> This position is critical to Equitable's success and offers a great opportunity to work with one of Waterloo Region's Top Employers.">Key Responsibilities"> Apply strong and holistic underwriting expertise in all areas of...

  • Hydrographic Support Specialist

    4 days ago

    Fredericton, New Brunswick, Canada FLIR Systems, Inc. Full time

    We are seeking a skilled Hydrographic Support Specialist to join our team in Canada. As a technical expert in hydrographic data processing and analysis, you will be the primary point of contact for our customers, providing support via email, phone, and online resources.Key Responsibilities:Provide first-line technical support to customers, resolving issues...

  • Digital Product Manager, Wealth Solutions

    2 days ago

    Fredericton, New Brunswick, Canada Empire Life Full time

    Empire Life: A Career Opportunity in Wealth SolutionsWe are seeking a seasoned Digital Product Manager to join our Retail Investment Products & Marketing team at Empire Life. As a key member of our team, you will be responsible for cultivating market, competitor, and customer insights to inform strategies that drive the adoption and sales of our wealth...