Senior Data Modeler

Persistent; Pune District, Chennai District, Bengaluru; On-site; INR 3,000,000 - 5,500,000; Full time

Benefits offered by this job

Competitive salary

Growth opportunities

Cutting-edge technology

Wellness program

Insurance coverage

Job summary

Persistent 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 and physical models, canonical schemas, and semantic layers to enable governed, reusable data assets across domains.

You will collaborate with Data Engineering for Lakehouse implementations, define entity relationships, create ERDs and data dictionaries, and drive data lineage and metadata governance across the

Qualifications

• Design and implement scalable data models (logical, physical, dimensional) for analytics and AI/ML.
• Define canonical schemas and semantic layers across enterprise data assets.
• Establish data standards, ER diagrams, and data dictionaries for governance.

Responsibilities

• Design and develop data models (OLTP/OLAP) and dimensional schemas.
• Build canonical models and semantic layers for enterprise data products.
• Collaborate with Data Engineering on Databricks Lakehouse implementation.
• Define STM, data transformations, and ensure data quality and lineage.
• Translate business needs into scalable, reusable data models and ontologies.

Skills

Data Modeling

Dimensional modeling

OLTP/OLAP

Azure Databricks

SQL

PySpark

Data governance

Tools

Azure Databricks

ADLS

ADF

Synapse

Purview / Unity Catalog

Databricks SQL

Job description

About Position:

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
• Location: Bangalore, Pune & Chennai
• 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:
• Azure Databricks (mandatory)
• SQL, Databricks SQL / PySpark (data understanding)
• Azure Data Services (ADLS, ADF, Synapse)
• Data Warehousing / Lakehouse architectures
• Data lineage, metadata, and catalog tools (Purview / Unity Catalog)
• Strong understanding of:
• Data governance, data quality, and modeling best practices

Benefits:

• 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
• Annual health check-ups
• 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."