Data Modeler

Persistent Systems Limited; Pune District; Hybrid; INR 1,200,000 - 2,400,000; Full time

Benefits offered by this job

Competitive salary and benefits

Growth opportunities and education/cs

Cutting-edge technologies

Flexible work hours and engagement

Insurance coverage and wellness

Job summary

Persistent Systems Limited in India is seeking a Data Modeler with 5–8 years of experience to design and maintain enterprise data models, data architectures, and ETL/ELT pipelines to support analytics and reporting. You will collaborate with data engineers, analysts, and architects to implement scalable star and snowflake schemas, ensure data quality, and govern metadata across the organization.

This role offers hybrid work, exposure to cutting-edge technologies, and a pathway for professional

Qualifications

• 5–8 years of experience in Data Modeling, Data Architecture, or Data Engineering roles.
• Proven experience designing enterprise data models for analytics platforms.
• Strong expertise with data modeling tools like ERwin, InfoSphere, ER/Studio, or similar.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models.
• Collaborate with stakeholders to gather data requirements and translate them into data models.
• Develop and optimize dimensional models (star and snowflake) for analytics and reporting.
• Implement and support ETL/ELT data integration processes to ensure data quality.
• Document data lineage, metadata, and data dictionaries; govern data assets.
• Evaluate and improve data models for scalability, performance, and flexibility.
• Partner with data engineering teams to align architecture with implementation.
• Support data warehousing, BI, and analytics initiatives and governance programs.

Skills

Data Modeling

Data Architecture

Data Engineering

SQL

ETL/ELT

Star Schema

Snowflake Schema

Oracle/SQL Server/PostgreSQL

Communication

Education

Bachelor's degree in Computer Science/Related field

Tools

ERwin Data Modeler

IBM InfoSphere Data Architect

ER/Studio

Informatica

Talend

Apache NiFi

Job description

We are an AI-led, platform-driven Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what's next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India, and numerous innovators across the healthcare ecosystem.

Our disruptor's mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We reported $1,654.4M FY26 revenue with 17.4% Y-o-Y growth. We have delivered 24 sequential quarters of growth with $436.0M in Q4 FY26 revenue, up 3.2% Q-o-Q and 16.2% Y-o-Y growth. Our 27,500+ global team members, located in 18 countries, have been instrumental in helping the market leaders transform their industries.

AboutPosition

We are seeking a skilled Data Modeler with strong expertise in data modeling, data architecture, and ETL/ELT engineering to support enterprise data transformation initiatives. The ideal candidate will design and maintain scalable data models that enable analytics, reporting, and business intelligence solutions while ensuring data quality, consistency, and governance across the organization. This role requires a strong understanding of relational and dimensional modeling techniques, data integration frameworks, database technologies, and modern data engineering practices. You will work closely with business stakeholders, data engineers, analysts, and architects to build robust data foundations that support data-driven decision-making.

• Role: Data Modeler
• Location: All Persistent Locations
• Experience: Between 5 to 8 Years
• Job Type: Full Time Employment

WhatYou'llDo

• Design, develop, and maintain conceptual, logical, and physical data models aligned with business requirements.
• Collaborate with business stakeholders, architects, analysts, and engineering teams to gather and analyze data requirements.
• Translate business processes and reporting requirements into scalable and maintainable data models.
• Develop and optimize dimensional models including star schemas and snowflake schemas for analytics and reporting.
• Implement and support ETL/ELT data integration processes to ensure high-quality and consistent data delivery.
• Design and document data lineage, metadata, data dictionaries, and business glossaries.
• Evaluate and improve existing data models for scalability, flexibility, and performance.
• Partner with data engineering teams to ensure alignment between data architecture and implementation.
• Support enterprise reporting, business intelligence, data warehousing, and advanced analytics initiatives.
• Participate in data governance, master data management, and data quality improvement programs.
• Perform data analysis and profiling to identify data issues and recommend corrective actions.
• Create technical documentation, standards, and best practices for data modeling and integration.
• Stay updated on industry trends, emerging technologies, and modern data architecture practices.

ExpertiseYou'llBring

• 5-8 years of experience in Data Modeling, Data Architecture, or Data Engineering roles.
• Proven experience designing enterprise data models for large-scale business applications and analytics platforms.
• Strong expertise with data modeling tools such as ERwin Data Modeler, IBM InfoSphere Data Architect, ER/Studio, Similar enterprise modeling solutions.
• Strong understanding of Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Relational Data Modeling, Dimensional Data Modeling.
• Expertise in designing Star Schema and Snowflake Schema architectures.
• Hands-on experience with ETL/ELT tools and frameworks including Informatica, Talend, Apache NiFi, Similar integration platforms.
• Strong SQL development and query optimization skills.
• Experience working with enterprise databases such as Oracle, SQL Server, PostgreSQL.
• Strong understanding of Data Warehousing concepts and best practices.
• Knowledge of data integration, transformation, and migration methodologies.
• Experience with metadata management and data lineage documentation.
• Strong analytical, troubleshooting, and problem-solving capabilities.
• Excellent communication and stakeholder engagement skills.
• Ability to explain complex technical concepts to both technical and non-technical audiences.
• Experience working within Agile and cross-functional delivery teams.
• 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

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."