RQ11575 - Data Architect/Modeller - Senior

Maarut; Toronto; On-site; CAD 100,000 - 150,000; Full time

Job summary

Maarut is seeking a senior data architect in Toronto, Ontario to design and implement data architecture for complex, distributed applications. You will define data flow, database locations, and data access methods while establishing canonical data models and semantic relationships.

Your role includes collaborating on enterprise data governance, vocabularies, and standards to support interoperability. The ideal candidate brings 7–10 years of experience in data architecture, strong knowledge of

Qualifications

• Extensive experience developing enterprise, common, canonical and domain data models across multiple business domains.

Responsibilities

• Develops and implements the data architecture for applications in a complex distributed environment, including data flow, databases, and access methods.
• Provides a standard business vocabulary, defines data requirements, and aligns designs with enterprise strategy.

Skills

Data architecture

Data governance

Data modelling

CASE tools

Metadata management

Information management

Analytical thinking

Communication

Team player

Middleware

Tools

ERwin

PowerDesigner

Visio

Databricks

Neo4j

Denodo

Job description

Job Information

Term 283 days

Technology

Number of Positions 1

Work Experience 7-10 Years

City Toronto

State/Province Ontario

M4C

Job Description

Responsibilities:

• Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.
  
• Provides a standard common business vocabulary, expresses strategic data requirements, outlines high level integrated designs to meet these requirements, and aligns with the enterprise strategy and related business architecture.
  

General Skills:

• Knowledge and experience in information resource management tools and techniques
  
• Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols
  
• Knowledge of performance considerations for different database designs in different environments
  
• Experience in structured methodologies for the design, development and implementation of applications
  
• Experience in systems analysis and design in large or medium systems environments
  
• Experience in the use of Computer Aided Software Engineering (CASE) tools for the development and documentation of data architectures and detailed data models
  
• Experience in the use of data modelling methods and tools (e.g. ERWIN, VISIO, PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries
  
• Knowledge and experience in the use of information retrieval packages
  
• Awareness of emerging I&IT trends and directions
  
• Experience in monitoring and enforcing data modelling/normalization standards
  
• Experience in developing enterprise architecture deliverables (e.g. models) Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
  
• A team player with a track record for meeting deadlines
  
• Experience with middleware and gateways
  
• Experience in designing/developing an automated data distribution mechanism
  
• Knowledge and understanding of object-oriented analysis and design techniques.
  
• Experience in developing enterprise architecture deliverables (e.g. models) based on Ontario Government Enterprise Architecture processes and practice
  
• Knowledge and understanding of Information Management principles, concepts, policies and practices
  
• Experience creating detailed data standards to enable integration with other systems
  
• Experience reviewing conceptual, logical and physical data models for quality and adherence to standards
  
• Knowledge and understanding of dimensional and relational data models
  
• Knowledge and experience in information resource management tools and techniques
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Extensive experience developing enterprise, common, canonical and domain data models that support interoperability, information exchange and data sharing across multiple business domains.
  
• Deep knowledge of data architecture principles, methodologies, standards and best practices.
  
• Demonstrated experience establishing common business definitions, controlled vocabularies, semantic models and common data models to support interoperability, information sharing and enterprise data governance across multiple business domains.
  
• Experience facilitating business and technical workshops to define and reconcile business terminology, business entities, relationships and canonical definitions.
  
• Experience developing business glossaries, reference data models and semantic relationship models.
  

Skill Set Requirements:

General Skills:

• Demonstrated experience developing conceptual, logical and physical data models.
  
• Extensive experience developing enterprise, common, canonical and domain data models that support interoperability, information exchange and data sharing across multiple business domains.
  
• Deep knowledge of data architecture principles, methodologies, standards and best practices.
  
• Experience using data modelling tools such as ERwin, PowerDesigner, Visio or equivalent CASE tools.
  
• Experience defining business entities, relationships, hierarchies, attributes and business rules.
  
• Extensive experience developing semantic data models, controlled vocabularies, business glossaries, canonical business definitions, reference data structures and semantic relationship models.
  
• Demonstrated experience establishing common business definitions, controlled vocabularies, semantic models and common data models to support interoperability, information sharing and enterprise data governance across multiple business domains.
  
• Experience facilitating business and technical workshops to define and reconcile business terminology, business entities, relationships and canonical definitions.
  
• Experience developing business glossaries, reference data models and semantic relationship models.
  
• Experience applying domain-driven modelling and business capability analysis to the development of common data models.
  
• Experience establishing modelling standards, naming conventions and metadata requirements.
  
• Experience supporting interoperability, information exchange and data integration initiatives.
  
• Experience developing architecture artefacts and checkpoint deliverables with traceability to business architecture requirements.
  
• Knowledge of metadata management, data lineage and data governance principles.
  
• Experience supporting data migration, integration and modernization initiatives.
  
• Strong analytical, problem-solving and communication skills.
  

Resource will support the following deliverables:

• Canonical Data Model
  
• Conceptual Data Models
  
• Logical Data Models
  
• Semantic Data Models
  
• Business Glossary
  
• Controlled Vocabulary
  
• Canonical Business Definitions
  
• Reference Data Models
  
• Semantic Relationship Models
  
• Data Standards and Naming Conventions
  
• Architecture artefacts supporting architecture governance and review processes
  
• Data interoperability and information exchange recommendations
  
• Data prototyping and proof-of-concept activities
  
• Experience developing common data models, business vocabularies and semantic frameworks for regulatory, permitting, licensing, compliance or public-sector programs involving multiple business domains and stakeholder groups.
  
• Experience with semantic modelling, ontology development or knowledge graph concepts.
  
• Knowledge of RDF, OWL, graph databases or semantic technologies.
  
• Experience with Databricks, Neo4j, Denodo or equivalent data platforms.
  
• Experience with metadata repositories and governance solutions.
  
• Knowledge and understanding of Information Management principles, concepts, policies and practices.
  
• Knowledge and understanding of AODA and related standards.
  
• Experience supporting permitting, regulatory, licensing or public sector business domains.