girl looking into her desktop
Back to search results

Traded Product Data Analyst

Charlotte, North Carolina;

Job Description:

The Traded Products Data Analyst is responsible for:

  • Research & Analysis – supporting Fixed Income and Equities and/or OTC Derivative products as well as, understanding the overall flow and usage of information from upstream sources and consolidation points used for capital modeling, calculation and reporting processes
  • Subject Matter Expertise - learning and understanding how regulations, policy interpretation, product mix, transformations and risk drivers impact capital reporting processes
  • Operational Excellence – improving Treasury Data Management functions for production, data governance, data change and regulatory/audit activities
  • Data Controls - ensuring process controls, data validation activities, DQ scripts and measurement processes remain timely and relevant
  • Data Remediation - meeting SLA timelines for Data Incident analysis, Defect or Enhancement classification, Action Plan creation and Target Date delivery for Monthly Data Governance Process compliance, Remediation Execution & Validation

Required Skills and Experience:

  • Bachelor's Degree required
  • Minimum 3 years of experience within a financial institution with hands-on experience in Data Analysis
  • Basic understanding of Traded Products including Fixed Income Securities and their representation in data
  • Must be a self-motivated / self-starter and able to take ownership and self-accountability for ensuring that process controls, data validation activities, data quality scripts and measurement processes remain timely and relevant
  • Hands-on experience querying and analyzing large sets of data
  • Strong analytical and problem solving capabilities skills needed to perform complex data analysis
  • Ability to use SQL to perform complex data profiling activities and analysis of large amounts of data for logical understanding and problem
  • Ability to perform complex data lineage analysis spanning multiple source systems and data transformations from a Capital data perspective
  • Strong ability to think logically and critically to develop actionable solutions that help resolve data issues for Capital
  • Ability to apply expert judgment and understand the context of Capital data related issues and know how and when to escalate/communicate data issues as they occur
  • Must possess very strong communication skills with teammates within Treasury Data Management (TDM)
  • Ability to prioritize tasks and achieve meaningful results that add measurable and tangible value to business partners in Capital
  • Must be able to build and maintain strong and collaborative working relationships with co-workers on the TDM team as well as Capital and Technology business partners
  • Ability to thrive and be energized in a challenging and dynamic environment where priorities and challenges are changing
  • Ability to provide clear oral and written communication to a variety of business and technical audiences

Desired Skills and Experience:

  • Prior experience working in Capital Management space and readily understand the important role that data management plays in support of the Capital function within Treasury
  • Ability to use advanced Excel functions such as pivot tables, VLookup, macros, Visual Basic and more to supplement advanced SQL skills in data analysis exercises
  • Prior experience in performing detailed analysis of Traded Products Data defects to identify patterns or root-causes and recommend improvements to processes or data flows to prevent future defects
  • Working knowledge of Tableau and/or Alteryx
  • Experience with data projects in Bank system of records and authorized data sources for Traded Products
  • Knowledge and experience with General Ledger data and reconciliations
  • Ability to reconcile work stream data to the General Ledger and other definitive sources

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

The Traded Products Data Analyst is responsible for:

  • Research & Analysis – supporting Fixed Income and Equities and/or OTC Derivative products as well as, understanding the overall flow and usage of information from upstream sources and consolidation points used for capital modeling, calculation and reporting processes
  • Subject Matter Expertise - learning and understanding how regulations, policy interpretation, product mix, transformations and risk drivers impact capital reporting processes
  • Operational Excellence – improving Treasury Data Management functions for production, data governance, data change and regulatory/audit activities
  • Data Controls - ensuring process controls, data validation activities, DQ scripts and measurement processes remain timely and relevant
  • Data Remediation - meeting SLA timelines for Data Incident analysis, Defect or Enhancement classification, Action Plan creation and Target Date delivery for Monthly Data Governance Process compliance, Remediation Execution & Validation

Required Skills and Experience:

  • Bachelor's Degree required
  • Minimum 3 years of experience within a financial institution with hands-on experience in Data Analysis
  • Basic understanding of Traded Products including Fixed Income Securities and their representation in data
  • Must be a self-motivated / self-starter and able to take ownership and self-accountability for ensuring that process controls, data validation activities, data quality scripts and measurement processes remain timely and relevant
  • Hands-on experience querying and analyzing large sets of data
  • Strong analytical and problem solving capabilities skills needed to perform complex data analysis
  • Ability to use SQL to perform complex data profiling activities and analysis of large amounts of data for logical understanding and problem
  • Ability to perform complex data lineage analysis spanning multiple source systems and data transformations from a Capital data perspective
  • Strong ability to think logically and critically to develop actionable solutions that help resolve data issues for Capital
  • Ability to apply expert judgment and understand the context of Capital data related issues and know how and when to escalate/communicate data issues as they occur
  • Must possess very strong communication skills with teammates within Treasury Data Management (TDM)
  • Ability to prioritize tasks and achieve meaningful results that add measurable and tangible value to business partners in Capital
  • Must be able to build and maintain strong and collaborative working relationships with co-workers on the TDM team as well as Capital and Technology business partners
  • Ability to thrive and be energized in a challenging and dynamic environment where priorities and challenges are changing
  • Ability to provide clear oral and written communication to a variety of business and technical audiences

Desired Skills and Experience:

  • Prior experience working in Capital Management space and readily understand the important role that data management plays in support of the Capital function within Treasury
  • Ability to use advanced Excel functions such as pivot tables, VLookup, macros, Visual Basic and more to supplement advanced SQL skills in data analysis exercises
  • Prior experience in performing detailed analysis of Traded Products Data defects to identify patterns or root-causes and recommend improvements to processes or data flows to prevent future defects
  • Working knowledge of Tableau and/or Alteryx
  • Experience with data projects in Bank system of records and authorized data sources for Traded Products
  • Knowledge and experience with General Ledger data and reconciliations
  • Ability to reconcile work stream data to the General Ledger and other definitive sources

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-22031160

Band: H5

Manages People: No

Travel: No

Manager:

Talent Acquisition Contact:

Davon Calloway [C]

Referral Bonus:

0