Data Architect/Modeller - Senior
Senior Data Architect/Modeller to develop conceptual, logical, physical, semantic, common and canonical data models supporting interoperability, information exchange, data sharing and enterprise data governance.
- Organization
- Government Services Integration Cluster
- Location
- Toronto, Ontario
- Work arrangement
- On-site
- Employment type
- Compensation
- $792/day
- Reference
- RQ11575
Overview
Resource will support data architecture and data modelling deliverables for the Government Services Integration Cluster. The role develops and implements data architecture for application development in a complex and distributed environment, including data flow and distribution, database locations, and data access methods. The resource will provide a standard common business vocabulary, express strategic data requirements, outline high-level integrated designs, and align with enterprise strategy and related business architecture.
The 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
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.
Mandatory Qualifications
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
Must Have
• 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.
• Hands-on data modeling experience - conceptual, semantic, logical and physical.
Preferred Qualifications
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
Desirable Skills (20%)
• 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.
Skills and Experience
General Skills (80%)
• 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.