Senior Associate, Data Management Analysis

Hispanic Technology Executive Council
Pittsburgh, PA, United States
21 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours

Tech stack

Big Data Data Infrastructure Data Transformation Data Profiling Database Queries Apache Hadoop Apache Hive Python (Programming Language) Reference Data Power BI Computational Finance SQL Databases
+4 more
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

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.localjobnetwork.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

4:18 min

Exploring the big data and machine learning portfolio

Qiyang Duan · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · WWC Europe 2026

3:14 min

Structuring career paths and localized data architectures

Ulrich Wurstbauer +1 · LIVE

Videos

See all

Related articles

See all