Job Purpose
We are seeking an experienced Data Modeler to transform UI application designs into optimized, high-performance data models using Databricks as our data layer platform. The ideal candidate will possess deep expertise in relational database design, dimensional modeling, and performance optimization techniques to ensure our data architecture supports seamless application functionality and delivers exceptional query performance
Desired Skills And Experience
- 5+ years of experience in data modeling, database design, and schema development
- Proven experience with Databricks platform, including Delta Lake, Unity Catalog, and SQL Analytics
- Strong expertise in relational database concepts including normalization (1NF through 5NF), denormalization strategies, and when to apply each approach
- Proficiency in dimensional modeling techniques (star schema, snowflake schema, fact and dimension tables)
- Advanced SQL skills with experience writing complex queries, stored procedures, and performance optimization
- Experience translating application requirements and UI designs into database schemas and data structures
- Hands-on experience with data modeling tools (e.g., ERwin, PowerDesigner, dbForge Studio, or similar)
- Strong understanding of indexing strategies, query optimization, and performance tuning in distributed systems
- Excellent communication skills with ability to explain complex technical concepts to non-technical stakeholders
Key Responsibilities
- Transform UI application designs and wireframes into comprehensive data models, ensuring all application requirements are accurately reflected in the database schema
- Design and maintain relational data models with proper normalization, ensuring data integrity through well-defined primary keys, foreign keys, and referential constraints
- Establish and maintain accurate relationships between tables including one-to-one, one-to-many, and many-to-many relationships to support complex application workflows
- Optimize data models for performance by implementing appropriate indexing strategies, partitioning schemes, and data types specific to Databricks Delta Lake architecture
- Collaborate with UI/UX designers, front-end developers, and business analysts to understand application functionality and translate requirements into efficient data structures
- Design both transactional (OLTP) and analytical (OLAP) models within Databricks, leveraging Medallion architecture (Bronze, Silver, Gold layers) where appropriate
- Create and maintain comprehensive data modeling documentation including entity-relationship diagrams (ERDs), data dictionaries, and data lineage maps
- Implement data quality rules and constraints to ensure data consistency and accuracy across the platform
- Conduct performance tuning and query optimization, analyzing query execution plans and recommending schema modifications to improve application responsiveness
- Stay current with Databricks best practices, Delta Lake features, and emerging data modeling patterns in cloud-based data platforms
