Senior Data Modeler: Finance Data Architecture Lead

Pyramid It Consulting; United States; A distancia; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

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

Formación

• 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.

Responsabilidades

• 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.

Conocimientos

3NF modeling

Dimensional modeling

Data warehousing

Finance domain knowledge

Stakeholder collaboration

Herramientas

ERWin

ER/Studio

SQL

Snowflake

Databricks

SAP

Oracle Finance

Microsoft Fabric

Descripción del empleo

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