Data Modeler

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

Data Modeler

Full Time/Remote (Chicago Preferred)

6+ months

Pay range - $73/hour on W2

Role Description:

Work with functional resources to develop the logical and physical data model for the \"Silver\" and \"Gold\" layer of a Lakehouse architecture on Snowflake. Define the data modeling approaches for each layer, and identify practices to make the models extensible. Analyze existing data model to identify inefficiencies, and bring in leading practices perspective for Finance Data Modeling

Primary Responsibilities:

• Develop logical and physical data model for \"Silver\" and \"Gold\" layer of a medallion data warehouse architecture. Look at the client's existing data model and assess for \"fit for use\".
• Lead client workshops to understand pain points with current state and develop a future state Finance data model, primarily with General Ledger and Trial Balance data.

Required qualifications, skills or experience needed:

• Developing \"Gold\"and \"Silver\" layer data models for the finance domain, especially General Ledger and Trial Balance data.
• Experience in modelling data ingested from sources such as SAP, Oracle, JD Edwards.
• Experience using various data modelling tools.
• Firm grasp of various data modelling practices (e.g., 3NF, Snowflake, Star) and ability to customize a data model to meet the client requirements.
• Define leading practices for data modeling by each layer of the medallion architecture.
• Bring thought leadership and direction to the working sessions (not just take input to create the model).
• Familiarity with Snowflake preferred.