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.
To be successful in this role, we’re seeking the following
Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required
6-10 years of experience in software development required; experience in the securities or financial services industry is a plus
The candidate should have strong understanding of big data technology stack such as Snowflake.
The candidate should be a Python expert, SQL with Data Engineering capabilities.
The candidate should have proven experience with RDBMS like Oracle.
The candidate should have proven experience implementing AI/ML based data solutions to solve complex data management problems
The candidate should be able to demonstrate their work on real world projects with nice-to-have Skills AI, ETL tools like Apache airflow , Restful API design and development, Reporting/BI tool such as Microsoft Power BI , GIT Lab CICD and JIRA.
Design and develop scalable data processing workflows using Pyspark and Python
Write complex and performance optimized SQL queries
Perform data extraction, transformation and loading (ETL)
Troubleshoot and optimize Spark jobs for performance and stability
Work with large datasets and ensure data quality and reliability
Collaborate with cross-functional teams for requirements understanding and delivery
Follow coding standards, best practices, and documentation
At BNY, our culture speaks for itself, check out the latest BNY news at:
BNY Newsroom
BNY LinkedIn
Here’s 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
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.