Integration Data Modeler, Level 3

Donna Cona Inc.; Ottawa; On-site; CAD 90,000 - 120,000; Part time

Job summary

Donna Cona Inc. is seeking an Integration Data Modeler, Level 3, for a contracted engagement in Ottawa. The role focuses on owning the Canonical Data Model end-to-end, designing exchange models between Red Hat Camel middleware and Azure targets, and ensuring alignment with the Enterprise Data Model.

The ideal candidate has 5+ years in data modeling, strong API/schema design skills, and hands-on Salesforce data modeling. Collaboration across Salesforce, middleware, and cloud teams is essential.

Qualifications

• 5+ years in data modeling (conceptual, logical, physical).
• Experience designing and owning a Canonical Data Model in multi-system integrations.
• Strong understanding of Enterprise Data Model (EDM) concepts and aligning models to enterprise standards.
• Hands-on experience modeling Salesforce data structures (objects, fields, relationships, schema).
• Experience with middleware/integration platforms, specifically Red Hat Camel / Apache Camel, including message schema design (JSON/XML/Avro).
• Experience modeling for Azure Fabric (or Synapse/Data Lake/Azure SQL).
• Strong knowledge of integration patterns (canonical data model, message routing, transformation, ESB/microservices).
• Proficiency with data modeling tools (Erwin/ER/Studio/Power Designer).
• Solid understanding of API/interface contract design — schema definition, versioning, governance.
• Strong data normalization, ERs, and master/reference data concepts.
• Excellent stakeholder management and collaboration across Salesforce, middleware, and cloud teams.
• Strong documentation skills: data dictionaries, mapping specs, model diagrams.

Responsibilities

• Owning and governing the Canonical Data Model end-to-end — design, documentation, versioning, lifecycle management.
• Designing Canonical Exchange Models representing data contracts between Red Hat Camel middleware and Azure Fabric targets.
• Translating business requirements into logical and physical data models that are middleware- and platform-agnostic.
• Ensuring CDM and exchange models align with EDM and maintain naming conventions and relationships across domains.
• Defining and maintaining data mapping documents (source-to-canonical, canonical-to-target) including transformation rules.
• Establishing and enforcing data modeling standards, naming conventions, and governance across interfacing systems.
• Identifying shared entities across multiple sources to maximize reuse and minimize redundancies.
• Supporting schema versioning and backward compatibility for canonical contracts (JSON Schema, XSD, Avro).
• Partnering with Data Governance/Architecture to ensure metadata, lineage, and data quality standards.
• Reviewing designs for gaps or deviations from canonical/enterprise models; maintaining documentation such as ER diagrams and dictionaries.
• Providing SME guidance for data modeling across project teams.

Skills

Data Modeling

CDM Ownership

EDM concepts

Salesforce Modeling

Camel middleware

Azure data platform

APIs schema design

Data normalization

ER diagrams

Stakeholder management

Tools

Erwin

ER/Studio

PowerDesigner

Job description

Reference #: 8595
Location: Ottawa
Type: Sub-contract

Donna Cona Inc. is currently seeking an Integration Data Modeler, Level 3, for one of our key clients. This posting is for an incorporated contract engagement and is not an employment position.

Candidate MUST have the following:

• A valid security clearance at the level of Secret;
• More than five (5) years of experience in Data Modeling (Conceptual, Logical, and Physical modeling);
• Proven experience designing and owning a Canonical Data Model in a multi-system integration environment;
• Strong understanding of Enterprise Data Model (EDM) concepts and experience aligning solution-level models to an enterprise standard;
• Hands‑on experience modeling Salesforce data structures (objects, fields, relationships, standard/custom schema);
• Experience with middleware/integration platforms, specifically Red Hat Camel / Apache Camel microservices, including message schema design (JSON/XML/Avro) for canonical exchange models;
• Experience modeling for Azure Fabric (or broader Azure data platform: Synapse, Data Lake, Azure SQL) as a target data environment;
• Strong knowledge of integration patterns (canonical data model pattern, message routing, transformation, ESB/microservices‑based integration);
• Proficiency with data modeling tools (e.g., Erwin, ER/Studio, Power Designer, or similar);
• Solid understanding of API/interface contract design — schema definition, versioning, and governance;
• Strong grasp of data normalization, entity relationships, and master/reference data concepts;
• Excellent stakeholder management and collaboration skills — ability to work across Salesforce, middleware, and cloud data teams; and
• Strong documentation skills, ability to produce clear data dictionaries, mapping specs, and model diagrams for technical and non‑technical audiences.

Candidate should have the following demonstrated experience:

• Owning and governing the Canonical Data Model (CDM) end‑to‑end — design, documentation, versioning, and lifecycle management;
• Designing Canonical Exchange Models representing the data contracts/interfaces exchanged between the Red Hat Camel middleware layer and Azure Fabric targets;
• Translating business and functional requirements into logical and physical data models that are middleware‑ and platform‑agnostic wherever possible;
• Ensuring the CDM and exchange models align with and extend the Enterprise Data Model (EDM), maintaining consistency in naming conventions, entity definitions, and relationships across domains;
• Defining and maintaining data mapping documents (source‑to‑canonical, canonical‑to‑target) including transformation and enrichment rules;
• Establishing and enforcing data modeling standards, naming conventions, and governance practices across all interfacing systems;
• Identifying shared/common entities across multiple source systems to maximize model reusability and minimize redundant integrations;
• Supporting schema versioning and backward compatibility strategies for canonical exchange contracts (e.g., JSON Schema, XSD, Avro);
• Partnering with Data Governance/Architecture teams to ensure compliance with enterprise metadata, lineage, and data quality standards;
• Reviewing and validating integration designs from a data modeling perspective, identifying gaps, inconsistencies, or deviations from the canonical/enterprise model;
• Creating and maintaining comprehensive documentation: ER diagrams, data dictionaries, canonical schema catalogs, and interface specifications; and
• Providing guidance and acting as SME (Subject Matter Expert) for data modeling queries across project teams.

Donna Cona is committed to a diverse, equitable and inclusive workplace. We are an equal opportunity employer. We don't discriminate on the basis of gender, gender identity, sexual orientation, race, national origin, disability,age or any other protected status. We are committed to maintaining a barrier free recruitment process by providing equal employment opportunities through recruiting and retention of individuals.