DATA MANAGEMENT ENGINEER - Full Stack

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

Job summary

BNY Mellon is seeking a Data Management Engineer - Full Stack in Pittsburgh to translate business needs into scalable data models and robust pipelines. You’ll design ETL/ELT solutions, build Spark-based data flows, and contribute to CI/CD and automated testing.

The role collaborates with cross-functional teams to deliver data-driven finance platforms. Required: 2–6 years in software development, strong SQL/Python/Java, Spark, and experience with Power BI; familiarity with Snowflake/Oracle/SQL

Qualifications

• Bachelor’s degree in computer science, engineering or related discipline; 2–6 years software development in finance is a plus.
• Proficient in ETL/ELT development with Spark and workflow automation (Airflow, Control-M).
• Strong SQL, Python, Java, Spark skills and experience with Power BI or similar reporting tools.

Responsibilities

• Translate business requirements into scalable ETL/ELT data models.
• Develop data pipelines using Spark and write tests and documentation.
• Define reusable ETL/ELT components for data integration and migration.
• Collaborate to implement CI/CD pipelines and automated testing.
• Work with full-stack engineers and BI teams to deliver end-to-end data solutions.

Skills

Spark

Python

SQL

Java

Airflow

Control-M

Power BI

APIs

Azure

CI/CD

ETL/ELT

Big Data

Kubernetes

Education

Bachelor’s degree in CS/Engineering

Tools

Snowflake

Oracle

SQL Server

Hadoop

Job description

DATA MANAGEMENT ENGINEER - Full Stack

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, Data Management Engineer to join our Finance Platform's Client Profitability Engineering team. This role is in Pittsburgh, PA.

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

• Translate business requirements into ETL/ELT logical models, ensuring data structures are designed for scalability and flexibility to support evolving business solutions.
• Develop and implement robust data pipelines using Spark. Design and code programs, create test transactions and write documentation that describes installation and operating procedures.
• Define and deliver reusable components within the ETL/ELT framework.
• Establish optimal data flows for system integration and data migration.
• Integrate emerging data management technologies and software engineering tools into existing architectures. Apply security and privacy principles.
• Design, construct, and maintain CI/CD pipelines across multiple integration and test environments.
• Install, configure, and manage automated testing tools within the environment.
• Utilize AI based development / vibe coding (e.g. Windsurf, Codex) and techniques to develop solutions
• Knowledge and experience building agents and agentic solutions.
• Participate in deployment process following all change controls. Provide ongoing maintenance, support and enhancements in existing systems and platforms. Provide recommendations for continuous improvement.
• Work alongside other engineers on the team to elevate technology and consistently apply best practices.
• Collaborate closely with all the other members of the team to take shared responsibility for the overall efforts that the team commits to.
• Collaborate cross-functionally with full-stack engineers, business users, project managers and other engineers to achieve elegant solutions.

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

• Proven experience in the design, development, and implementation of large-scale projects within financial industries, utilizing Data Warehousing ETL tools (including Spark).
• Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required2-6 years of experience in software development required; experience in the securities or financial services industry is a plus
• Proficient in creating ETL transformations and jobs with Spark and automating workflows through orchestration tools such as Airflow and Control-M.
• In-depth knowledge and hands-on experience with SQL, Python, Java, Spark and reporting tools like Power Bi.
• Oracle, Snowflake, SQL Server or any other relational database experience necessary.
• Familiarity with Big Data and distributed frameworks including Spark, Kubernetes, Hadoop, and Hive.
• Experience working with APIs to create, test and manage APIs for inter-process communication.
• Adopt AI-first software development practices.
• Experience leveraging AI tools (e.g., GitHub Copilot, Cursor, Windsurf, or similar LLM-based assistants) to accelerate daily development tasks such as code generation, debugging, code review, building unit tests and documentation.
• Ability to design ETL/ELT solutions tailored to user reporting and archival needs.
• Demonstrated commitment to delivering excellent customer service and effectively addressing client requirements.
• Self-motivated and capable of working independently with minimal supervision.
• Comprehensive experience in building and managing CI/CD pipelines.
• Basic understanding of Azure Cloud components.
• Passion for problem solving and designing for scale.
• Experience following best practices of design, development, testing and release management.
• Good understanding of monitoring tools such as AppDynamics, Splunk & Moogsoft.

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.