Data Modeler

Location: Pittsburgh, PA, United States; Hybrid

 Data Governance Architect

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 #LifeAtBNY is all about. Join us and be part of something extraordinary.

We’re seeking a future team member for the role Data Modeler to join our Finance Data Governance team. This role is in Pittsburgh, PA or Lake Mary, FL

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

• Design and evolve conceptual, logical, and physical data models for key Finance domains (e.g., General Ledger, product/client hierarchies, balance sheet, and P&L), ensuring models meet reporting and analytics needs.
• Partner with engineering teams to implement models across data warehouses/lakehouses; review schema changes, performance implications, and downstream impacts.
• Define and advocate data architecture standards and patterns (naming conventions, modeling guidelines, partitioning strategies, data contracts, and documentation best practices).
• Collaborate with Data Governance to embed standards, lineage, and quality controls into pipelines and datasets; contribute to the business glossary and metadata catalog.
• Implement reproducible ETL/ELT pipelines using SQL and modern data tooling (e.g., dbt, Spark, Informatica) and support source-to-target mapping and transformation logic.
• Support end-to-end data lineage capture and validation from source systems through transformations to reporting outputs; familiarity with lineage platforms such as Manta or Solidatus is preferred.
• Establish data quality rules and observable KPIs; lead triage and remediation for high-impact data issues affecting Finance and regulatory reporting.
• Deliver clear technical artifacts including ERDs, source-to-target mappings, data contracts, and operating procedures; participate in design reviews and governance forums.
• Advise on reference/master data management approaches and align taxonomies, hierarchies, and reference data standards across platforms.

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

• Bachelor’s degree in finance, Accounting, Data/Information Management, Computer Science, or related field; Master’s degree preferred.
• 3-7+ years of experience in data architecture and data modeling, ideally within financial services or other highly regulated domains.
• Strong data modeling skills (conceptual/logical/physical), including relational and dimensional modeling; ability to align models to Finance reporting, accounting, and regulatory needs.
• Data governance expertise (data dictionary/business glossary, critical data elements, stewardship operating model, and data quality controls).
• End-to-end data lineage and metadata management experience, including use of catalog/lineage tools (e.g., Collibra, Alation, Informatica, Purview, Manta, Solidatus, or similar).
• Data product mindset: define ownership, SLAs, documentation/metadata, and quality rules; partner with engineering to operationalize.
• Technical proficiency in SQL and experience with ETL/ELT and transformation frameworks (e.g., dbt, Spark, Informatica); proficiency with Excel.
• Strong cross-functional influence and ability to lead without authority; mentor analysts/engineers and work effectively across engineering, Finance, and business teams.

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

BNY Newsroom

BNY LinkedIn

Here are 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)

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.