Data Architect (MD-NSDA-0803N)

Ottawa/Gatineau (NCR)
Posted 2 weeks ago


Job #

Posting Date


Data Architect (MD-NSDA-0803N)


November 14, 2022

Ottawa / Gatineau (NCR)

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

Mandatory Requirements:

  • Minimum 15 years of experience as a Data Architect
  • Must have successfully completed a post-secondary education program in computer science, information technology (IT), engineering or a scientific discipline with fifteen (15) years of IT experience or other post-secondary education with twenty (20) years of IT experience
  • Must have five (5) years of experience within the last ten (10) years developing large data sets and Enterprise-grade databases (structured and unstructured)
  • Must have five (5) years of experience within the last ten (10) years developing dimensional data models for an enterprise data warehouse
  • Must have five (5) years of experience designing and developing the data warehouse architecture and data integration strategies for enterprise data warehouse solutions
  • Must have five (5) years of experience troubleshooting SQL queries; and conducting database performance tuning
  • Valid Government of Canada Secret Level II security clearance granted by CSP/PSPC

Rated Criteria:

  • Experience developing and documenting conceptual, logical and physical data models
  • Experience gathering data requirements through workshops and interviews with clients
  • Experience developing data warehouse and ETL design specifications, including source to target data mappings
  • Experience developing data models and entity relationship diagrams using ERwin Data Modeler or an equivalent software tool
  • Experience with big data concepts (i.e. analysis, extraction, schema, lineage, etc.) for complex and large data sets
  • Experience extracting data from multiple sources via APIs and scripting
  • Experience with microservice applications and cloud-based services
  • Experience with data lake concepts for landing, refining, and analyzing data
  • Migrating large data sets from on-prem to cloud environments
  • Experience architecting and building data pipelines
  • Deep understanding of the ETL (extract, transform, load) process
  • Developing data pipelines for large-scale ETL transformations
  • Experience transforming data through field mapping, programmatic rulesets, and data integrity checking
  • Able to expertly convey ideas and concepts to others
  • Excellent communication skills (verbal, written, and presentation)
  • Creative problem-solving skills and the ability to design solutions not immediately apparent
  • Ability to participate in multiple projects concurrently
  • Able to function in a highly dynamic team that moves rapidly from idea to planning to implementation
  • Highly adaptable with the ability to learn new technologies quickly without direct oversight

Location of Work:

  • Ottawa / Gatineau (NCR)


To apply for this job opportunity, please email us your updated résumé citing job number MD-NSDA-0803N 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 Architect
Key SkillsERwin, ERwin Data Modeler, ETL, Secret Level II security clearance