Senior Vice President, Data Engineer – Ontology & Investment Data Standard (IDS)

BNY

Pittsburgh (Allegheny County)

On-site

USD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

BNY is seeking a Data Pipeline Engineer to join the Data Innovation team in Pittsburgh, PA or Lake Mary, FL. You will design and build production-ready data pipelines powering IDS and knowledge graph initiatives, collaborating across platform, product and data teams to enable analytics and client solutions.

The role requires hands-on Python, Spark and SQL expertise, experience with ETL/ELT frameworks, and a track record of delivering scalable pipelines with robust data quality and lineage.

Qualifications

  • Bachelor's degree or equivalent; advanced degree preferred in statistics or analytics.
  • At least six years total work experience with emphasis on data analysis and BI.
  • Extensive experience in data engineering and building scalable pipelines.
  • Proficient in Python, Spark and SQL with ETL/ELT and orchestration tooling.
  • Experience designing high-volume, resilient batch/streaming pipelines.
  • Familiarity with Snowflake, AWS, Databricks and API-based data integration.

Responsibilities

  • Design and build scalable data pipelines ingesting data from multiple sources.
  • Transform diverse data formats into standardized time-series and event datasets.
  • Develop reusable frames to normalize identifiers, units, and event data.
  • Collaborate to map source data to canonical entities for graph ingestion.
  • Implement data quality controls with lineage, provenance, and traceability.
  • Enable multi-vendor ingestion, comparison, and quality analytics.
  • Build modular cloud-native pipelines optimized for scale, performance and cost.

Skills

Python
Spark
SQL
ETL/ELT frameworks
Orchestration tools
Data modeling
High-volume pipelines
Knowledge graph / ontology

Education

Bachelor's degree or equivalent
Advanced degree preferred (statistics/analyze)

Tools

Snowflake
AWS
Databricks

Job description

Job Description

We’re seeking a future team member for the role of Data Pipeline Engineer to join our Data Innovation team. In this role, you will design and build the data pipelines that power our Investment Data Standard (IDS) and knowledge graph, enabling a unified, high-quality data ecosystem that supports analytics, AI, and client-facing solutions. You will partner closely with the Ontology/Knowledge Architecture lead and collaborate across platform, product, and data teams to deliver scalable, production-ready solutions aligned to our broader data transformation strategy. This role is located in Pittsburgh, PA or Lake Mary, FL.

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

  • Design and build scalable pipelines to ingest and process data from internal platforms and external vendors across batch, streaming, and near real-time patterns.
  • Transform diverse data formats (APIs, flat files, streaming, unstructured) into clean, standardized time-series and event-driven datasets aligned to IDS entity models.
  • Develop reusable frameworks to normalize identifiers, symbology, units, hierarchies, and event data (e.g., corporate actions, transactions).
  • Partner with Ontology/Knowledge architecture team to map source data to canonical entities, relationships, and attributes, enabling graph ingestion and entity resolution.
  • Implement robust data quality controls (completeness, accuracy, consistency, schema drift, anomaly detection) with full lineage, provenance, and traceability (source -> IDS -> product).
  • Enable multi-vendor data ingestion, comparison, and reconciliation, including source prioritization, hierarchy logic, and coverage/quality analytics.
  • Build modular, reusable, cloud-native pipelines optimized for scale, performance, and cost (e.g., Snowflake), with monitoring and SLA-driven reliability.
  • Collaborate cross-functionally to translate business and data requirements into production-ready pipelines and support downstream distribution via APIs, data products, and client platforms.

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

  • Bachelor's degree in a related discipline or equivalent work experience required. An advanced degree with a preference in statistics/statistical analysis is preferred.
  • At least six years’ total work experience, with at least 3 years’ experience with a strong focus on data analysis and business intelligence is preferred.
  • Extensive experience in data engineering, building and scaling production-grade data pipelines.
  • Deep hands-on expertise in Python, Spark, and SQL, with strong experience in ETL/ELT frameworks and orchestration tools.
  • Proven ability to design and operate high-volume, resilient pipelines across batch, streaming, and distributed environments.
  • Strong understanding of structured and semi-structured data modeling, including time-series and event-driven architectures.
  • Experience designing data transformation and normalization layers, including schema evolution and backward compatibility.
  • Expertise with modern data platforms (e.g., Snowflake, AWS, Databricks), lakehouse architectures, and API-based data integration.
  • Strong capabilities in performance tuning, cost optimization, and implementing data quality, monitoring, logging, and lineage frameworks.
  • Domain experience with financial datasets (market data, pricing, reference data, portfolio holdings, transactions, corporate actions) and familiarity with key vendors (e.g., Bloomberg, ICE, MSCI).
  • Exposure to knowledge graph/ontology-driven systems, entity resolution workflows, AI/LLM-based unstructured data integration (e.g., documents, PDFs), and data entitlements, licensing, and usage tracking is preferred.
About Us

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.

About The Team

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 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 employee’s 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 "at will" 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Director, Platform Experiences & Core Capabilities Lead
Senior Director, Platform Experiences & Core Capabilities Lead

BNY • Boston (MA)

On-site
USD 180,000 - 240,000
Vice President, Data Management & Quantitative Analysis
Vice President, Data Management & Quantitative Analysis

BNY • New York (NY)

On-site
USD 180,000 - 240,000
Director, Application Development Manager
Director, Application Development Manager

BNY • Florida

On-site
USD 180,000 - 240,000
Specialist, Full-Stack Engineer II
Specialist, Full-Stack Engineer II

BNY • New York (NY)

On-site
USD 120,000 - 160,000
Competitive compensation
Paid time off
401(k) plan
Vice President, Data & Analytics Systems Lead
Vice President, Data & Analytics Systems Lead

BNY • Boston (MA)

On-site
USD 200,000 - 300,000
Director, Full-Stack Engineer - AI Hub Engineering
Director, Full-Stack Engineer - AI Hub Engineering

BNY • Florida

On-site
USD 180,000 - 240,000
Director, Full-Stack Engineer - AI Hub Engineering
Director, Full-Stack Engineer - AI Hub Engineering

BNY • Florida

On-site
USD 150,000 - 210,000
Senior Vice President, AI / Machine Learning Data Engineer
Senior Vice President, AI / Machine Learning Data Engineer

BNY • Jersey City (NJ)

On-site
USD 126,000 - 210,000
Generous paid leaves
Volunteer time off
Wellbeing programs
Director, Application Development & AI Solutions
Director, Application Development & AI Solutions

BNY • Florida

On-site
USD 180,000 - 240,000
Senior Vice President, Application Support SDG Lead
Senior Vice President, Application Support SDG Lead

BNY • Pittsburgh

On-site
USD 120,000 - 170,000