Role : Data Modeler

We are looking for an experienced Data Modeler with strong expertise in data modeling, Databricks, and cloud data platforms. The ideal candidate will have hands-on experience designing scalable data models, building data warehouse solutions, and implementing data governance practices, preferably within the finance domain.

Key Responsibilities :

- Design and maintain conceptual, logical, and physical data models.

- Develop dimensional models using Kimball methodology, Star Schema, fact and dimension tables, and Slowly Changing Dimensions (SCDs).

- Work with Databricks, Delta Lake, Unity Catalog, and Medallion Architecture.

- Write and optimize SQL queries using joins, CTEs, and window functions.

- Develop semantic models, data warehouse structures, and Source-to-Target Mapping (STTM).

- Ensure data quality, consistency, governance, and metadata management.

- Collaborate with data engineering, business, and analytics teams to translate business requirements into data models.

Required Skills :

- 5 - 8 years of experience in data modeling and data warehousing.

- Strong understanding of conceptual, logical, and physical data modeling.

- Hands-on experience with dimensional modeling, Star Schema, fact and dimension tables, and SCDs.

- Working knowledge of Databricks, Delta Lake, Unity Catalog, and Medallion Architecture.

- Strong SQL skills, including joins, CTEs, and window functions.

- Experience with semantic modeling, data mapping, and data governance.

Good to Have :

- Finance domain knowledge, including General Ledger (GL), Revenue, Accounts Payable/Receivable (AP/AR), and Procurement.

- Experience with ERwin, ER/Studio, PowerDesigner, or SQLDBM.

- Exposure to PySpark, Power BI, or Tableau.