Senior Data Modeler

Pyramid It Consulting; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Pyramid It Consulting in the United States is seeking a Data Modeler to design and enhance enterprise data models that support DBU UDM reporting, analytics, and data products. You will collaborate with stakeholders, Business Analysts, and Data Engineers to translate business requirements into scalable, high-quality data models.

The role emphasizes 3NF and dimensional modeling, data warehousing concepts, and governance standards, with hands-on work on ERWin, SQL, Snowflake, and related tools to

Qualifications

• Strong experience in 3NF modeling, dimensional modeling, and data warehousing concepts.
• Good understanding of Finance processes and related accounting principles.
• Hands-on experience with data modeling tools and platforms including SAP, Snowflake, and SQL.

Responsibilities

• Analyze business requirements and develop enterprise data models for DBU UDM reporting and data products.
• Design Master, Transactions, fact, dimension and data product related models for Finance domains (GL, AP, AR, FA, Cost Accounting, Budgeting).
• Perform source system analysis and map sources for ERP systems such as SAP, Movex, and Oracle.
• Define data quality rules, metadata standards, and governance artifacts.
• Collaborate with engineering teams to implement data models and transformation logic.
• Maintain data dictionaries, lineage documentation, and design artifacts.
• Participate in design reviews and ensure compliance with enterprise data architecture standards.

Skills

3NF modeling

Dimensional modeling

Data warehousing

Finance domain knowledge

Stakeholder collaboration

Tools

ERWin

ER/Studio

SQL

Snowflake

Databricks

SAP

Oracle Finance

Microsoft Fabric

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.