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.
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
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.