IT Jobs

Data Architect (Teradata, Datastage, SQL)

In by kyleroots

Myticas Consulting

Data Architect (Teradata, Datastage, SQL)

12 Months

Enhanced Reliability Clearance MANDATORY

Ottawa or Toronto – Remote to Start

Key Skills:

  • Teradata
  • DataStage
  • Data Modelling
  • SQL
  • AGILE (Kanban)


  • Participate in the development, evolution and oversight of the overall vision for Information Lifecycle of the corporation and clients by collaborating with management, staff and stakeholders on data strategy, architecture, rationalization, quality and analytics to support strategic business initiatives
  • Provide guidance and basic principles to projects to assist efficient management of data assets
  • Provide end-to-end vision and knowledge to projects to help them better design solutions from a data perspective
  • Close the gap between the technical and high-level business requirements from a data perspective by effectively communicating to business owners and technical teams
  • Establish and oversee basic data modeling principles
  • Design data architectures, design and build complex relational databases and data warehouses to satisfy application (business and technical) requirements
  • Develop strategies for data acquisitions, archive recovery, and implementation of a database
  • Perform database tuning and optimization, provide suggestions on database performance improvement to the application support and/project development teams
  • Develop Logical and Physical Data Models to ensure adherence to sound data management principles and where possible, the reuse of data
  • Provide expertise, guidance and consultation regarding the physical storage, movement and presentation of data for projects and the organization
  • Utilize industry & competitive knowledge to apply the most current and appropriate ideas in a forward-looking manner to support the business
  • Implement Relational and multi-dimensional database solutions using available database development tools
  • Provide leadership and direction to a team of database developers to ensure technical requirements are met


Must Have:

  • Data management: significant experience with the design, development and maintenance of enterprise level data systems such as Oracle, Teradata, DataStage, SQL. or others; established and recognized area(s) of expertise in data standards and database products; strong data management skills including relationships and conversion requirements


  • Minimum 3-5 years’ experience as a Data Architect.
  • Minimum 5-8 years’ experience in progressively advancing roles within IT.

Nice to Have:

  • Client Management: can consolidate business requirements and translate them into sound solution architecture
  • Solution design: familiar with workflow concepts and how they integrate with application solutions in a cross application context
  • Application development: knowledge of functions, features and facilities of applicable programming languages
  • Application development concepts: is familiar with developing Service Oriented Architecture (SOA) based services within medium to highly complex application environments
  • Familiarity with both functional and performance aspects of integration
  • Domain knowledge: experience in relevant IT domain
  • Excellent understanding of technologies (current and emerging)
  • Ability to work in a fast-paced agile development environment


Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!