Job Description

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.

Job Tags

Similar Jobs