The Role
Designs and maintains conceptual, logical, and physical data models for enterprise data products. Translates business requirements into scalable, governed data structures; performs data discovery, profiling, mapping, and lineage documentation. Ensures data quality, privacy, auditability, and regulatory alignment. Collaborates with engineering, architecture, platform, and business stakeholders to deliver build-ready models and improve modeling standards. Supports data warehousing, modernization, migration, and Agile delivery initiatives.
Summary Generated by Built In
Exp-8-14 Yrs
Location -Pune
Mandatory Skills- Data Modeling,Data Profiling, SQl Queries/ Oracle
Key Responsibilities
Data Modeling & Data Product Design
o Design and maintain conceptual, logical and physical data models to support Data Products across multiple business domains.
o Translate business requirements into well-structured data entities, attributes and relationships.
o Ensure data models support reuse, scalability, audibility and long-term sustainability.
o Apply appropriate modelling techniques including normalization, dimensional modelling, history handling and audit attributes.
Data Discovery & Requirements Translation
o Partner with business and control stakeholders to understand data requirements, use cases and reporting needs.
o Perform data discovery across source systems and existing datasets to inform target-state design.
o Produce clear data dictionaries, mappings and lineage artifacts to support build and testing.
Data Governance & Quality
o Ensure data models align to enterprise data governance standards including data quality, data ownership, privacy and records management.
o Embed controls and design principles that support regulatory, audit and risk expectations.
o Support data issue analysis and remediation through strong understanding of underlying data structures.
Collaboration & Delivery
o Work closely with engineering, architecture and platform teams to ensure data models are build-ready and technically feasible.
o Act as a trusted data design partner within delivery teams, providing clarity on data semantics and design intent.
o Contribute to continuous improvement of data modelling standards, templates and best practices.
Essential Skills & Experience
o Strong experience in data modelling (conceptual, logical and physical) within complex data environments.
o Proven experience supporting Data Products, analytics platforms or enterprise data initiatives.
o Solid understanding of relational data design, joins, cardinality, history management and data integrity.
o Hands-on experience producing data mappings, data dictionaries and lineage documentation.
o Hands-on experience in relational databases like Oracle or DB2 or SQL Server etc
o Experience with Data Warehousing
o Strong Data Analysis & Profiling skills
o Strong analytical and problem-solving skills with high attention to detail.
o Ability to communicate complex data concepts clearly to both technical and non-technical stakeholders.
Desirable Skills & Experience
o Experience working in regulated environments (e.g. risk, compliance, finance, controls).
o Exposure to large-scale data platforms, modern data architectures or cloud ecosystems.
o Familiarity with data governance, data quality frameworks and privacy considerations.
o Experience supporting data modernization or legacy platform migration initiatives.
o Experience of working within a System Development Lifecycle (SDLC) and Agile project environment (Agile Central, JIRA, Confluence)
o Experience working with Cloud Platforms.
Skills Required
- 8-14 years of professional experience
- Strong experience with conceptual, logical, and physical data modeling
- Experience supporting data products, analytics platforms, or enterprise data initiatives
- Strong understanding of relational data design, joins, cardinality, history management, and data integrity
- Hands-on experience creating data mappings, data dictionaries, and lineage documentation
- Hands-on experience with relational databases such as Oracle, DB2, or SQL Server
- Experience with data warehousing
- Strong data analysis and data profiling skills
- Strong analytical and problem-solving skills with attention to detail
- Ability to communicate complex data concepts to technical and non-technical stakeholders
- Experience working in regulated environments such as risk, compliance, finance, or 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 with SDLC and Agile project environments, including Agile Central, JIRA, or Confluence
- Experience working with cloud platforms
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Right Advisors Private Limited is a Faridabad-based human resource consulting and staffing organization serving businesses across multiple industries. Its services include recruitment, contract staffing, payroll management, executive search, recruitment process outsourcing, and workforce management. The company uses a solutions-based consulting approach and flexible staffing models to help clients improve productivity, build high-performance teams, and focus on their core operations.
