Reference #: 5360
Location: Ottawa, Ontario
Type: Sub-contract

Donna Cona Inc. is currently seeking a Database Modeller/Information Management Modeller, Level 3, for one of our key government clients to assist with implementing a data analytics platform.

Candidate MUST have the following mandatory criteria:

  • A valid security clearance at the Reliability level;
  • A minimum of ten (10) years of demonstrated experience as a Database Modeller/Information Management Modeller;
  • A minimum of six (6) years of experience, obtained in the last ten (10) years prior to the bid closing date designing logical and physical enterprise data models;
  • A minimum of six (6) years of experience, obtained in the last ten (10) years prior to the bid closing date designing multi-dimensional data models* based on star or snowflake schemas:
    • * A multi-dimensional data model is a type of data model that is optimized for data warehouse and online analytical processing (OLAP) applications. It is composed of logical cubes, measures, dimensions, hierarchies, levels, and attributes. The simplicity of the model is inherent because it defines objects that represent real-world business entities.
  • A minimum of six (6) years of experience, obtained in the last ten (10) years prior to the bid closing date developing Extract-Transform-Load (ETL) strategies, including proposing technology solutions; and
  • Experience as a Database Modeller/Information Management Modeller on one (1) project in the last two (2) years prior to the bid closing date designing a model for a data lake of structured and unstructured data.

Candidate should have the following:

  • Experience developing ETL processes;
  • Experience developing and maintaining a data dictionary;
  • Experience developing and maintaining a metadata repository;
  • Experience developing and implementing data access models; and
  • Hold a University Degree or two (2) Year Post-Secondary Diploma in Computer Science, Computer Engineering or Mathematics or in a relevant field.
  • To apply for this position please complete the form below.
  • Please note that these must be in one document, and can be in .docx, .doc, .pdf or .rtf formats
  • This field is for validation purposes and should be left unchanged.