Description

You design, develop, and maintain canonical data models and schemas for financial products.

This role is on-site.

Responsibilities

• Design and maintain canonical data models, including positions, trades, collateral, and market data.
• Implement data validation rules and monitor data flows to ensure quality, accuracy, and integrity.
• Document data definitions, lineage, business rules, and technical specifications for canonical models.
• Analyze large datasets using SQL, Excel, Python, or R to extract insights and create reports.
• Collaborate with data architects and developers to implement models across technology platforms.

Required Skills

• 10+ years of experience in data modeling or financial analysis.
• Proficiency in Erwin Data Modeler and database concepts.
• Strong SQL skills for data analysis and modeling.
• Advanced Excel capabilities for data manipulation and reporting.
• Experience with Python or R for data analysis.
• Deep understanding of securities finance, lending, borrowing, and collateral management.
• Bachelor's degree in Finance, Economics, Computer Science, or Information Systems.
• Ability to document technical specifications and data lineage clearly.

Preferred Skills

• Experience with data governance tools and dashboarding.
• Background in financial services or securities finance.

Key Skills

Education

Bachelor's degree