This job board retrieves part of its jobs from: Texas Jobs | Nevada Jobs | Ottawa Jobs

Find jobs in Ottawa today!

To post a job, login or create an account |  Post a Job

  Jobs in Ottawa  

Bringing the best, highest paying job offers near you

previous arrow
next arrow

Senior Data Modeler

CGI Group

This is a Contract position in Ottawa, ON posted January 10, 2021.

Position Description:

CGI has a requirement for a Senior Data Modeler to build, update, and maintain the conceptual, logical and physical data models to support the delivery of solution components within various Financial Market and Banking Operations (FMBO) projects, ensuring business requirements are met.

These models must follow the enterprise architecture direction and principles, be built with standard database analysis and design techniques, and align with industry best practice in data modeling and architecture. Following delivery of these solutions, the Resource will support day-to-day business transaction operations, business analytics, data discovery, and reporting capabilities for data visualization.

Your future duties and responsibilities:

• 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 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 2012

• Experience in modeling data for Enterprise Java EE applications

• Experience in modeling using ER/Studio Data Architect

What you can expect from us:

Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change-supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at

No unsolicited agency referrals please.

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.