Data Modeler

Right Advisors; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Right Advisors Private Limited, based in Faridabad, India, is seeking a data modelling specialist to design and maintain data models for Data Products across multiple domains. The role involves translating business requirements into data entities, ensuring reuse, scalability and governance, and collaborating with engineering and governance teams.

The ideal candidate will have hands-on experience with relational databases (Oracle/DB2/SQL Server), data warehousing, and strong communication to both

Qualifications

• Strong experience in data modelling (conceptual, logical and physical) within complex data environments.
• Proven experience supporting Data Products, analytics platforms or enterprise data initiatives.
• Solid understanding of relational data design, joins, cardinality, history management and data integrity.
• Hands-on experience in relational databases like Oracle or DB2 or SQL Server etc
• Experience with Data Warehousing
• Experience of working within a System Development Lifecycle (SDLC) and Agile project environment (Agile Central, JIRA, Confluence)
• Experience working with Cloud Platforms.

Responsibilities

• Design and maintain conceptual, logical and physical data models to support Data Products across multiple business domains.
• Translate business requirements into well-structured data entities, attributes and relationships.
• Ensure data models support reuse, scalability, audibility and long-term sustainability.
• Apply appropriate modelling techniques including normalization, dimensional modelling, history handling and audit attributes.
• Partner with business and control stakeholders to understand data requirements, use cases and reporting needs.
• Perform data discovery across source systems and existing datasets to inform target-state design.
• Produce clear data dictionaries, mappings and lineage artifacts to support build and testing.
• Ensure data models align to enterprise data governance standards including data quality, data ownership, privacy and records management.
• Embed controls and design principles that support regulatory, audit and risk expectations.
• Support data issue analysis and remediation through strong understanding of underlying data structures.
• Work closely with engineering, architecture and platform teams to ensure data models are build-readied and technically feasible.
• Act as a trusted data design partner within delivery teams, providing clarity on data semantics and design intent.
• Contribute to continuous improvement of data modelling standards, templates and best practices.
• Strong experience in data modelling (conceptual, logical and physical) within complex data environments.
• Proven experience supporting Data Products, analytics platforms or enterprise data initiatives.
• Solid understanding of relational data design, joins, cardinality, history management and data integrity.
• Hands-on experience producing data mappings, data dictionaries and lineage documentation.
• Hands-on experience in relational databases like Oracle or DB2 or SQL Server etc
• Experience with Data Warehousing
• Strong analytical and problem-solving skills with high attention to detail.
• Ability to communicate complex data concepts clearly to both technical and non-technical stakeholders.
• Experience working in regulated environments (e.g. risk, compliance, finance, controls).
• Exposure to large-scale data platforms, modern data architectures or cloud ecosystems.
• Familiarity with data governance, data quality frameworks and privacy considerations.
• Experience supporting data modernization or legacy platform migration initiatives.
• Experience of working within SDLC and Agile project environment (SDLC, Agile Central, JIRA, Confluence)
• Experience working with Cloud Platforms.

Skills

Data Modeling

Data Profiling

SQL Queries/ Oracle

Job description

Right Advisors Private Limited is a human resource consulting and staffing organization based in Faridabad, India, providing recruitment and managed HR services to businesses across multiple industries. The company focuses on building long‑term partnerships with clients by delivering cost‑effective talent acquisition and workforce management solutions.

Their services include recruitment, contract staffing, payroll management, executive search, and recruitment process outsourcing (RPO). With a solutions‑based consulting approach, the firm combines management consulting practices with flexible staffing models to help organizations improve productivity and focus on core business operations.

Right Advisors supports companies in building high‑performance teams through talent acquisition, assessment, and development services.

Job Description

Exp-8-14 Yrs

Location -Pune

Mandatory Skills

Data Modeling,Data Profiling, SQl Queries/ Oracle

Key Responsibilities

Data Modeling & Data Product Design

• Design and maintain conceptual, logical and physical data models to support Data Products across multiple business domains.
• Translate business requirements into well‑structured data entities, attributes and relationships.
• Ensure data models support reuse, scalability, audibility and long‑term sustainability.
• Apply appropriate modelling techniques including normalization, dimensional modelling, history handling and audit attributes.

Data Discovery & Requirements Translation

• Partner with business and control stakeholders to understand data requirements, use cases and reporting needs.
• Perform data discovery across source systems and existing datasets to inform target‑state design.
• Produce clear data dictionaries, mappings and lineage artifacts to support build and testing.

Data Governance & Quality

• Ensure data models align to enterprise data governance standards including data quality, data ownership, privacy and records management.
• Embed controls and design principles that support regulatory, audit and risk expectations.
• Support data issue analysis and remediation through strong understanding of underlying data structures.
• Work closely with engineering, architecture and platform teams to ensure data models are build‑ready and technically feasible.
• Act as a trusted data design partner within delivery teams, providing clarity on data semantics and design intent.
• Contribute to continuous improvement of data modelling standards, templates and best practices.
• Strong experience in data modelling (conceptual, logical and physical) within complex data environments.
• Proven experience supporting Data Products, analytics platforms or enterprise data initiatives.
• Solid understanding of relational data design, joins, cardinality, history management and data integrity.
• Hands‑on experience producing data mappings, data dictionaries and lineage documentation.
• Hands‑on experience in relational databases like Oracle or DB2 or SQL Server etc
• Experience with Data Warehousing
• Strong analytical and problem‑solving skills with high attention to detail.
• Ability to communicate complex data concepts clearly to both technical and non‑technical stakeholders.
• Experience working in regulated environments (e.g. risk, compliance, finance, controls).
• Exposure to large‑scale data platforms, modern data architectures or cloud ecosystems.
• Familiarity with data governance, data quality frameworks and privacy considerations.
• Experience supporting data modernization or legacy platform migration initiatives.
• Experience of working within a System Development Lifecycle (SDLC) and Agile project environment (Agile Central, JIRA, Confluence)
• Experience working with Cloud Platforms.