Remote Data Modeler – Finance & Data Warehousing

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

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.