Vice President, Data Management Engineer

Archer; New York (NY); On-site; USD 180,000 - 280,000; Full time

Job summary

Archer in partnership with BNY is seeking a Vice President, Data Management Engineer in New York, NY to join the Conventional Trust team. You will lead data architecture, data modeling, and data quality initiatives across mainframe and distributed environments, ensuring scalable, reliable data pipelines and governance.

Ideal candidates have 6–10 years in software development, strong Snowflake, Python, SQL, and AI/ML data solutions experience, plus hands-on ETL tooling and BI integration.

Qualifications

• Bachelor's degree in computer science, engineering or related field (or equivalent work experience).
• 6–10 years of software development experience; securities/financial services a plus.
• Strong understanding of big data tech including Snowflake.
• Proficient in Python and SQL with data engineering capabilities.
• Experience with Oracle and AI/ML based data solutions.

Responsibilities

• Design data models, databases, and data dictionaries across environments.
• Ensure data quality and implement data stewardship practices.
• Develop scalable data processing workflows with PySpark and Python.
• Write complex, performance-optimized SQL queries and ETL pipelines.
• Troubleshoot Spark jobs and optimize for performance and reliability.
• Collaborate with cross-functional teams to meet requirements.
• Follow coding standards, documentation, and best practices.

Skills

Python

SQL

Data Engineering

Spark

Pyspark

ETL

AI/ML

Snowflake

RESTful API

Power BI

GitLab CI/CD

Jira

Oracle

Education

Bachelor's degree in CS/Engineering or related

Tools

Apache Airflow

Power BI

GitLab CI/CD

Job description

Archer is collaborating with BNY to connect them with exceptional professionals for this role.

Vice President, Data Management Engineer

At BNY, our culture allows us to run our company better and enables employees' growth and success. As a leading global financial services company at the heart of the global financial system, we influence nearly 20% of the world's investible assets. Every day, our teams harness cutting-edge AI and breakthrough technologies to collaborate with clients, driving transformative solutions that redefine industries and uplift communities worldwide.

Recognized as a top destination for innovators and champions of inclusion, BNY is where bold ideas meet advanced technology and exceptional talent. Together, we power the future of finance - and this is all about. Join us and be part of something extraordinary.

We're 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, you'll 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, we're seeking the following:

• Bachelor's 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

At BNY, our culture speaks for itself, check out the latest BNY news at:

BNY Newsroom

BNY LinkedIn

Here’s a Few Of Our Recent Awards

• America's Most Innovative Companies, Fortune, 2025
• World's Most Admired Companies, Fortune 2025
• Most Just Companies, Just Capital and CNBC, 2025

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 life's 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 is an Equal Employment Opportunity/Affirmative Action Employer - Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans.

At BNY, our culture allows us to run our company better and enables employees' growth and success. As a leading global financial services company at the heart of the global financial system, we influence nearly 20% of the world's investible assets. Every day, our teams harness cutting-edge AI and breakthrough technologies to collaborate with clients, driving transformative solutions that redefine industries and uplift communities worldwide.

Recognized as a top destination for innovators, BNY is where bold ideas meet advanced technology and exceptional talent. Together, we power the future of finance - and this is what is all about. Join us and be part of something extraordinary.