What are the responsibilities and job description for the Data Architect (Lead Data Modeler) - Onsite Role - Multiple locations position at Aventine software?
Role: Data Architect (Lead Data Modeler (Cybersecurity Canonical Model))
Location: Charlotte NC/Chandler AZ/Dallas TX (work from office)
Type: C2C ROLE
JOB DESCRIPTION:
Lead Data Modeler (Cybersecurity Canonical Model)
Role Summary
The Lead Data Modeler will own the design and enhancement of the enterprise canonical data model for cybersecurity baselines, ensuring the model is assetagnostic, extensible, and aligned to CIS benchmarks. This role bridges security domain knowledge and enterprise data architecture.
Key Responsibilities
Design and enhance the Canonical Data Model (CDM) for enterprise security baselines
Define assetagnostic entities, attributes, relationships, and metadata standards
Perform detailed mapping of baseline parameters from Excel, Word, and JSON sources to the CDM
Integrate CIS Benchmark structures to create draft and reference baselines
Partner with engineers to ensure the model is optimized for MongoDB (document design, nesting, indexing)
Define logical lineage, business definitions, and governance metadata
Support transformation rules and data standardization decisions
Skills
Canonical / enterprise data modeling
Cybersecurity baseline concepts, CIS Benchmarks
Document & semistructured data modeling (JSON, hierarchical models)
MongoDB data modeling best practices
Metadata management and governance