Data Architect/Modeller - Senior

Job ID: RQ11266 - Data Architect/Modeller - Senior

Experience and Skill Set Requirements

Mandatory Skills:

• Knowledge and experience in information resource management tools and techniques

• Defines, identifies and describes information architectural requirements with clients, and obtains I&IT management approval.

• Ability to complete complex information architecture reviews and assessments, development and/or support projects, to support new and changed enterprise priorities and initiatives, and client clusters’ and their clients’ information architecture and/or business needs.

• 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

• Resource will build upon the Conceptual and Logical Data Models which are technology-and application-independent and will assist with the following tasks/deliverables:

• Continue ‘data prototyping’ to proof CDM recommendation

• Refine the Logical Data Model as required.

• Support MECP in developing their Data Migration strategy/plan

• Assist with Alpha prototyping and/or proofs-of-concept

• Support development of enterprise architecture artefacts for submission to Architecture Review Board for Architecture Gate Point 1 (AGP1) in spring 2027

Desirable Skills:

• Knowledge and understanding of Information Management principles, concepts, policies and practices

• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

• Experience with middleware and gateways

• Experience in designing/developing an automated data distribution mechanism

• Knowledge and understanding of object-oriented analysis and design techniques.

• 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