To develop and maintain data models for BNY's Wealth Service Platform, ensuring data quality and performance, and providing direction and support for data consumption services.
Requirements
- 5-7 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
- Work experience in Financial Services
- Work experience on any data modeling tool, viz. Erwin, DBArtisan etc.
- Experience with ANSI SQL code
- Prior Experience with a scripting language, preferably Python
- Experience working with Cloud native databases
Responsibilities
- 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
- 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
Other
- Bachelor's or Master’s degree in Computer Science or a related discipline, or equivalent work experience
- Excellent communication skills
- Good Problem Solving & Analytical Skills
- Work experience in Financial Services
