Senior Data Modeler

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

Let's unleash your full potential at Persistent - persistent.com/careers

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