Senior Associate, Data Management Analysis

Hispanic Technology Executive Council
Pittsburgh, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Pittsburgh, United States of America

Tech stack

Big Data
Data Infrastructure
Data Transformation
Data Profiling
Database Queries
Hadoop
Hive
Python
Reference Data
Power BI
Computational Finance
SQL Databases
Collibra
Data Management
Alteryx
Programming Languages

Job description

  • Works with client, transaction, and compliance data to develop statistical, financial and/or econometric models.
  • Leads data modelling and quantitative analysis projects and serves as resource to less experienced colleagues.
  • Rapidly assess, transform, and create relationships within and between data sets, applications, and processes.
  • Uses tools like SQL and Alteryx to query, analyze, and extract data for populating models.
  • Establish partnerships with source system owners, technology, and the business to obtain data and understand data limitations (i.e., scope of data, attribute definitions, linkages to other datasets)
  • Provides analytical project management support for assigned area with minimal guidance.
  • Document the data transformation process including data workflow charts and diagrams.
  • Perform root cause analysis for data quality errors; research and find scope and complexity of issues and find the steps for remediation.
  • Partner with the broader BNYM data community to socialize and drive best practices with Alteryx and PowerBI

Requirements

  • Bachelor's degree or the equivalent combination of education and experience needed.
  • Degree in math, engineering, statistics, computational finance, or economics preferred.
  • 5+ relevant years of total work experience preferred., * Advanced data profiling experience using SQL skill with financial industry experience.
  • Knowledge of the structuring of data environments and applications that use big data processes is a preferred.
  • Experience with Business Intelligence data management and visualization applications specific to Hadoop big data and the ability to use SQL/Hive and other computer languages used in big data for analysis and structuring is preferred.
  • Competency with leading data profiling tools such as SQL, Alteryx, Power BI, Python, or other data querying tools
  • Competency with data governance tools (Collibra, IDQ)
  • Experience with issue management systems
  • Strong organization, communication, and presentation skills
  • Program management skill preferred.
  • Familiar with logical data model
  • Experience with reference data and master data preferred.

About the company

Put your professional experience to work for one of the world's most recognized and admired financial industry companies with a career at BNY Mellon. Founded in 1784 by Alexander Hamilton, we have not only been an engine behind the evolution of the financial industry, but we have also evolved at every step. Today we are more than 50k+ employees across 35 countries as we continue to build momentum and achieve further growth., BNY Mellon is a global investments company dedicated to helping its clients manage and service their financial assets throughout the investment lifecycle. Whether providing financial services for institutions, corporations, or individual investors, BNY Mellon delivers informed investment management and investment services in 35+ countries. As of July 18, 2023, BNY Mellon had $46.9 trillion in assets under custody and/or administration, and $1.9 trillion in assets under management. BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments. BNY Mellon is the corporate brand of The Bank of New York Mellon Corporation (NYSE: BK). Additional information is available on www.bnymellon.com. Follow us on Twitter @BNYMellon or visit our newsroom at www.bnymellon.com/newsroom for the latest company news.

Apply for this position