Data Modeling Engineer
Core
Design and maintain data models for financial datasets to ensure they are structured correctly and ready for downstream use in investment decision-making.
Role type
Data Modeling Engineer
Builds
Data models (tables, relationships, hierarchies) for index, pricing, reference, and research data
Domain
Capital Markets / Financial Data
Deliverable
production ML models | product features
Required skills
Conceptual, logical, and physical data modeling; Relational and dimensional modeling; SQL; Python for profiling/validation; Git version control; Financial data modeling
Preferred skills
XML, JSON, schema definition languages; Databricks, Foundry, Snowflake, Parquet; Excel for exploratory data assessment; CFA Level II or higher
Technologies
SQL, Python, Git, Databricks, Foundry, Snowflake, Parquet, XML, JSON
Responsibilities
Inspect new datasets to understand structure, fields, and data types; Identify inconsistencies, missing fields, or schema gaps; Build and update data models based on real dataset behavior; Test sample data against models to ensure mappings and transformations are correct; Work with Data Engineering to translate models into ETL/ELT-ready schemas; Document field definitions, data relationships, and handling rules; Review provider schema updates and adjust models accordingly; Support data quality improvements by applying model-level fixes
Seniority
Mid-level, hands-on IC
