Data Modeler

Chicago, IL - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Key Responsibilities:

Design and maintain conceptual logical and physical data models supporting trading risk and compliance functions.
Work with Medallion Architecture (Bronze/Silver/Gold layers) to align data models with cloud lakehouse design.
Collaborate with Data Architects and Engineers to translate models into efficient schemas for AWS Spark Parquet Iceberg.
Model time-series reference data market data and transactional flows specific to Finance & Capital Markets.
Define data standards naming conventions and metadata management practices.
Optimize data models for performance scalability and regulatory reporting needs.
Partner with business stakeholders to capture requirements and ensure semantic consistency across domains.

Required Skills & Experience:

Hands-on experience in data modeling tools (Erwin ER/Studio PowerDesigner or similar).
Strong knowledge of relational dimensional and lakehouse modeling techniques.
Experience with Parquet Iceberg and cloud-native data storage formats.
Strong understanding of Finance & Capital Markets data structures (trades positions risk reference/master data).
5 8 years of relevant data modeling experience.

Preferred:

Exposure to AWS data services Databricks Snowflake DBT.
Knowledge of data governance data lineage and regulatory compliance.
Familiarity with Agile delivery model and working with Scrum teams.

Key Responsibilities: Design and maintain conceptual logical and physical data models supporting trading risk and compliance functions. Work with Medallion Architecture (Bronze/Silver/Gold layers) to align data models with cloud lakehouse design. Collaborate with Data Architects and Engineers to tr...