Job Overview
We are seeking a highly experienced Senior Data Architect/Modeler to lead the design, development, and management of our enterprise data architecture. This role involves creating scalable data models, optimizing data storage solutions, and ensuring data integrity across multiple platforms.
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.
Requirements
Experience and Skill Set Requirements
Mandatory Skills (50%):
- 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 (30%):
- 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
Communication & Soft Skills (15%)
- Excellent verbal and written communication skills (clear & concise. Presentation skills to present information and findings, options and recommendations to clients, project/technical team members and management audiences
- Strong track record of building and maintaining solid relationships with clients, project team members, and management
- Self-motivated leader with strong interpersonal skills. Collaboration skills to jointly work towards project common goals/deliverables by proactively sharing status, raising risks/issues and effort estimates
- Persistent attention to detail
- Proven ability to handle multiple tasks and deliver within extremely tight deadlines
- Project rescue/project triage experience is an asset
Public Sector Experience (5%):
- Previous experience working in Government or Public Sector organizations
- Demonstrated experience in Ontario Design System https://designsystem.ontario.ca/
- Experience in developing enterprise architecture deliverables (e.g. models) based on Ontario Government Enterprise Architecture processes and practice
Must Have:
- 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.
#IMPJOB
Pay: $105.00-$108.00 per hour
Experience:
- Data Architect/Modeller - Senior: 10 years (required)
Work Location: In person
