Senior Data Modeler

Pyramid It Consulting; Pune District; On-site; INR 1,000,000 - 2,000,000; Full time

Job summary

Pyramid IT Consulting in Pune, India, seeks a Data Modeler to design and enhance enterprise data models for DBU UDM reporting, analytics, and data products. You will collaborate with stakeholders, Business Analysts and Data Engineers to translate business requirements into scalable data models.

Responsibilities include analyzing finance requirements, modeling for General Ledger, Accounts Payable, Accounts Receivable, and budgeting; performing source-to-target mappings for ERP systems like SAP

Qualifications

• Experience in 3NF modeling, dimensional modeling, and data warehousing concepts.
• Understanding of finance processes: Chart of Accounts, Cost Centers, Profit Centers, Financial Statements, Budget vs. Actuals.
• Hands-on with ERWin, ER/Studio, SQL, Snowflake, Microsoft Fabric, Databricks, SAP or Oracle Finance apps.

Responsibilities

• Analyze finance requirements and develop conceptual, logical, and physical data models.
• Design master, transactions, fact, dimension and data product models for finance domains such as General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cost Accounting, and Budgeting.
• Perform source system analysis and mappings for ERP systems such as SAP, Movex (IBM AS400), BMS (Oracle Custon ERP).
• Define data quality rules, business definitions, and metadata standards.
• Collaborate with engineering teams to ensure accurate implementation of data models and transformation logic.
• Maintain data dictionaries, data lineage documentation, and design artifacts.
• Participate in design reviews and ensure adherence to enterprise data architecture and governance standards.

Skills

3NF modeling

Dimensional modeling

Data warehousing

Tools

ERWin

ER/Studio

SQL

Snowflake

Microsoft Fabric

Databricks

SAP

Oracle Finance

Job description

Role & responsibilities

The Data Modeler will be responsible for designing and enhancing enterprise data models that support DBU UDM (Unified Data Model) reporting, analytics, and data products.
The role will work closely with functional stakeholders, Business Analysts, and Data Engineers to translate business requirements into scalable, high-quality data models.

Key Responsibilities:

• Analyze Finance business requirements and develop conceptual, logical, and physical data models.
• Design Master, Transactions, fact ,dimension and Data products related models for Finance domains such as General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cost Accounting, and Budgeting.
• Perform source system analysis and develop source-to-target mappings for ERP systems such as SAP, Movex (IBM AS400), BMS (Oracle Custon ERP)..
• Define data quality rules, business definitions, and metadata standards.
• Collaborate with engineering teams to ensure accurate implementation of data models and transformation logic.
• Maintain data dictionaries, data lineage documentation, and design artifacts.
• Participate in design reviews and ensure adherence to enterprise data architecture and governance standards.

Preferred Qualifications:

• Strong experience in 3NF modeling, dimensional modeling, and data warehousing concepts.
• Good understanding of Finance processes, including Chart of Accounts, Cost Centers, Profit Centers, Financial Statements, Budget vs. Actuals, and accounting principles.
• Hands-on experience with tools and platforms such as ERWin, ER/Studio, SQL, Snowflake, Microsoft Fabric, Databricks, SAP, or Oracle Finance applications.