Data Modeler for Enterprise Analytics and Reporting

Infosys; Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Infosys seeks a Data Modeler to design conceptual, logical, and physical data models for analytics and reporting. You will build dimensional models using Star Schema and refine logical models with clear entities, relationships, and business definitions.

You will produce physical models aligned to performance and scalability needs, define keys and data standards, and collaborate with engineering and BI teams to ensure successful handoffs.

Qualifications

• Experience analytics, reporting, or data platform modeling.
• Hands-on Star Schema, logical and physical data modeling.
• Translate business requirements into clear data structures and documentation.

Responsibilities

• Gather and analyze business requirements to design conceptual, logical, and physical data models.
• Create and maintain dimensional models using Star Schema to support analytics and reporting use cases.
• Develop and refine logical data models with clear entities, relationships, and business definitions.
• Produce physical models aligned to target platforms, considering performance, storage, and scalability needs.
• Define keys, constraints, normalization/denormalization strategies, and data standards to ensure consistency and quality.
• Partner with engineering and BI teams to validate models, resolve data issues, and support implementation handoffs.
• Maintain documentation, data dictionaries, and model versioning to ensure traceability and reuse.
• Participate in design reviews and contribute to best practices for enterprise data modeling and governance.

Skills

SQL

Data Warehousing

ETL Concepts

Data Governance

Metadata Management

Education

BTECH, MTECH, MCA, MSC (or equivalent)

Job description

Data Modeling Good to have skills: SQL, Data Warehousing, ETL Concepts, Data Governance, Metadata Management

Preferred Qualifications:

• Experience modeling for enterprise data warehouses/lakes and supporting multiple downstream consumers (BI, analytics, data science).
• Proven ability to optimize models for performance and usability, balancing normalization and denormalization trade-offs.
• Familiarity with data governance practices such as naming standards, metadata management, and stewardship collaboration.
• Strong stakeholder communication skills, including facilitating requirement workshops and presenting model designs.
• Experience working in Agile delivery teams and contributing to iterative model evolution and change management.

Key Responsibilities:

• Gather and analyze business requirements to design robust conceptual, logical, and physical data models.
• Create and maintain dimensional models using Star Schema to support analytics and reporting use cases.
• Develop and refine logical data models with clear entities, relationships, and business definitions.
• Produce physical models aligned to target platforms, considering performance, storage, and scalability needs.
• Define keys, constraints, normalization/denormalization strategies, and data standards to ensure consistency and quality.
• Partner with engineering and BI teams to validate models, resolve data issues, and support implementation handoffs.
• Maintain documentation, data dictionaries, and model versioning to ensure traceability and reuse.
• Participate in design reviews and contribute to best practices for enterprise data modeling and governance.

Minimum Qualifications:

• Education: BTECH, MTECH, MCA, MSC (or equivalent).
• 3–5 years of experience in data modeling for analytics, reporting, or data platform initiatives.
• Hands-on expertise in Star Schema, Logical Data Modeling, and Physical Modeling.
• Strong understanding of relational concepts, entity-relationship modeling, and dimensional modeling principles.
• Ability to translate business requirements into clear, implementable data structures and documentation.