Data Modeler

3 weeks ago

Ottawa, Canada CGI Full time

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

  • Data Modeler

    4 weeks ago

    Ottawa, Canada TechInsights Full time

    **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 Intelligence (BI) content for end-customers within the TechInsights platform. The...

  • Data Modeler

    1 month ago

    Ottawa, Canada Geofirma Engineering Ltd 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 business and technical studies - Research, evaluate and synthesize technical information to design, develop and test computer-based systems - Conduct...

  • data modeler

    3 weeks ago

    Ottawa, Canada Geofirma Engineering Ltd Full time

    Work Term: PermanentWork Language: EnglishHours: 40 hours per weekEducation: Earned doctorate degreeExperience: 1 year to less than 2 yearsWork settingConsulting firmTasksConduct studies of groundwater flow and contaminationDevelop models and applied software for the analysis and interpretation of dataSupervision1 to 2 peopleResource usage and environmental...

  • data modeler

    2 weeks ago

    Ottawa, Canada Geofirma Engineering Ltd Full time

    Durée de l'emploi: PermanentLangue de travail: AnglaisHeures de travail: 40 hours per weekEducation: Expérience: EducationEarned doctorate degreeWork settingConsulting firmTasksConduct studies of groundwater flow and contaminationDevelop models and applied software for the analysis and interpretation of dataSupervision1 to 2 peopleResource usage and...

  • Data Modeler

    4 days ago

    Ottawa, Canada Maplesoft Group Full time

    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 contractors. We listen and act upon suggestions, advice, and innovative ideas to further our...

  • Data Modeler

    4 days ago

    Ottawa, Canada Maplesoft Group Full time

    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 contractors. We listen and act upon suggestions, advice, and innovative ideas to further our...

  • Data Modeler

    4 days ago

    Ottawa, Canada Maplesoft Group Full time

    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 contractors. We listen and act upon suggestions, advice, and innovative ideas to further our...

  • Data Modeler

    4 days ago

    Ottawa, Canada Maplesoft Group Full time

    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 contractors. We listen and act upon suggestions, advice, and innovative ideas to further our...

  • Data Modeler

    3 days ago

    Ottawa, ON, Canada Maplesoft Group Full time

    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 contractors. We listen and act upon suggestions, advice, and innovative ideas to further our...

  • Enterprise Database Modeler

    1 month ago

    Ottawa, Canada Maplesoft Group Full time

    Maplesoft Group is currently seeking a Database Modeler for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Primary Responsibilities Database Modeler: - Strategic and tactical responsibility for developing and maintaining the Data Models for corporate and project...

  • Senior Analyst, Modelling

    3 weeks ago

    Ottawa, Canada CMHC - SCHL Full time

     Job Requisition ID: 10141  Position Status: Permanent Full Time Position Type: Hybrid   Office Location: Travel Requirement: Travel not required Language Designation: English Essential Language Skill Levels (Read/Write/Speak): ZZZ Salary: Our salaries generally range from $ 70354.2 to $ 87942.74 and are based on qualifications and...

  • Lqs Data Analytics, Visualization and Modeling

    1 month ago

    Ottawa, Canada Ciena 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—driving our business priorities alongside meaningful social, community, and...

  • Financial Modeller

    1 month ago

    Ottawa, Canada Ciena 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—driving our business priorities alongside meaningful social, community, and...

  • Energy Modeler

    3 days ago

    Ottawa, Canada Stantec Full time

    Energy Modeler - ( 240001UU ) **Description** Within the Buildings Engineering Practice Area, the Sustainability and Building Performance team provides consulting services in support of high quality and high performance projects, including energy modeling, performance engineering, and energy management services. The service areas reflect the interconnected...

  • Threat Modeling Analyst

    1 month ago

    Ottawa, Canada nugget.ai Full time

    Location: Toronto (hybrid->3 times per week) Employment Type: Contract About the Role: The Threat Modeling Analyst is responsible for identifying threats and vulnerabilities across company systems and communicating the issues with the appropriate team – infrastructure, IT, risk, DLP, or any affected members. Responsibilities: Work cross-functionally with...

  • Data Scientist

    3 weeks ago

    Ottawa, Canada Canada Post Full time

    Job Description The Data Scientist is responsible for the delivery of leading-edge analytical solutions and works closely with the Internal Audit team members to understand the data needs of different lines of business. The Data Scientist crafts solutions to support information-based decisions, produces in-depth analysis for key business issues and...

  • Data Architect

    1 month ago

    Ottawa, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide...

  • Data Architect

    1 month ago

    Ottawa, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide...

  • Data Architect

    1 month ago

    Ottawa, Canada Talasoft Full time

    Responsibilities may encompass, but are not restricted to: Collaborate closely with internal and external stakeholders, including Business, IITB, and System Integrators, to comprehend data requirements and use cases. In conjunction with Enterprise Architecture, craft, oversee, and maintain architectures for data management services and solutions. Provide...

  • Data Scientist

    1 month ago

    Ottawa, Canada CGI Full time

    Position Description: Security clearance: Reliability Clearance a MUST Location: Ottawa, ON CGI is more than just an IT consulting company; we are a global organization offering a world of opportunities. Become part of an outstanding culture that gives you the freedom to innovate, influence decisions, achieve your full potential, and chart your own...