Data Warehouse Modeller (CM-ECDWM-0270N)

Ottawa/Gatineau (NCR)
Posted 5 days ago


Job #

Posting Date


Data Warehouse Modeller (CM-ECDWM-0270N)


July 11, 2019

Ottawa / Gatineau (NCR)

Description: Nortak Software is currently seeking Data Warehouse Modellers with the following qualifications:

Mandatory Requirements:

  • Must have 10+ cumulative years of experience as a Data Warehouse Modeller
  • Must have 10+ cumulative years of experience designing Enterprise Data Warehouses and Business Intelligence Solutions
  • Must have 10+ years of experience producing Real Time data movement Architecture and Design (experience must include: i. Initial Load; ii. Incremental Load; iii. Change Data Capture using data source logs; iv. Data Replication and ETL error handling and recovery design; and v. Adding structural changes within an existing Replicating solution
  • Bilingual (English and French)
  • Valid Government of Canada Secret Level II security clearance granted by CSP/PSPC

Rated Criteria:

  • Experience designing a data warehouse that represents multiple lines of business and sources data from multiple data sources
  • Experience  in reverse engineering Business Intelligence requirements (front end reports and/or dashboards) into Enterprise Data Warehouse Operational Data Store and Data Mart(s) data models
  • Experience with Cognos BI modeling (Framework Manager), Data Modules, Dashboards, drill downs and geography maps in reporting solutions as these components relate to data warehouse architecture and design
  • Experience with ER/Studio as a data modeling tool to produce the following:   i. Data warehouse design; ii. ETL specifications; iii. Meta data repository; and iv. Data lineage
  • Experience with Continuous Integration of database and ETL releases in the context of a Data Warehouse Project

Location of Work:

  • Ottawa / Gatineau (NCR)


To apply for this job opportunity, please email us your updated résumé citing job number CM-ECDWM-0270N in the subject line.




We would like to thank you for your interest. Please note that all submissions will be assessed, however, only candidates selected for interview will be contacted.

NORTAK SOFTWARE LTD. is a Canadian-owned private corporation with offices in Ottawa and Toronto serving a global client base since 1975.

Nortak is committed to providing equal employment opportunities to all qualified employees and applicants.


Job Features

Job CategoryData Warehouse Modeller
Key SkillsBusiness Intelligence, Cognos BI modeling, ER/Studio