Data Architect/Modeller

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 Requirements

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 moderniz