Senior Data Modeler

Overview

Role Overview

We are looking for a Senior Data Modeler with 7+ years of experience in enterprise data modeling, database architecture, and data platform design.

The ideal candidate should have strong expertise in SQL, data modeling, database management, data architecture, Azure Databricks, and Erwin. This is an individual contributor role requiring the ability to understand enterprise data architecture, translate business requirements into effective data models, and collaborate with data engineering, architecture, and business teams.

Job Description

Data Modeling

• Design and develop conceptual, logical, and physical data models.
• Translate business and functional requirements into scalable data models.
• Define entities, attributes, relationships, keys, constraints, and data structures.
• Develop and maintain enterprise data models in alignment with architectural standards.
• Identify opportunities to improve data structures, consistency, quality, and performance.
• Ensure data models support reporting, analytics, integration, and downstream data requirements.

Data Architecture

• Understand existing data architecture and contribute to future-state architecture.
• Analyze data dependencies across applications, databases, and data platforms.
• Collaborate with Data Architects and Data Engineers to implement data models.
• Ensure alignment between logical/physical models and enterprise architecture standards.
• Support data platform modernization and transformation initiatives.

Azure Databricks & Data Platforms

• Work with Azure Databricks-based data platforms.
• Support the design of data structures for data lake and analytics environments.
• Collaborate with engineering teams on data ingestion, transformation, and consumption requirements.
• Ensure models are optimized for performance and scalability.

SQL & Database Management

• Develop and review complex SQL queries.
• Analyze existing database structures and identify optimization opportunities.
• Work with database teams to ensure efficient physical implementation of data models.
• Understand database performance, indexing, normalization, and data storage concepts.

Documentation & Governance

• Maintain data model documentation and metadata.
• Ensure adherence to enterprise data modeling standards.
• Participate in architecture and design reviews.
• Clearly communicate data structures and dependencies to technical and business stakeholders.

Skills & Requirements

Apply Now