Vice President, Database Engineer

BNY Mellon; Pittsburgh (Allegheny County); On-site; USD 83,000 - 195,000; Full time

Job summary

BNY Mellon is seeking a Vice President, Database Engineer in Pittsburgh to lead advanced database engineering for Fund Accounting and Admin. You will optimize Oracle and Snowflake environments, design scalable data models, and drive data governance while collaborating with cross-functional teams across planning, development, and operations.

The role requires 5+ years of hands-on experience with Oracle and Snowflake, strong PL/SQL and SQL tuning skills, and a track record delivering

Qualifications

• Bachelor's degree in CS, IT, or related field.
• 5+ years with Oracle and exposure to Snowflake.
• PL/SQL development and advanced SQL skills.
• Strong data engineering capability with production-grade delivery.
• Experience with AI Agentic Workflows and Automation.
• Unix, PL/SQL, and Python for scalable workflows.
• Experience building/batching pipelines in Unix/Linux.
• Complex, performance-tuned SQL experience.
• ETL (extraction, transformation, load, controls, audit).
• Proven ability handling large datasets with data quality and reliability.
• Troubleshooting batch failures, data issues, and bottlenecks.
• Cross-functional collaboration to gather requirements and deliver solutions.
• Adherence to coding standards, documentation, and best practices.
• Shell scripting and Unix command-line proficiency.
• Must have RESTful web service experience.
• Understanding of microservices architectures (Kafka).
• Caching with Hazelcast/Redis is a plus.
• SDLC, DevOps processes, Git/JIRA.
• Ability to investigate production issues via code and logs.

Responsibilities

• Ensure database performance and scalability through regular assessments and improvements.
• Collaborate with development teams to integrate database solutions with applications.
• Lead database automation initiatives to drive efficiency.
• Gather requirements from source system owners and data consumers.
• Model end-to-end data flows and entities across systems.
• Create and maintain ERDs, mappings, and naming standards.
• Develop and optimize tables, views, indexes, and procedures.
• Tune performance with SQL tuning, indexing, partitioning, and plans.
• Implement data validation, reconciliation, and error handling.
• Maintain data dictionaries and governance metadata.
• Enforce standards across dev/qa/prod environments.
• Build ETL logic and scheduling dependencies when applicable.
• Monitor loads, troubleshoot failures, and perform root-cause analysis.
• Promote reusable patterns and standard naming conventions.
• Support deployments with impact analysis and compatibility planning.

Skills

PL/SQL

Unix/Linux

Python

RESTful services

Data modeling

SQL tuning

Troubleshooting

Cross-functional collaboration

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

Oracle

Snowflake

Kafka

Splunk

GitLab CI/CD

JIRA

Redis

Hazelcast

Job description

74971 - Vice President, Database 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 what #LifeAtBNY is all about. Join us and be part of something extraordinary.

We're seeking a future team member for the role of Vice President, Database Engineer to join our Fund Accounting and Admin team. This role is located in Pittsburgh, PA

In this role, you'll make an impact in the following ways:

• Ensure optimal database performance and scalability by conducting regular performance assessments and implementing necessary improvements
• Collaborate with software development teams to integrate database solutions seamlessly into applications, ensuring data integrity and security
• Lead initiatives to enhance database automation and streamline processes, supporting BNY's commitment to innovation and operational excellence
• Work closely with source system owners, reporting teams, and data consumers to gather requirements and translate them into scalable database solutions.
• Understand end-to-end data flows, key entities, attributes, and relationships across upstream and downstream systems.
• Convert analytical and reporting needs into logical and physical data models.
• Create and maintain model documentation (ERDs, entity/attribute definitions, mapping specs, naming standards).
• Develop and optimize database objects such as tables, views, indexes, materialized views, sequences, stored procedures/functions, and packages.
• Apply performance tuning techniques (SQL tuning, indexing strategy, partitioning, query plans) to ensure efficient processing at scale.
• Implement validation checks, reconciliation logic, and exception handling to detect and resolve data issues.
• Enforce standards for data definitions and ensure consistency across environments (e.g., dev/qa/prod, multiple platforms).
• Maintain data dictionaries, reference/master data rules, and metadata needed for governance and traceability.
• Promote standard naming conventions, code sets, and reusable patterns.
• Build/maintain database-side ETL logic and scheduling dependencies where applicable.
• Monitor loads, troubleshoot failures, analyze root cause, and implement corrective actions.
• Identify opportunities to improve data sharing and reduce duplicated data transformations across teams.
• Contribute to data stewardship practices: definitions, ownership, access controls, and auditability.
• Recommend long-term fixes for recurring data defects and performance bottlenecks.
• Support changes through impact analysis, backward/forward compatibility planning, and controlled deployments

To be successful in this role, we're seeking the following:

• Bachelor's degree in Computer Science, Information Technology, or a related field
• 5+ years of experience with Oracle and exposure to Snowflake (or similar cloud data platforms)
• PL/SQL development and advanced SQL skills
• Strong data engineering capability with real-world, production-grade delivery experience
• Experience with AI Agentic Workflows and Automation.
• Hands-on ability to build scalable workflows using Unix, PL/SQL, and Python
• Experience building and optimizing batch pipelines running in Unix/Linux environments
• Ability to write complex, performance-tuned SQL (execution plans, indexing awareness, tuning approach)
• Practical experience with ETL (extraction, transformation, load, controls, audit, restartability)
• Proven ability to handle large datasets with strong focus on data quality, reconciliation, and reliability
• Strong troubleshooting skills for batch failures, data issues, and performance bottlenecks
• Comfortable working with cross-functional teams to understand requirements and deliver solutions
• Follows coding standards, best practices, and maintains documentation
• Strong scripting knowledge: Shell scripting + good Unix command-line understanding
• Must have RESTful web service experience.
• Understand microservices based, scalable architecture (previous experience working with Kafka).
• Experience implementing caching (using Hazelcast/ Redis) will be a plus.
• Strong experience in SDLC, DevOps processes - CI/CD tools, Git, etc.
• Should be capable to look into the production issue by checking code & Splunk logs
• Must have: AI exposure, ETL tool , GitLab CI/CD, and JIRA experience
• Nice to have - Financial Services experience : Securities, Corporate Actions, Pricing, Transactions, Fund Accounting, Eagle suite of products

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.

BNY assesses market data to ensure a competitive compensation package for our employees. The base salary for this position is expected to be between $83,000 and $195,000 per year at the commencement of employment. However, base salary if hired will be determined on an individualized basis, including as to experience and market location, and is only part of the BNY total compensation package, which, depending on the position, may also include commission earnings, discretionary bonuses, short and long-term incentive packages, and company- sponsored benefit programs.

This position is at-will and the Company reserves the right to modify base (as well as any other discretionary payment or compensation) at any time, including for reasons related to individual performance, change in geographic location, Company or individual department/team.