Senior Associate, Data Management Analyst

Bring your ideas. Make history.  
BNY Mellon offers an exciting array of future-forward careers at the intersection of business, finance, and technology. We are one of the world's top asset management and banking firms that manages trillions of dollars in assets, custody and/or administration. Known as the “bank of banks” – 97% of the world’s top banks work with us as we lead and serve our customers into the new era of digital.  

With over 238 years of rich history and industry firsts, BNY Mellon has been built upon our proven ability to evolve, lead, and drive new ideas at every turn. Today, we’re approximately 50,000 employees across 35 countries with a culture that empowers you to grow, take risks, experiment and be yourself. This is what #LifeAtBNYMellon is all about.  

We’re seeking a future team member for the role to join our BNY Mellon team. This role is located in Pune – HYBRID.

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

The successful candidate will:

Key Skills:

The candidate should have strong understanding of big data technology stack such as Cloudera Hadoop Ecosystem that includes HDFS, Yarn, Hive & Impala etc. The candidate should be a Python expert with Data Engineering capabilities. The candidate should be able to demonstrate their work on real world projects. Nice-to-have Skills  ETL tool Apache airflow , Restful API design and development, Reporting/BI tool such as Microsoft Power BI , GIT Lab CICD and JIRA.

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

• Establish partnerships with source system data owners and reporting team (data users) to understand and document requirements related to the use and gain an understanding of the data, including scope of data, limitations, attribute definitions, and linkages to other datasets.
• Strong Data Management, Data Modeling and Metadata Analysis skills.
• Analyzes application requirements and develops conceptual, logical and first-cut physical database designs (data models). Creates associated data model documentation such as entity and attribute definitions and formats.
• Assists in logical data designs to deliver stable and flexible high performance data solutions. Investigates and corrects data discrepancies by reconciling faulty codes.
• Provides data element naming consistent with standards and conventions and ensures that data dictionaries are maintained across multiple database environments (mainframe, distributed systems).
• Ensures data content/quality by planning and conducting moderately complex data warehouse system tests, monitoring test results and taking required corrective action. Acts as a liaison to data owners to establish necessary data stewardship responsibilities (accountability for a particular data element/verifying accuracy of the data element before loading it into the database) and procedures.
• Analyzes and designs data models, logical databases and relational database definitions using both forward and backward engineering techniques.
• Seeks opportunities to promote data sharing, and to reduce redundant data processes within the corporation by identifying common structures across application areas.
• Ensure adherence to data quality standards.
• Determine root cause for data quality errors and make recommendations for long-term solutions.
• Good to have knowledge on Procurement, Third-party governance and vendor data.

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

• Fortune World’s Most Admired Companies & Top 20 for Diversity and Inclusion  
• Bloomberg’s Gender Equality Index (GEI) 
• Best Places to Work for Disability Inclusion, Disability: IN – 100% score  
• 100 Best Workplaces for Innovators, Fast Company 
• Human Rights Campaign Foundation, 100% score Corporate Equality Index 
• CDP’s Climate Change ‘A List’ 

Our Benefits:  

BNY Mellon 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 that can support you and your family through moments that matter. BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer – Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans.