Data Modeler, Databricks

Databricks Data Modeler | Contract | Midtown NYC (Hybrid)

A leading global banking firm is looking for a hands-on Databricks Data Modeler to join its corporate technology team on a contract basis. You will design the data models behind a modern Azure Databricks lakehouse, turning complex data from HR, Compliance, Legal, Finance and Facilities into structured, trusted datasets that power reporting, analytics and AI.

This is a hands-on role with real ownership. You will sit between the business and the data engineers, shaping how the data is structured and making sure it is clear, consistent and easy to use.

What you'll do

• Design logical, physical and dimensional data models on Databricks and Delta Lake


• Build curated, gold-layer datasets that serve reporting, analytics and AI use cases


• Partner with data engineers and BI developers to deliver efficient, well-governed models


• Work directly with business stakeholders to turn requirements into clear, documented data models


• Set data standards, naming conventions and documentation across the lakehouse

What you'll bring

• 5-7 years of hands-on data modelling experience in an enterprise environment


• Strong dimensional modelling skills (star schema, slowly changing dimensions) and advanced SQL


• Hands-on experience with Databricks, including Delta Lake and Unity Catalog


• Experience with corporate or sensitive data such as HR, Compliance, Legal or Finance


• Excellent communication skills, with confidence presenting to business stakeholders

Nice to have: Financial services experience, Azure Data Factory, Python/PySpark, Power BI familiarity, Databricks or Microsoft certification
Location: Midtown NYC, 3 days onsite (hybrid)
Contract: $70-90/hr

Interested?

Oscar Associates Limited (US) is acting as an Employment Agency in relation to this vacancy.