Senior 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 Senior Associate to join our Insights team. This role is located in Pune, Maharashtra– HYBRID The team is working closely with the Portfolio Managers and Researchers and performing tasks like exposure / risk / performance monitoring, portfolio attribution, running quant models, updating market data, historical analysis of benchmarks & portfolios (demonstrate exposure, annualized / rolling performance and risk, draw-down, IR etc.), monthly reporting etc. Also building / enhancing quant models and running simulations. The candidate will work on designing databases and ensuring their stability, reliability, and performance. S/He will work on optimizing SQL statements as necessary, establishing best practices, solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future. S/He will work with the Portfolio Managers and Researchers and provide support in all the data related initiatives/projects. The candidate would work on analysis, design and development of next generation strategic tools / APIs to assist the team in their activities. S/He will create dashboards to present the relevant data as necessary for the project. In this role, you'll make an impact in the following ways: Collaborate with the Portfolio Managers and Researchers to understand the needs and do the following – Designing reliable and stable new databases Optimizing existing databases and queries and come up with ideas to solve performance / usage issues Write Queries / Views / stored procs to extract data and prepare documentation Profile server resource usage, and optimize and tweak as necessary Handle common database procedures such as upgrade, backup, recovery, migration, etc. Build extensive tools to reduce manual efforts and increase efficiencies Sourcing, cleaning, and storing raw data. Systematic modelling of derived insights. Generating reports and dashboards to interpret and share results. Working with data pipelines including: Collaborate with developers / other teams For example, checking model generation code into Github and version control. Dashboarding for data democratization (Tableau, plotly), APIs to pull data and various SQL skills.

BNY is a leading global financial services company at the center of the world's financial system, touching nearly 20% of the world's investible assets. It has over 50,000 employees around the globe who bring their unique ideas and talents to create solutions that benefit businesses, communities and people everywhere.