11802

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

Job summary

Maarut is seeking an experienced data architect to design enterprise data models and governance frameworks. You will define canonical data structures, data standards and semantic relationships to support interoperability across multiple business domains.

You will also facilitate workshops to align terminology, develop glossaries, and deliver architecture artefacts that map to Ontario Government Enterprise Architecture practices.

Qualifications

• Extensive experience building enterprise data models to enable interoperability and data sharing across domains.
• Deep knowledge of data architecture principles, standards and best practices.
• Experience in developing glossaries, reference data models and semantic relationships.
• Experience facilitating workshops to define business terminology and canonical definitions.

Responsibilities

• Develop canonical and conceptual data models aligned with enterprise architecture.
• Define data standards, metadata requirements and governance practices.
• Support data migration, integration and modernization initiatives.
• Produce architecture artefacts with traceability to business requirements.

Skills

Data modeling

Data governance

Requirements gathering

Business glossary

Analytical thinking

Tools

ERwin

PowerDesigner

Visio

CASE tools

Job description

• Develops and implements the data architecture forapplication development in a complex and distributed environment, including thedetermination of the flow and distribution of data, the location of databases,and data access methods.
  
• Provides a standard common business vocabulary, expressesstrategic data requirements, outlines high level integrated designs to meetthese requirements, and aligns with the enterprise strategy and relatedbusiness architecture.
  

General Skills:

• Knowledge and experience in information resource managementtools and techniques
  
• Experience with at least two different platforms, operatingsystems, environments, database technologies, languages and communicationsprotocols
  
• Knowledge of performance considerations for differentdatabase 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 mediumsystems environments
  
• Experience in the use of Computer Aided Software Engineering(CASE) tools for the development and documentation of data architectures anddetailed data models
  
• Experience in the use of data modelling methods and tools(e.g. ERWIN, VISIO, PowerDesigner) including a working knowledge of metadatastructures, repository functions, and data dictionaries
  
• Knowledge and experience in the use of information retrievalpackages
  
• Awareness of emerging I&IT trends and directions
  
• Experience in monitoring and enforcing datamodelling/normalization standards
  
• Experience in developing enterprise architecturedeliverables (e.g. models) Excellent analytical, problem-solving anddecision-making skills; verbal and written communication skills; interpersonaland negotiation skills
  
• A team player with a track record for meeting deadlines
  
• Experience with middleware and gateways
  
• Experience in designing/developing an automated datadistribution mechanism
  
• Knowledge and understanding of object-oriented analysis anddesign techniques.
  
• Experience in developing enterprise architecturedeliverables (e.g. models) based on Ontario Government Enterprise Architectureprocesses and practice
  
• Knowledge and understanding of Information Managementprinciples, concepts, policies and practices
  
• Experience creating detailed data standards to enableintegration with other systems
  
• Experience reviewing conceptual, logical and physical datamodels for quality and adherence to standards
  
• Knowledge and understanding of dimensional and relationaldata models
  
• Knowledge and understanding of information resource managementtools and techniques
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Extensiveexperience developing enterprise, common, canonical and domain data modelsthat support interoperability, information exchange and data sharingacross multiple business domains.
  
• Deepknowledge of data architecture principles, methodologies, standards andbest practices.
  
• Demonstratedexperience establishing common business definitions, controlledvocabularies, semantic models and common data models to supportinteroperability, information sharing and enterprise data governanceacross multiple business domains.
  
• Experiencefacilitating business and technical workshops to define and reconcilebusiness terminology, business entities, relationships and canonicaldefinitions.
  
• Experiencedeveloping business glossaries, reference data models and semanticrelationship models.
  

Skill Set Requirements:

General Skills:

• Demonstratedexperience developing conceptual, logical and physical data models.
  
• Extensiveexperience developing enterprise, common, canonical and domain data modelsthat support interoperability, information exchange and data sharingacross multiple business domains.
  
• Deepknowledge of data architecture principles, methodologies, standards andbest practices.
  
• Experienceusing data modelling tools such as ERwin, PowerDesigner, Visio orequivalent CASE tools.
  
• Experiencedefining business entities, relationships, hierarchies, attributes andbusiness rules.
  
• Extensiveexperience developing semantic data models, controlled vocabularies,business glossaries, canonical business definitions, reference datastructures and semantic relationship models.
  
• Demonstratedexperience establishing common business definitions, controlledvocabularies, semantic models and common data models to supportinteroperability, information sharing and enterprise data governanceacross multiple business domains.
  
• Experiencefacilitating business and technical workshops to define and reconcilebusiness terminology, business entities, relationships and canonicaldefinitions.
  
• Experiencedeveloping business glossaries, reference data models and semanticrelationship models.
  
• Experienceapplying domain-driven modelling and business capability analysis to thedevelopment of common data models.
  
• Experienceestablishing modelling standards, naming conventions and metadatarequirements.
  
• Experiencedesigning reference data and master data structures.
  
• Experiencesupporting interoperability, information exchange and data integrationinitiatives.
  
• Experiencedeveloping architecture artefacts and checkpoint deliverables withtraceability to business architecture requirements.
  
• Knowledgeof metadata management, data lineage and data governance principles.
  
• Experiencesupporting data migration, integration and modernization initiatives.
  
• Stronganalytical, problem-solving and communication skills.
  

Resource will support the following deliverables:

• CanonicalData Model
  
• ConceptualData Models
  
• BusinessGlossary
  
• ControlledVocabulary
  
• CanonicalBusiness Definitions
  
• SemanticRelationship Models
  
• DataStandards and Naming Conventions
  
• Architectureartefacts supporting architecture governance and review processes
  
• Datainteroperability and information exchange recommendations
  
• Dataprototyping and proof-of-concept activities
  
• Experiencedeveloping common data models, business vocabularies and semanticframeworks for regulatory, permitting, licensing, compliance orpublic-sector programs involving multiple business domains and stakeholdergroups.
  
• Experiencewith semantic modelling, ontology development or knowledge graph concepts.
  
• Knowledgeof RDF, OWL, graph databases or semantic technologies.
  
• Experiencewith Databricks, Neo4j, Denodo or equivalent data platforms.
  
• Experiencewith metadata repositories and governance solutions.
  
• Knowledgeand understanding of Information Management principles, concepts, policiesand practices.
  
• Knowledgeand understanding of AODA and related standards.
  
• Experiencesupporting permitting, regulatory, licensing or public sector businessdomains.