Data Modeller

Title

Data Modeller

Location

Pune

Exp

5+ yrs

Job Description

Key Responsibilities

• Analyze Finance business requirements and translate them into conceptual, logical, and physical data models.
• Design and develop Master, Transaction, Fact, Dimension, and Data Product models for various Finance domains.
• Work on Finance domains such as General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets, Cost Accounting, and Budgeting.
• Perform source system analysis and develop source-to-target mappings for enterprise applications such as SAP, Movex, and Client.
• Define data quality rules, business definitions, metadata standards, and data modeling guidelines.
• Collaborate with data engineering and development teams to ensure accurate implementation of data models and transformation logic.
• Maintain data dictionaries, data lineage documentation, metadata, and other data design artifacts.
• Participate in data architecture and design reviews to ensure compliance with enterprise data architecture and governance standards.
• Ensure data consistency, integrity, scalability, and alignment with business requirements across Finance data models.

Required Skills & Qualifications

• 6+ years of experience in Data Modeling, Data Architecture, or Data Warehousing.
• Strong hands-on experience in 3NF (Third Normal Form) Data Modeling.
• Excellent knowledge of Dimensional Modeling and Data Warehousing concepts.
• Experience in designing Conceptual, Logical, and Physical Data Models.
• Strong understanding of Fact Tables, Dimension Tables, Master Data, and Transaction Data.
• Good understanding of Finance business processes, including General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cost Accounting, and Budgeting.
• Experience in source system analysis and Source-to-Target Mapping.
• Strong SQL knowledge and understanding of relational database concepts.
• Experience in maintaining data dictionaries, metadata, and data lineage documentation.

Preferred Skills

• Hands-on experience with data modeling tools such as ERWin and ER/Studio.
• Experience with Snowflake, Microsoft Fabric, and Databricks.
• Knowledge of SAP, Movex, Client, or Oracle Finance applications.
• Understanding of enterprise data architecture, data governance, and data quality frameworks.