Job Description

Senior Data Modeler (Databricks / Kimball)

Project: Internal Databricks System

Overview: We are seeking a true Data Modeler who specializes in Kimball dimensional modeling to drive the architecture for our client’s platform. This is a hands-on modeling role (80% modeling, 20% ETL/Transformation) where you will be the resident Kimball expert. You will not be responsible for production ingestion or building DBT pipelines; instead, you will architect star schemas, write the complex SQL transformations to validate the business logic in Databricks, and hand off the validated logic to the ETL engineering team.

Core Responsibilities:

• Architect and design star schemas utilizing the Kimball methodology.
• Work directly in Databricks/Spark notebooks to explore data, mock up tables, and write advanced SQL to transform source data into dimensional models.
• Act as a mentor and coach to internal team members transitioning to dimensional modeling.
• Partner with the central data engineering team, providing them with validated SQL and table sketches to deploy into production via DBT.

Must-Haves:

• Expert-level mastery of dimensional modeling (Kimball methodology, Star Schemas).
• Strong hands-on SQL skills specifically for data transformation (We are not looking for someone who only draws ERDs in ERwin. You must be able to write the SQL to populate your models).
• Experience in a Databricks/Spark environment (Highly preferred. Exceptional relational modelers with advanced SQL will be considered if willing to learn Databricks quickly).

Nice-to-Haves:

• Python experience.
• Familiarity with SAP HANA source systems.
• Experience in the manufacturing domain.

Applicants must be authorized to work for any employer in the U.S. Our client is unable to sponsor or take over sponsorship of an employment visa at this time. Principals only.