Jobs
>
Ottawa

    Data Modeler - Ottawa, Canada - CGI

    CGI
    CGI Ottawa, Canada

    1 month ago

    CGI background
    Full time
    Description

    Position Description:

    Security clearance: Must be able to meet the requirements for obtaining a secret level clearance.

    Your future duties and responsibilities:

    Data Modeling and Database Design - Proficiency in conceptual, logical, and physical data modeling. Translate business requirements into comprehensive data models ensuring scalability, performance, and data integrity.
    Agile Methodology - Experience in collaborating within Agile Scrum teams. Translating business requirements into database designs that align with iterative development cycles.
    Communication and Collaboration - Ability to effectively communicate and collaborate with business analysts, developers, and other stakeholders. Facilitating discussions to gather requirements, articulate design decisions, and provide ongoing support to ensure alignment with project goals.
    Technology - proficiency and experience with data modelling tools (ER/Studio, ERWin) for common RDBMS (Oracle, SQL Server) and schema management (Liquibase, Flyway).
    Problem-Solving and Adaptability - Strong problem-solving skills for addressing complex data modeling challenges and optimizing database structures for performance and scalability. The ability to adapt to evolving project requirements, technology advancements, and changing business needs within a dynamic microservice environment.

    The Resource will be responsible for the following activities and deliverables:

    • Gather business requirements from key project stakeholders

    • Gather technical requirements from Support teams

    • Analyze all gathered requirements

    • Create Conceptual, Logical, and Physical Data Models, using ER/Studio Data Architect, following the Bank's Enterprise Data Architecture standard and industry best practice and standards

    • Establish Data Architecture based on gathered requirements

    • Maintain and support updates to Data Models and Data Architecture, throughout project lifecycle

    • Document design and build book for Data Models and Data Architecture

    • Complete Data Architecture portion of the Solution Architecture Document

    • Mentor and coach portfolio Data Modeler

    • Knowledgeable on data modelling foundational items such as security, logging, meta-data, etc.

    • Provide source and destination mappings and business transformations for ETL Specification/Design

    • Support and provide guidance to ETL Developer

    • Create and populate Data Dictionary to support and define data elements in data model

    • Identify common data elements that need to be setup for use by multiple stakeholders

    Required qualifications to be successful in this role:


    • Seven to ten years of demonstrated hands-on experience in building conceptual, logical, and physical data models, for projects ranging from 6 months to three years in duration

    • Five years of demonstrated hand-on experience in building data models for data warehouse solutions

    • Demonstrated experience in reverse-engineering of data models from COTS product

    • Oracle 12c and SQL Server

    • Experience in modeling data for Enterprise Java EE applications

    • Experience in modeling using ER/Studio Data Architect

    #LI-KM1

    Skills:

  • Data Modeling
  • English
  • ETL
  • J2EE
  • MS SQL Server
  • Oracle
  • French
  • CGI

    Data Modeler

    1 week ago

    CGI Ottawa, Canada Full time

    Position Description: · Security clearance: Must be able to meet the requirements for obtaining a reliability level clearance. · Your future duties and responsibilities: · " · •Assist with creation of Conceptual/Logical/Physical Models for data integration, analytics, and repor ...

  • Geofirma Engineering Ltd

    data modeler

    2 days ago

    Geofirma Engineering Ltd Ottawa, Canada Full time

    Work Term: Permanent · Work Language: English · Hours: 40 hours per week · Education: Earned doctorate degree · Experience: 1 year to less than 2 years · Work setting · Consulting firm · Tasks · Conduct studies of groundwater flow and contamination · Develop models and applied so ...

  • Maplesoft Group

    Data Modeler

    3 weeks ago

    Maplesoft Group Ottawa, Canada

    Maplesoft implements TimeLive for Electronic time tracking. · Please view the demo below on how to enter and approve time. · Do you want to work in a dynamic environment where your contributions count? · At Maplesoft, we value the contributions of all our employees and contrac ...

  • TechInsights

    Data Modeler

    2 weeks ago

    TechInsights Ottawa, Canada

    **OUR STORY** · **THE OPPORTUNITY**: · The Data Modeler will be reporting to the Manager, Data and working within an Agile scrum team. The Data Modeler will be closely collaborating with internal customers to define and implement structured data systems, ETL flows, and Business I ...

  • CGI

    Data Modeler

    1 week ago

    CGI Ottawa, Canada

    Security clearance: Must be able to meet the requirements for obtaining a secret level clearance. · **Together, as owners, let's turn meaningful insights into action.** · Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential b ...

  • Geofirma Engineering Ltd

    Data Modeler

    4 days ago

    Geofirma Engineering Ltd Ottawa, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 40 hours per week · - Education: Earned doctorate degree · - Experience: 1 year to less than 2 years · **Work setting**: · - Consulting firm · **Tasks**: · - Conduct studies of groundwater flow and contamination · - Devel ...

  • Geofirma Engineering Ltd

    Data Modeler

    3 weeks ago

    Geofirma Engineering Ltd Ottawa, Canada

    Work Term: Permanent · - Work Language: English · - Hours: 40 hours per week · - Education: Earned doctorate degree · - Experience: 1 year to less than 2 years · **Work setting**: · - Consulting firm · **Tasks**: · - Conduct business and technical studies · - Research, evaluate a ...

  • S.i. Systems

    Senior Data Engineer to develop data connections and processes for data models within an existi

    4 weeks ago

    S.i. Systems Ottawa, Canada

    · Senior Data Engineer Job Description: · Our public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure. Our client is modernizing its IM/IT environment to support digital operation ...

  • Ciena Canada, Inc.

    Data Scientist, People

    5 days ago

    Ciena Canada, Inc. Ottawa, Canada Full time

    Ciena is committed to our people-first philosophy. Our teams enjoy a culture focused on prioritizing a personalized and flexible work environment that empowers an individual's passions, growth, wellbeing and belonging. We're a technology company that leads with our humanity—drivi ...

  • Adecco Canada

    Business System Analyst

    1 week ago

    Adecco Canada Ottawa, Canada Temporary/Contract

    Adecco is currently recruiting for a Business System Analyst for a 6-month Hybrid contract opportunity. This role is with our Crown corporation client in downtown Ottawa, ON. The successful candidate must be eligible for a Reliability clearance. · The Business System Analyst wil ...

  • Tomlinson Group of Companies

    Data Engineer

    3 weeks ago

    Tomlinson Group of Companies Ottawa, Canada

    As a Data Engineer at Tomlinson, you will play a crucial role in collaborating with the Data Architect and AI team to develop and implement data integration strategies, build data pipelines, perform data modeling, ensure data governance, and plan scalable solutions. You will work ...

  • Taggart Group of Companies

    Estimating Coordinator

    2 weeks ago

    Taggart Group of Companies Ottawa, Canada Full time

    Job Title: Estimating Coordinator · Reporting To: Director of Estimating · Company: Taggart Construction Limited · Location: Albion Road South, Ottawa · Taggart Group of Companies · A family business that's been around for more than years, the Taggart Group of Companies is a fu ...

  • CMHC - SCHL

    Internship, Junior Analyst, Modelling, Fall 2024

    3 days ago

    CMHC - SCHL Ottawa, Canada InternshipSHIP

    Job Requisition ID: 10252 · Position Status: Temporary Full Time · Position Type: Hybrid · Office Location: Ottawa (ON); Calgary (AB); Halifax (NS); Montreal (QC); Toronto (ON); Vancouver (BC) · Travel Requirement: Travel not required · Language Designation: English Essentia ...

  • Actalent

    AUTOSAR- Embedded Software Engineer

    1 week ago

    Actalent Ottawa, Canada Contract

    JOB DESCRIPTION Why Actalent? · Actalent is a global leader in engineering services and · talent solutions. Actalent partners with many Fortune companies in multiple · different industries. Benefits of working with Actalent are as follows: · • Actalent is an equal opportunity ...

  • Cisco

    Analog/mixed-signal IC Modeling Engineer

    3 days ago

    Cisco Ottawa, Canada

    Acacia designs intelligent transceivers using advanced signal processing and photonic integration for the 100G, 400G and 1T bit speed fiber optic transmission market deployed in data center, metro, long-haul and ultra-long haul telecommunication networks. · What you'll do: · As ...

  • Canada Post

    Gestionnaire, architecte des données

    2 weeks ago

    Canada Post Ottawa, Canada

    Numéro de la demande d'emploi : · Fonction administrative : Technologie de l'information · Ville principale : Ottawa · Emplacement(s) supplémentaire(s) : Toronto · Province : Ontario · Type d'emploi : Temps plein · Statut d'emploi : Permanent · Exigences linguistiques : An ...

  • Corel

    Senior BI Engineer

    3 weeks ago

    Corel Ottawa, Canada Regular Full time

    Push the boundaries of tech. In your sweatpants. · We're looking for an experienced BI Engineer to help us change the way the world works. Here, you'll have the opportunity to be creative with your data modelling while having strong engagement with a small yet key team of intern ...

  • 8084947 CANADA INCORPORATED

    database analyst

    5 days ago

    8084947 CANADA INCORPORATED Ottawa, Canada Plein temps

    Education: · Expérience: · Education · Bachelor's degree · Tasks · Design and develop database · Operate database management systems to analyze data · Develop and implement data administration policy, standards and models · Research and document data requirements, data collecti ...

  • Canada Post

    Manager, Data Architect

    2 weeks ago

    Canada Post Ottawa, Canada Permanent

    Job Description · Reporting to the Director, Enterprise Data Architect, the Manager, Data Architect is a skilled problem solver who can build and support data management frameworks and address data-related issues. · This individual plays a crucial role in shaping the data landsc ...

  • Canadian Blood Services

    Data Scientist

    3 weeks ago

    Canadian Blood Services Ottawa, Canada

    Please note this role will work in a hybrid environment. The successful candidate must be located near a Canadian Blood Services site and will be working a mixture of on-site and off-site work based on the parameters for our operations to meet the needs of our donors, our staff a ...