Data Modeler

Hybrid in Chicago, IL, US • Posted 5 days ago • Updated 16 hours ago
Contract Corp To Corp
Contract Independent
Contract W2
Able to Sponsor
Hybrid
$50+
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

  • Data Modeling
  • Medallion Architecture
  • Cloud
  • AWS
  • Erwin
  • ER/Studio
  • Finance
  • Capital Markets
  • Banking

Summary

Data Modeler

Location: Chicago, IL (2-3 days onsite a week)

Duration: 12 months

Teck Stack: Data Modeling Tools, Medallion Architecture, Cloud (AWS), Exp with Logical & Physical data models

Position Overview:

We are looking for a Data Modeler with strong expertise in designing, optimizing, and maintaining conceptual, logical, and physical data models for financial data. The candidate will work closely with data architects, engineers, and business stakeholders to ensure data integrity, performance, and alignment with domain-specific needs in Financial or Capital Markets.

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:

  • 5 8 years of relevant data modeling 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).

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91094056
  • Position Id: 8958669
  • Posted 5 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Chicago, Illinois

Today

Easy Apply

Contract

$0.00 - $70.00 per hour

Hybrid in Chicago, Illinois

Today

Easy Apply

Contract

70 - 75

Hybrid in Chicago, Illinois

Yesterday

Easy Apply

Contract

Depends on Experience

Chicago, Illinois

2d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs