Logo
Purple Drive

Senior Data Modeler

Purple Drive, Los Angeles, California, United States, 90079

Save Job

Job Summary

We are seeking an experienced

Data Modeler

to design and maintain robust, scalable, and efficient data models that enable seamless data flow across transactional, analytical, and lake house systems. The ideal candidate will have strong expertise in

SQL ,

data modeling tools (Erwin/ER Studio) , and experience with

cloud data platforms

and

Master Data Management (MDM)

solutions.

Core Responsibilities

Design and maintain

conceptual ,

logical , and

physical

data models aligned with business and technical requirements. Collaborate with

business stakeholders ,

data architects , and

engineering teams

to refine data requirements. Ensure

data integrity ,

normalization , and

performance optimization

across data systems. Document

metadata ,

data lineage , and maintain comprehensive model documentation. Model data for

transactional systems

and

lake house architectures , bridging operational and analytical data layers. Fine-tune

entity models

based on access patterns (e.g.,

Star Schema ,

Graph ,

Document ,

Relational ). Define

domain relationships

and develop

connected entity models

supporting enterprise integration. Key Skills & Qualifications

Proficiency in

SQL

and

data modeling tools

such as

Erwin ,

ER/Studio , or similar. Strong understanding of

normalization ,

dimensional modeling , and

data warehousing concepts . Experience with

relational

and

cloud databases

(e.g., Oracle, PostgreSQL, Snowflake, BigQuery, Redshift). Familiarity with

cloud platforms and services

-

AWS ,

Azure , or

GCP . Hands-on experience with

Master Data Management (MDM)

solutions. Strong analytical and problem-solving skills with attention to detail. Excellent communication and collaboration abilities to work with cross-functional teams. Preferred Qualifications

Exposure to

data lakehouse architectures

(e.g., Databricks, Snowflake, BigQuery). Knowledge of

data governance

and

metadata management

frameworks. Experience with

NoSQL databases

(MongoDB, Neo4j, Cassandra). Understanding of

data security

and

compliance

best practices.