5-7 years of experience in data architecture and enterprise data modeling
Proficiency in data modeling tools like ERwin, PowerDesigner, or Visio
Strong understanding of data governance and interoperability principles
Experience facilitating workshops to define business terminology and data relationships
Knowledge of emerging trends in information technology and data management
Responsibilities
Develop and implement data architecture for complex application environments
Establish a common business vocabulary and align data requirements with enterprise strategy
Create high-level integrated designs to meet strategic data needs
Monitor and enforce data modeling standards and normalization practices
Support data interoperability and information exchange initiatives
Benefits
Opportunities for professional development and training
Collaborative work environment with a focus on teamwork
Access to cutting-edge technology and tools
Engagement in impactful projects across multiple business domains
Flexible work arrangements to promote work-life balance
Full Job Description
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
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
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:
CommonData Model (CDM)
CanonicalData Model
ConceptualData Models
LogicalData Models
SemanticData Models
BusinessGlossary
ControlledVocabulary
CanonicalBusiness Definitions
ReferenceData Models
SemanticRelationship Models
DataStandards and Naming Conventions
Architectureartefacts supporting architecture governance and review processes
Datainteroperability and information exchange recommendations
Dataprototyping and proof-of-concept activities
Desirable Skills:
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.
