Data Modelling Engineer
Core
Design scalable, production-ready data models for financial datasets on Databricks and perform early-stage analysis to ensure data consistency before pipeline integration.
Role type
Senior IC data modelling engineer (financial data)
Builds
Scalable data models (tables, relationships, hierarchies) on Databricks Delta Lake
Domain
Financial services / Capital Markets / Data Engineering
Deliverable
production ML models
Required skills
Relational and dimensional modelling, SQL, Databricks (Delta Lake, Unity Catalog), Python, Git, Financial data modelling
Preferred skills
PySpark, XML/JSON schema formats, Snowflake or Palantir Foundry, Excel, Investment qualifications (CFA)
Technologies
Databricks, Delta Lake, Unity Catalog, Python, SQL, Git, PySpark, Snowflake, Palantir Foundry
Responsibilities
Design and maintain scalable data models on Databricks using Delta Lake and Lakehouse architecture; Profile new index, pricing, reference, ESG, and research datasets to understand structure and fields; Identify inconsistencies, missing fields, formatting issues, or schema gaps; Define source-to-target mappings, schemas and handling rules for ETL/ELT pipelines; Test sample data against models to validate mappings and assumptions; Use Unity Catalog to support governance, lineage and traceability; Document field definitions, data relationships, and handling rules; Review provider schema updates and adjust models when needed.
Seniority
Senior, hands-on IC
