Senior Data Modeler

Persistent Systems; Bengaluru; Hybrid; INR 2,500,000 - 4,000,000; Full time

Benefits offered by this job

Hybrid work

Flexible hours

Tuition reimbursement

Job summary

Persistent Systems is seeking a Senior Data Modeler to design scalable enterprise data models for analytics, reporting, and AI/ML use cases on Azure Databricks. You will develop logical, physical, and canonical models and enable reusable data assets across domains.

You will work with data governance, lineage, and metadata frameworks, collaborating with Data Engineering for Lakehouse/Databricks implementations, and translate business requirements into scalable models.

Qualifications

• Experience designing conceptual, logical and physical data models.
• Proficiency with OLTP/OLAP and dimensional modeling.
• Ability to define data standards and ensure governance across domains.
• Familiarity with data lineage, metadata management and data catalogs.

Responsibilities

• Design and develop logical, physical, and dimensional data models (OLTP/OLAP).
• Build canonical data models and semantic layers for enterprise data products.
• Define entity relationships, schemas and data standards across domains.

Skills

Data Modeling

Star/Snowflake schema

Data Warehousing

Data lineage

Metadata/catalog tools

Data governance

Data quality

Tools

Purview

Unity Catalog

Databricks

Job description

We are seeking a Senior Data Modeler to design and implement scalable, high-quality enterprise data models supporting analytics, reporting, and AI/ML use cases on Azure Databricks platforms. This role will be responsible for developing logical and physical data models, canonical schemas, and semantic layers, enabling consistent, governed, and reusable data assets across domains. A strong data model is foundational for integrating complex datasets (claims, provider, member) and enabling advanced analytics and AI-driven decisioning.

• Role: Senior Data Modeler
• Experience: 6 to 10 Years
• Job Type: Full-Time Employment

What You'll Do:

• Design and develop logical, physical, and dimensional data models (OLTP / OLAP)
• Build canonical data models and semantic layers for enterprise data products
• Define entity relationships, schemas, and data standards across domains
• Create and maintain ER diagrams (ERD) and data dictionaries
• Support Medallion architecture (Bronze / Silver / Gold layers)
• Drive source-to-target mapping (STM) and data transformation design
• Ensure data quality, consistency, and standardization across datasets
• Collaborate with Data Engineering teams for Data Lakehouse implementation (Databricks)
• Enable data lineage, metadata management, and governance frameworks
• Translate business requirements into scalable and reusable data models
• Well-defined data models enable cross-domain integration, consistent semantics, and scalable analytics outcomes.

Expertise You'll Bring:

• Data Modeling (Conceptual, Logical, Physical, Dimensional)
• Star/Snowflake schema design and normalization techniques
• Hands-on experience with:
• Data Warehousing / Lakehouse architectures
• Data lineage, metadata, and catalog tools (Purview / Unity Catalog)
• Strong understanding of:
• Data governance, data quality, and modeling best practices
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.