Deeplight AI

Data Modeler

• Design conceptual, logical, and physical data models for Medallion architecture across Bronze, Silver, and Gold layers
• Implement dimensional modeling for analytical layers
• Apply Slowly Changing Dimensions (SCD2) and historical tracking techniques
• Define and enforce naming conventions and metadata standards; maintain model documentation
• Design and implement a semantic layer for business-friendly data access and self-service analytics
• Use advanced AI tooling for semantic layer deployment and integration
• Develop and maintain ontologies and taxonomies to standardize business concepts across domains
• Ensure semantic consistency across data products and reporting layers
• Build and maintain knowledge graphs representing relationships between entities
• Integrate knowledge graph capabilities with Lakehouse metadata and lineage tools such as OpenMetadata
• Collaborate with architects and platform engineers to ensure graph scalability and performance
• Work with Data Architects to align models with Lakehouse design principles
• Partner with Data Engineers to ensure models are implemented in Glue and Iceberg tables
• Collaborate with Data Quality teams to embed validation rules and ensure compliance
• Ensure models support schema evolution, partitioning strategies, and performance optimization
• Create reusable modeling templates and best practices for Data Factory squads
• Present technical solutions, articulate the rationale behind technical decisions, and build trust with high-level stakeholders

Explore Data Modeler at Deeplight AI. Review requirements and application details.