Data modeler- Remote opportunity

Pyramid It Consulting; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Pyramid It Consulting is seeking a Data Modeler to design and enhance enterprise data models for UDM reporting, analytics, and data products. The role collaborates with Business Analysts, Data Engineers, and stakeholders to translate requirements into scalable data models.

The ideal candidate will have strong 3NF and dimensional modeling experience, plus hands-on work with ERWin/ER/Studio, SQL, Snowflake, and ERP applications.

Qualifications

• Strong experience in 3NF modeling and dimensional modeling for data warehouses.
• Understanding of Finance processes: Chart of Accounts, Cost Centers, Profit Centers, Budget vs. Actuals.
• Hands-on with ER/Studio/ERWin, SQL, Snowflake, Databricks, SAP, Oracle Finance applications.

Responsibilities

• Analyze Finance requirements and develop conceptual, logical, and physical data models.
• Design data models for General Ledger, Accounts Payable/Receivable, Fixed Assets, and Budgeting.
• Perform source-to-target mappings for ERP systems (SAP, Movex, OracleCuston ERP).
• Define data quality rules, metadata standards, and data dictionaries.
• Collaborate with engineers to implement data models and transformation logic.
• Maintain data lineage documentation and design artifacts.

Skills

Data modeling

3NF modeling

Dimensional modeling

Data warehousing concepts

Finance domain knowledge

Tools

ERWin

ER/Studio

SQL

Snowflake

Microsoft Fabric

Databricks

SAP

Oracle Finance

Job description

Position : Data modeler

Location : Remote

Estimated Start :1-2 Weeks

Job Description:

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.