Data

Job summary:

Title:

Data Modeler - Hybrid

Location:

Chicago, IL, USA

Length and terms:

Long term - W2 or C2C

Position created on 10/14/2025 08:15 pm

Job description:

* Webcam interview; * Long term project Hybrid

Job Description

We are seeking an experienced Data Modeler with strong expertise in designing, optimizing, and maintaining conceptual, logical, and physical data models for financial data in the Capital Markets domain. You will collaborate closely with data architects, engineers, and business stakeholders to ensure data integrity, performance, and alignment with domain-specific needs.

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, and Iceberg environments.

• 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 with data modeling tools such as 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 including trades, positions, risk, and master data.

• 5-8 years of relevant data modeling experience.

Skills required:

• Data modeling (Erwin, ER/Studio, PowerDesigner, or similar)

• Relational, dimensional, and lakehouse modeling

• Cloud-native data storage formats (Parquet, Iceberg)

• Financial & Capital Markets data knowledge (trades, risk, reference data)

• Experience with AWS, Databricks, Snowflake, DBT (Preferred)

• Data governance, lineage, regulatory compliance (Preferred)

• Agile / Scrum environment (Preferred)

Preferred:

• Exposure to AWS data services, Databricks, Snowflake, DBT.

• Knowledge of data governance, data lineage, and regulatory compliance.

• Familiarity with Agile delivery models and Scrum teams.

Contact the recruiter working on this position:

The recruiter working on this position is Hima Teja(Shaji Team)

His/her contact number is +(1) (202) 6290353 His/her contact email is [email protected]

Our recruiters will be more than happy to help you to get this contract.