RQ11575 - Data Architect/Modeller - Senior

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
  

Desirable Skills:

• 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
  

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 designing reference data and master data structures.
  
• 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:

• Common Data Model (CDM)
  
• 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
  

Desirable Skills:

• 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.