Salary
💰 $80,000 - $200,000 per year
Tech Stack
CloudMS SQL ServerOraclePythonRDBMSSQL
About the role
- Data Modeling for Financial Services platform.
- Create Logical and Physical Data Models based on data in existing systems and new business requirements.
- Enhance the Canonical Data Model for the Platform and implement the data model enhancements.
- Provide direction and support for the data consumption services.
- Work with the development teams in deploying and populating the Physical Data Model.
- Track Data Lineage across various databases.
- Ensure Performance of the Data Models based on the Transactional and Analytical use cases.
- Ensure Data Quality within the data models and at the data interfaces.
- Define Data Verification Processes.
- Work with various development teams to provide an understanding of the data model and the data.
Requirements
- Bachelor's or Master’s degree in Computer Science or a related discipline, or equivalent work experience is required. Advanced degree is preferred.
- 12-15 years of data modeling, database design and development or related experience.
- Experience in the Securities or Financial Services industry.
- Experience modeling Financial data.
- Prior experience modeling Client and Entitlement Data.
- Good knowledge of Financial Accounts, Transactions and Positions data.
- Hands-on experience with any RDBMS, preferably MS SQL Server or Oracle.
- Good SQL knowledge.
- Experience with ANSI SQL code.
- Prior experience with a scripting language, preferably Python.
- Experience working with Cloud native databases.
- Work experience on any data modeling tool, viz. Erwin, DBArtisan etc.
- Excellent communication skills.
- Good Problem Solving & Analytical Skills.