Data Modeler

Role Overview

Data Modeler at Deeplight, a specialist AI and data consultancy with extensive experience implementing intelligent enterprise systems across multiple industries, particularly in financial services and banking.

Company Overview

Deeplight AI is a specialist AI and data consultancy with extensive experience implementing intelligent enterprise systems across multiple industries, with particular depth in financial services and banking. The team combines deep expertise in data science, statistical modeling, AI/ML technologies, workflow automation, and systems integration with a practical understanding of complex business operations.

Role Purpose

Design and implement scalable data models and semantic layers within Lakehouse architectures to modernize enterprise data ecosystems. Bridge the gap between low-level data engineering and high-level decision intelligence by building the "connective tissue" of the enterprise through robust Knowledge Graphs and Ontologies that enable seamless interoperability and advanced data discovery.

Key Responsibilities

Data Modeling

• Design conceptual, logical, and physical data models for Medallion architecture (Bronze, Silver, Gold layers).
• Implement dimensional modeling for analytical layers.
• Apply Slowly Changing Dimensions (SCD2) and historical tracking techniques.
• Define and enforce naming conventions, metadata standards, and maintain model documentation.

Semantic Layer & Ontologies

• Design and implement a semantic layer to enable business-friendly data access and self-service analytics.
• Work with 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.

Knowledge Graph Development

• Build and maintain knowledge graphs to represent relationships between entities and enable advanced data discovery.
• Integrate knowledge graph capabilities with Lakehouse metadata and lineage tools (e.g., OpenMetadata).
• Collaborate with architects and platform engineers to ensure graph scalability and performance.

Governance & Collaboration

• Work closely with Data Architects to align models with Lakehouse design principles.
• Partner with Data Engineers to ensure models are correctly implemented in Glue and Iceberg tables.
• Collaborate with Data Quality teams to embed validation rules and ensure compliance.

Optimization & Standards

• Ensure models support schema evolution, partitioning strategies, and performance optimization.
• Create reusable modeling templates and best practices for Data Factory squads.

Stakeholder Engagement

• Articulate the "why" behind technical decisions to high-level stakeholders.
• Bridge the gap between complex data science and actionable business value.
• Present cutting-edge solutions and effectively sell your vision to stakeholders.

Qualifications & Experience

• 7+ years in data modeling or data architecture roles.
• Strong experience in data modeling for Lakehouse or data warehouse environments.
• Proficiency in semantic layer design, ontologies, and knowledge graph development.
• Familiarity with AWS Glue, Apache Iceberg, and Medallion architecture.
• Understanding of metadata management and lineage tools (OpenMetadata preferred).
• Experience in semantic technologies, knowledge graphs, and financial services domain is a strong plus.

Skills & Competencies

• Data modeling tools (ERwin, PowerDesigner, or similar).
• Semantic layer tools (e.g., Zaimler, AtScale, or equivalent).
• Knowledge graph frameworks (e.g., RDF, OWL, Neo4j, or similar).
• Analytical and conceptual thinking.
• Advanced communication and stakeholder engagement abilities.
• Ability to work in a fast-paced environment and deliver aggressive migration targets.
• Collaboration and communication with different levels of stakeholders.
• Jira and agile way of working.

Additional Information

• Competitive salary and performance bonuses.
• Comprehensive health insurance.
• Professional development and certification support.
• Opportunity to work on cutting-edge AI projects.
• Flexible working arrangements.
• Career advancement opportunities in a rapidly growing AI company.
• Deeplight AI is committed to fostering an inclusive environment where individuals with different thinking styles can thrive and contribute their unique strengths. Reasonable adjustments to the application and interview process are available upon request.