Job Description

Vice President, Data Management Engineer

We9re seeking a future team member for the role of Vice President, Data Management Engineer to join our Conventional Trust team. This role is in New York, NY

In this role, you9ll have the opportunity to impact our organization in the following ways:

• Establish partnerships with source system data owners and reporting team (data users) to understand and document requirements related to the use and gain an understanding of the data, including scope of data, limitations, attribute definitions, and linkages to other datasets.
• Strong Data Management, Data Modeling and Metadata Analysis skills.
• Analyzes application requirements and develops conceptual, logical and first-cut physical database designs (data models). Creates associated data model documentation such as entity and attribute definitions and formats.
• Assists in logical data designs to deliver stable and flexible high performance data solutions. Investigates and corrects data discrepancies by reconciling faulty codes.
• Provides data element naming consistent with standards and conventions and ensures that data dictionaries are maintained across multiple database environments (mainframe, distributed systems).
• Ensures data content/quality by planning and conducting moderately complex data warehouse system tests, monitoring test results and taking required corrective action. Acts as a liaison to data owners to establish necessary data stewardship responsibilities (accountability for a particular data element/verifying accuracy of the data element before loading it into the database) and procedures.
• Analyzes and designs data models, logical databases and relational database definitions using both forward and backward engineering techniques.
• Seeks opportunities to promote data sharing, and to reduce redundant data processes within the corporation by identifying common structures across application areas.
• Ensure adherence to data quality standards.
• Determine root cause for data quality errors and make recommendations for long-term solutions.
• Good to have knowledge on Procurement, Third-party governance and vendor data.

To be successful in this role, we9re seeking the following:

• Bachelor9s degree in computer science engineering or a related discipline, or equivalent work experience required
• 6-10 years of experience in software development required; experience in the securities or financial services industry is a plus
• The candidate should have strong understanding of big data technology stack such as Snowflake.
• The candidate should be a Python expert, SQL with Data Engineering capabilities.
• The candidate should have proven experience with RDBMS like Oracle.
• The candidate should have proven experience implementing AI/ML based data solutions to solve complex data management problems
• The candidate should be able to demonstrate their work on real world projects with nice-to-have Skills AI, ETL tools like Apache airflow , Restful API design and development, Reporting/BI tool such as Microsoft Power BI , GIT Lab CICD and JIRA.
• Design and develop scalable data processing workflows using Pyspark and Python
• Write complex and performance optimized SQL queries
• Perform data extraction, transformation and loading (ETL)
• Troubleshoot and optimize Spark jobs for performance and stability
• Work with large datasets and ensure data quality and reliability
• Collaborate with cross-functional teams for requirements understanding and delivery
• Follow coding standards, best practices, and documentation

Our Benefits and Rewards:

BNY offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life9s journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves, including paid volunteer time, that can support you and your family through moments that matter.

BNY assesses market data to ensure a competitive compensation package for our employees. The expected base salary for this position when employment commences can be found in the Job Info section at the bottom of the posting.

Base salary offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. Base salary is only part of the total rewards package, which may include eligibility for an annual discretionary incentive award. Subject to the terms and conditions of the applicable plans then in effect, eligible employees may enroll in a 401(k) plan as well as participate in Company-sponsored medical, dental, vision, and basic life insurance plans for the employee and the employee9s eligible dependents. Eligible employees also may receive other benefits (including various paid time off benefits, such as vacation and sick time), dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.

If hired, the employee will be in an 4at will4 position and the Company reserves the right to modify base salary (as well as any other discretionary payments or compensation programs) at any time, including for reasons related to individual performance, Company or individual department/team performance, and market factors.