Senior Associate, Data Management Analyst

at  BNY Mellon

Overview
Senior Associate, Data Analyst
At BNY, our culture empowers you to grow and succeed. As a leading global financial services company at the center of the world’s financial system we touch nearly 20% of the world’s investible assets. Every day around the globe, our 50,000+ employees bring the power of their perspective to the table to create solutions with our clients that benefit businesses, communities and people everywhere.
We continue to be a leader in the industry, awarded as a top home for innovators and for creating an inclusive workplace. Through our unique ideas and talents, together we help make money work for the world. This is what #LifeAtBNY is all about.
We’re seeking a future team member for the role of Data Analyst to join our Middle Office platform. This role is located in Pittsburgh, PA – HYBRID (3 days/week in office) .
We are looking for OTC Derivatives Data Analyst with specialized focus on OTC Derivatives Lifecycle workflows from transaction injection to reporting and cashflow delivery. The ideal candidate will have proven experience and domain knowledge of OTC derivatives across cleared and bilateral products (Interest Rate Derivatives (IRD), Foreign Exchange Options (FXO), and Equity Derivatives (EQD)). This position requires a unique blend of technical expertise, financial knowledge, and a deep understanding of the derivatives market.

EMPLOYER DESCRIPTION:

For over 230 years, the people of BNY Mellon have been at the forefront of finance, expanding the financial markets while supporting investors throughout the investment lifecycle. BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments and safeguards nearly one-fifth of the world’s financial assets. BNY Mellon remains one of the safest, most trusted and admired companies. Every day our employees make their mark by helping clients better manage and service their financial assets around the world. Whether providing financial services for institutions, corporations or individual investors, clients count on the people of BNY Mellon across time zones and in 35 countries and more than 100 markets. It’s the collective ambition, innovative thinking and exceptionally focused client service paired with a commitment to doing what is right that continues to set us apart. Make your mark: bnymellon.com/careers.

IN THIS ROLE, YOU’LL MAKE AN IMPACT IN THE FOLLOWING WAYS:

• Perform data analysis, interpretation, data modelling and transformation of incoming/outgoing OTC data messages to support trade lifecycle management workflow and internal and client external reporting
• Utilized expertise in derivatives to define data transformations and manipulations using SQL as well as FPML and JSON Formatting skills
• Troubleshoot and resolve issues pertaining to data quality, ensuring the integrity of static, market data, and OTC transaction data.
• Work closely with the developers in the engineering team to facilitate and support the integration of Derivative Trade Lifecycle with other applications, platforms and systems within the organization.
• Develop and execute detailed test plans for new enhancements and products.

TO BE SUCCESSFUL IN THIS ROLE, WE’RE SEEKING THE FOLLOWING:

• Proficiency in cleared and bilateral OTC market standard for G7 and emerging markets currencies across the OTC market (IRD, FXO, EQD)
• Expertise in SQL and the ability to create complex queries for financial data analysis.
• Familiarity with FPML and JSON data format.
• Strong communication and problem solving skills
• Preferred: Direct experience in Murix, Summit, Calipso, Geneva derivatives systems, including configuration and operations
• Bachelor’s degree in computer science or a related discipline, or equivalent work experience required.
• 4-6 years of experience in data modeling, data warehousing, data entity analysis, logical and relational database design, or an equivalent combination of education and work experience required, experience in the securities or financial services industry is a plus

At BNY, our culture speaks for itself. Here’s a few of our awards:

• America’s Most Innovative Companies, Fortune, 2024
• World’s Most Admired Companies, Fortune 2024
• Human Rights Campaign Foundation, Corporate Equality Index, 100% score, 2023-2024
• Best Places to Work for Disability Inclusion, Disability: IN – 100% score, 2023-2024
• “Most Just Companies”, Just Capital and CNBC, 2024
• Dow Jones Sustainability Indices, Top performing company for Sustainability, 2024
• Bloomberg’s Gender Equality Index (GEI), 2023