Vice President, Data Management Engineer
BNY Mellon4 days ago
Responsibilities
- Partner with source-system data owners and reporting teams to document data requirements, definitions, limitations, and relationships.
- Develop conceptual, logical, and physical data models and associated entity, attribute, and data-dictionary documentation.
- Design and maintain logical databases and relational database definitions using forward and backward engineering techniques.
- Investigate data discrepancies, reconcile faulty codes, determine root causes, and recommend long-term data-quality solutions.
- Plan and conduct data-warehouse system tests, monitor results, and take corrective action.
- Establish data stewardship responsibilities and procedures with data owners.
- Design scalable data-processing workflows using PySpark and Python.
- Write complex, performance-optimized SQL queries and perform data extraction, transformation, and loading.
- Troubleshoot and optimize Spark jobs for performance and stability.
- Collaborate with cross-functional teams on requirements, delivery, coding standards, best practices, and documentation.
Requirements
- Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience.
- 6–10 years of software development experience.
- Strong data management, data modeling, metadata analysis, data quality, and data engineering capabilities.
- Expertise with Python and strong SQL skills.
- Experience with big-data technologies such as Snowflake and relational databases such as Oracle.
- Experience implementing AI/ML-based data solutions for complex data-management problems.
- Experience with PySpark, ETL, large datasets, and reliable data-processing workflows.
- Preferred experience in securities or financial services, procurement, third-party governance, and vendor data.
- Nice-to-have experience with Apache Airflow, RESTful API design and development, Microsoft Power BI, GitLab CI/CD, and JIRA.
Benefits
- Competitive compensation, benefits, and wellbeing programs.
- Flexible global resources and tools supporting health, resilience, financial goals, and personal wellbeing.
- Generous paid leave, including paid volunteer time.
- Equal Employment Opportunity/Affirmative Action employer.
Tech Stack
Categories
Data Engineering
About BNY Mellon
BNY Mellon is a public, New York–based global financial services company providing investment and wealth management, asset servicing, clearance, collateral, and treasury services to institutions, banks, governments, and individuals. It also offers data and investment operations software, including the Eagle platform, delivered as cloud and managed services. Founded in 1784, it is one of the world’s largest custodian banks and asset servicers.