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.
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.
Similar Jobs
Fintech • Financial Services
Design, implement and maintain conceptual, logical and physical data models for enterprise data products. Translate business requirements into reusable data structures, produce data dictionaries, lineage and mappings, ensure governance and data quality, collaborate with engineering and stakeholders, and support build‑ready architectures and controls.
Top Skills:
Agile CentralCloud PlatformsConfluenceData WarehousingDb2JIRAOracleSQLSQL Server
Agency • Information Technology
Translate business requirements into conceptual, logical, and physical data models; evaluate and optimize existing data systems and metadata; collaborate with development teams on data flows; implement data strategies; assess systems for discrepancies and efficiency. Knowledge of SSIS and banking/credit card domain is preferred.
Top Skills:
HadoopHiveSpark
Information Technology • Software • Business Intelligence • Consulting
Lead logical data modeler responsible for translating business requirements into conceptual, logical and physical data models on Teradata, customizing iLDM models, defining modelling/mapping standards, and guiding model implementation and performance considerations.
Top Skills:
3NfBteqCldmCompressionDimensional ModelingErwinETLFloadFsldmIldmIndexingJoin StrategyMldmMloadQuery TuningRldmTeradataTeradata 12.0Tpump
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
