BNY is seeking a Senior Associate, Database Engineer to join their Wealth Service Platform team to design, review, and implement logical and physical data models, enhance the Canonical Data Model, and ensure data quality and performance.
Requirements
- Experience with data modeling, database design and development or related experience is required
- Hands-on experience with any RDBMS, preferably MS SQL Server or Oracle
- Good SQL knowledge
- Experience modeling Financial data
- Prior experience modeling Client and Entitlement Data
- Good knowledge of Financial Accounts, Transactions and Positions data
- Work experience on any data modeling tool, viz. Erwin, DBArtisan etc.
Responsibilities
- Design and Review of 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
- Implement and manage views and stored procedures for data consumption and data persistence
- Provide tools and support for the data consumption services
- 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
Other
- Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required
- 2-6 years of experience in software development required
- Excellent communication skills
- Good Problem Solving & Analytical Skills
- Work experience in Financial Services
