BNY is seeking a Database Architect to join their Data Management team to help drive transformative solutions that redefine industries and uplift communities worldwide by leveraging cutting-edge AI and breakthrough technologies.
Requirements
- Experience with multiple DBMS(s) including 2 or more of the following: DB2, Oracle, SQL Server, or Teradata. Competence in ANSI SQL and an understanding of the difference in DBMS-specific extensions.
- Experience with data consolidation, data warehousing, master data management, normalization, dimensional data modeling, development of logical and physical data models and support of database tuning activities.
- Advanced capability in data architecture, data modeling and data standardization with 5-7 years of hands-on experience using an industry standard case tool such as eRwin or Embarcadaro.
- Proven expertise in database modelling and design, tuning, and optimization activities with various stakeholders.
- Knowledge of data warehouse technology and enterprise data architecture solutions.
Responsibilities
- Experience with multiple DBMS(s) including 2 or more of the following: DB2, Oracle, SQL Server, or Teradata. Competence in ANSI SQL and an understanding of the difference in DBMS-specific extensions.
- Experience with data consolidation, data warehousing, master data management, normalization, dimensional data modeling, development of logical and physical data models and support of database tuning activities.
- Demonstrated experience and an aptitude for understanding the big picture as well as the ability to deliver detailed technical designs.
- Advanced capability in data architecture, data modeling and data standardization with 5-7 years of hands-on experience using an industry standard case tool such as eRwin or Embarcadaro.
- Proven expertise in database modelling and design, tuning, and optimization activities with various stakeholders.
- Knowledge of data warehouse technology and enterprise data architecture solutions.
Other
- Experience in financial services industry with a preference for full service brokerage.
- Ability to effectively communicate information, both verbally and written to business and application development teams.
- 8-10 years of experience in data management services required; experience in the securities or financial services industry is a plus.
- Highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy.
- BNY is an Equal Employment Opportunity/Affirmative Action Employer - Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans.
