[Hiring] Senior Data Modeler @Convene

Role Description

The Senior Data Modeler will be a key contributor within the Data Architecture Team of the Enterprise Data Solutions Department, responsible for designing and governing the Silver layer of the enterprise data lakehouse built on Medallion Architecture. This role translates data from operational systems into standardized, integrated, and analytics-ready enterprise entities, using normalized Third Normal Form (3NF) as the primary modeling approach, supplemented by Data Vault 2.0 and other patterns where appropriate.

The Senior Data Modeler will partner closely with:

• Data Architects
• Data Engineers
• Business Analysts
• Data Governance
• Source-system SMEs

to ensure models are accurate, traceable, scalable, and implementation-ready, and that they reliably support downstream Gold-layer reporting and analytics.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, or a related field.
• 5–10 years of experience in data modeling, data architecture, or data engineering.
• Minimum 2–3 years of hands-on experience with Medallion Architecture (Bronze / Silver / Gold).
• Strong expertise in Third Normal Form (3NF) and normalized relational modeling.
• Strong working knowledge of Data Vault 2.0.
• Advanced SQL skills and experience profiling large operational datasets.
• Experience modeling data for cloud lakehouse or modern data-platform environments.
• Preferred: Experience with SaaS-based data modeling tools such as SQLDBM.

Requirements

• Silver Layer Data Modeling – Design, develop, and maintain conceptual, logical, and physical data models for the Silver layer of the enterprise data lakehouse built on Medallion Architecture.
• Normalized (3NF) Entity Design – Design 3NF entities for master, reference, transactional, association, episode, and event-history data.
• Data Vault 2.0 Design – Apply hubs, links, satellites, business keys, and historization where appropriate.
• Source Data Profiling – Profile source data to confirm grain, keys, relationships, cardinality, completeness, code domains, and data-quality issues.
• Source-to-Target Mapping – Create attribute-level mappings covering transformations, data types, nullability, key behavior, historization, DQ rules, and PII classification.
• Key Design – Define surrogate keys, alternate keys, source-system crosswalks, and unresolved foreign-key handling.
• Historization – Recommend appropriate patterns, including SCD Type 1, selective SCD Type 2, lifecycle episodes, and append-only events.
• Canonical Modeling – Design reusable canonical models capable of integrating multiple source systems without major redesign.
• Standards & Governance – Define and enforce standards for naming, reference data, lineage, audit, retention, deletion, and data quality.
• Implementation Review – Review implementation SQL and pipelines to ensure alignment with approved models.
• Model Management – Maintain models, definitions, relationships, and documentation in the enterprise modeling tool.
• Gold Layer Support – Support downstream dimensional models and KPI reporting without embedding report-specific logic in Silver.
• Cross-Functional Collaboration – Partner with data architects, data engineers, business analysts, governance teams, and source-system SMEs.

Company Description

Convene, Inc. is a Tampa based, award-winning technology services organization with offices and resources throughout the US, Mexico, and India. We have successful, referenceable customers, competitive benefits, and high-growth opportunities.