Data Architect/Modeller

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.

Job Title: Data Architect/Modeller

Location: Toronto, ON (Onsite)

Duration: 283 business days (possible extension)

Client: Public Sector

Pay Rate: $90 - $100/hr [CAD]

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

Experience and Skill Set 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 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 (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.

HM is looking for someone who has hands-on data modeling experience - conceptual, semantic, logical and physical

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.

If this opportunity matches your experience and career goals, please share your most updated resume for consideration.