Remote Finance Data Modeler: Silver/Gold Lakehouse

Aumnitech LLC; Illinois; Remote; USD 83,000 - 118,000; Full time

Job summary

Aumnitech LLC is seeking a Data Modeler to design and develop the Gold and Silver layers of a lakehouse data model in Snowflake, focusing on Finance data such as General Ledger and Trial Balance. You will drive data modeling approaches and ensure extensibility across layers.

Responsibilities include leading workshops with clients, assessing current data models, and delivering a future-state Finance data model that meets client requirements using 3NF, Star/Snowflake schemas, and cross-source

Qualifications

• Experience building Gold/Silver layer data models for finance (GL and TB).
• Experience with data ingested from SAP, Oracle, JD Edwards.
• Familiarity with Snowflake and medallion architecture concepts.

Responsibilities

• Develop logical and physical data models for Silver and Gold layers in a lakehouse.
• Lead client workshops to define future state Finance data model focusing on GL and Trial Balance.

Skills

Data modeling

Finance domain

Snowflake

3NF / Star schema

Leadership in client workshops

Medallion architecture knowledge

Tools

Snowflake

SAP

Oracle

JD Edwards

Job description

Aumnitech LLC is seeking a Data Modeler to design and develop the Gold and Silver layers of a lakehouse data model in Snowflake, focusing on Finance data such as General Ledger and Trial Balance. You will drive data modeling approaches and ensure extensibility across layers.

Responsibilities include leading workshops with clients, assessing current data models, and delivering a future-state Finance data model that meets client requirements using 3NF, Star/Snowflake schemas, and cross-source