Integration Data Modeler, Level 3

Job summary

Own and govern canonical and exchange data models, aligning them with enterprise standards and supporting integrations between Salesforce, Red Hat Camel middleware, and Azure data platforms. Define mappings, schemas, versioning, and modeling standards, while documenting models and advising project teams on data modeling.

Job details

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.

What you’ll do

Own and govern canonical and exchange data models, aligning them with enterprise standards and supporting integrations between Salesforce, Red Hat Camel middleware, and Azure data platforms. Define mappings, schemas, versioning, and modeling standards, while documenting models and advising project teams on data modeling.

Requirements

Requires an active Secret security clearance and more than five years of conceptual, logical, and physical data modeling experience, including ownership of canonical models in multi-system integration environments. Candidates must have experience with Salesforce, Red Hat Camel or Apache Camel, Azure data platforms, integration patterns, modeling tools, API contracts, and stakeholder collaboration.

Listed skills

• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Modeling
• Canonical Data Modeling
• Enterprise Data Modeling
• Salesforce Data Modeling
• Red Hat Camel
• Apache Camel
• Azure Fabric
• Integration Patterns
• Data Mapping
• API Contract Design
• Schema Versioning
• Data Governance
• Data Normalization
• Stakeholder Management
• Data Documentation
• Security Clearance

Job areas

• Data & Analytics
• Technology
• Software
• Consulting

More jobs from Donna Cona