B

BNY

Safeguards and moves assets for investors

Vice President, Data Management Engineer

Data Management +1Updated on Nov 12
Full-timeNew York, NY, USA$69k - $185kIn-person

About the Job

Requirements

  • A bachelor's degree in computer science engineering or a related discipline, or equivalent work experience, is required.
  • Six to ten years of software development experience is required.
  • Experience in the securities or financial services industry is a plus.
  • Strong understanding of big data technology stacks such as Snowflake.
  • Expert-level Python skills and SQL skills with data engineering capabilities.
  • Proven experience with relational database management systems such as Oracle.
  • Proven experience implementing artificial intelligence and machine learning-based data solutions to solve complex data management problems.

Responsibilities

  • Establish partnerships with source system data owners and reporting teams to understand and document requirements related to data use, scope, limitations, attribute definitions, and links to other datasets.
  • Analyze application requirements and develop conceptual, logical, and initial physical database designs and associated data model documentation, including entity and attribute definitions and formats.
  • Assist in logical data designs to deliver stable, flexible, high-performance data solutions, and investigate and correct data discrepancies by reconciling faulty codes.
  • Provide data element naming consistent with standards and conventions, and maintain data dictionaries across mainframe and distributed database environments.
  • Plan and conduct moderately complex data warehouse system tests, monitor test results, take corrective action, and work with data owners to establish data stewardship responsibilities and procedures.
  • Analyze and design data models, logical databases, and relational database definitions using forward and backward engineering techniques.
  • Promote data sharing and reduce redundant data processes by identifying common structures across application areas.
  • Ensure adherence to data quality standards, determine root causes of data quality errors, and recommend long-term solutions.
  • Design and develop scalable data processing workflows using PySpark and Python.
  • Write complex, performance-optimized SQL queries.
  • Perform data extraction, transformation, and loading.
  • Troubleshoot and optimize Spark jobs for performance and stability.
  • Work with large datasets and ensure data quality and reliability.
  • Collaborate with cross-functional teams to understand requirements and deliver solutions.
  • Follow coding standards, best practices, and documentation.

Desired Qualifications

  • Knowledge of procurement, third-party governance, and vendor data.
  • Experience with artificial intelligence, ETL tools such as Apache Airflow, RESTful API design and development, reporting or business intelligence tools such as Microsoft Power BI, GitLab CI/CD, and Jira.

About the Company

BNY

Safeguards and moves assets for investors

BNY safeguards financial assets and runs investment services for institutions, investment firms and wealthy clients around the world. Its custody business keeps clients' securities safe and handles the records and transactions needed to administer investment funds. Banks and brokers use its systems to settle trades, manage collateral and send payments, while its investment and wealth businesses manage portfolios and advise clients. It earns servicing and management fees as well as interest on loans and securities funded by client deposits. BNY traces its roots to the Bank of New York, founded by Alexander Hamilton in 1784, and is headquartered in New York City.

Company size
10,001+
Company stage
IPO
Headquarters
New York City, New York
Founded
1784

Recently Posted Jobs

Explore more opportunities at BNY

See more jobs