Data Architect/Modeller

Lotus IT Solutions; Toronto; On-site; CAD 124,000 - 176,000; Full time

Job summary

Lotus IT Solutions in Toronto is seeking a Senior Data Architect/Modeller to design and implement enterprise-level data architectures in a complex distributed environment. You will develop canonical and domain data models and collaborate with stakeholders to ensure data interoperability across multiple business domains.

The role requires deep knowledge of data architecture principles, governance, and hands-on modelling across conceptual, logical, and physical layers.

Qualifications

• Experience developing conceptual, logical, and physical data models.
• Experience creating enterprise, canonical, and domain data models.
• Strong knowledge of data architecture principles and governance.
• Ability to facilitate workshops to reconcile terminology and models.
• Experience with multiple platforms and data technologies.

Responsibilities

• Develop data architecture for complex distributed environments.
• Create conceptual, logical, and physical data models.
• Maintain enterprise, canonical, and domain data models for interoperability.
• Develop semantic models, glossaries, and reference data structures.
• Define entities, relationships, and business rules for governance.
• Lead business/technical workshops on terminology and definitions.
• Apply domain-driven modelling to develop common data models.
• Establish modelling standards, naming conventions, and metadata.
• Support data migration, integration, and modernization initiatives.

Skills

Data modelling

Enterprise data models

Domain-driven modelling

Workshop facilitation

Analytical thinking

Clear communication

Cross-domain interoperability

Tools

ERwin

PowerDesigner

Visio

Job description

Ref: RQ11575

Contract – 12 Months (Extension Possible) Onsite – Toronto (595 Bay St.)

Posted Date: 2026-10-26

Location: Onsite – Toronto (595 Bay St.)

Public Sector Experience: Required – OPS / Public Sector

Contract End Date: 2027-10-01 *

Rate: $109/hour

Overview

Lotus is seeking a Senior Data Architect/Modeller to join the Government Services Integration Cluster under the Ministry of Public and Business Service Delivery and Procurement. In this role, you will design and implement enterprise-level data architectures in a complex distributed environment, supporting interoperability, information exchange, and data sharing across multiple business domains. You will work closely with business and technical stakeholders to develop canonical, semantic, and common data models that align with enterprise strategy and data governance objectives.

Key Responsibilities

• Develop and implement data architecture for application development in complex and distributed environments, including data flow, database locations, and data access methods
• Develop conceptual, logical, and physical data models to support enterprise data strategies
• Create and maintain enterprise, common, canonical, and domain data models that enable interoperability and information exchange across multiple business domains
• Develop semantic data models, controlled vocabularies, business glossaries, canonical business definitions, reference data structures, and semantic relationship models
• Define business entities, relationships, hierarchies, attributes, and business rules to support data governance
• Facilitate business and technical workshops to define and reconcile business terminology, entities, relationships, and canonical definitions
• Apply domain-driven modelling and business capability analysis to develop common data models
• Establish modelling standards, naming conventions, and metadata requirements
• Design reference data and master data structures to support data integration and modernization initiatives
• Develop architecture artefacts and checkpoint deliverables with traceability to business architecture requirements
• Support data migration, integration, and modernization initiatives
• Provide data interoperability and information exchange recommendations aligned with enterprise architecture governance processes

Must-Have Requirements

• Demonstrated hands-on 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
• Demonstrated experience establishing common business definitions, controlled vocabularies, semantic models, and common data models to support interoperability, information sharing, and enterprise data governance
• Experience facilitating business and technical workshops to define and reconcile business terminology, business entities, relationships, and canonical definitions
• Experience using data modelling tools such as ERwin, PowerDesigner, Visio, or equivalent CASE tools
• Experience developing semantic data models, business glossaries, controlled vocabularies, and reference data models
• Experience establishing modelling standards, naming conventions, and metadata requirements
• Experience supporting data migration, integration, and modernization initiatives
• Knowledge of metadata management, data lineage, and data governance principles
• Strong analytical, problem-solving, and written/verbal communication skills
• Experience with at least two different platforms, operating systems, environments, database technologies, languages, or communications protocols

Nice-to-Have Skills

• Experience developing common data models, business vocabularies, and semantic frameworks for regulatory, permitting, licensing, compliance, or public-sector programs involving multiple business domains
• 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 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
• Experience with middleware and gateways
• Knowledge of object-oriented analysis and design techniques
• Experience developing enterprise architecture deliverables based on Ontario Government Enterprise Architecture processes and practices

Work Environment

This is a fully onsite role based at 595 Bay St., Toronto, 5 days per week. No security clearance is required. The role operates within the Government Services Integration Cluster and involves close collaboration with business and technical stakeholders across multiple ministries and business domains.

Final role details, responsibilities, and terms will be confirmed with shortlisted candidates. Compensation may vary based on experience. Errors and omissions excepted.