Urgent Requirement :: Sr. Data Modeler :: Hybrid (Chicago, IL)

0 views
Skip to first unread message

Tushar Chauhan

unread,
2:56 PM (8 hours ago) 2:56 PM
to Tushar Chauhan
Hello, 
Please find the job description for the position of Data Architect below, and kindly let me know if you are interested or would like to proceed further.

Data Modeler (Finance & Capital Markets Project)

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

 

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

 

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 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:

  • 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.

Tushar Chauhan

unread,
4:23 PM (6 hours ago) 4:23 PM
to Tushar Chauhan
Reply all
Reply to author
Forward
0 new messages