Data Architect - Senior

Location: Ottawa, ON, Canada
Date Posted: 12-09-2018
Responsibilities: 
  • Reverse engineer and capture the current data model that exists 
  • Capture and inventory all existing event messages, and their purpose, format, transformation, scope, etc. 
  • Understand the data feeds and the formats and processing of the data within those feeds 
  • Identify and inventory data transformations in systems feeding the current event handling system 
  • Understand the current business usage of the data 
  • Inventory all downstream uses of the data 
  • Understand and inventory all data transformations currently performed for downstream systems 
  • Map Data to associated business rules 
  • Work with team to classify existing events against proposed architecture 
  • Develop conceptual data model that maps to the new proposed architecture 
Must Have: 
  • Proven work experience as a Data Architect or similar role 
  • In-depth understanding of data and messaging structures and principles 
  • Experience gathering and analyzing system requirements 
  • Expertise in RDMS, SQL and NoSQL systems and data models 
  • Experience with data visualization and modeling tools 
  • Problem-solving attitude 
  • BSc in Computer Science or relevant field 
  • Valid Reliability level federal government security clearance
Nice to Have: 
  • Experience in designing solutions in the cloud and hybrid infrastructures 
  • Experience with ETL Solutions 
  • Experience with Platform as a Service solutions
Duration: 6 months plus possible extensions
or
this job portal is powered by CATS