Traded Product Data Analyst

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:

Shift: 

Hours Per Week:

Weekly Schedule:

Referral Bonus Amount: