Traded Product Data Analyst

The Traded Products Data Analyst is responsible for:

Research & Analysis – supporting Cash Securities and Equities 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:

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 SAS, Python, Tableau and UNIX
Experience with data projects in Bank system of records and authorized data sources for Traded Products (Cash Securities & Equities)
Knowledge and experience with General Ledger data and reconciliations
Ability to reconcile work stream data to the General Ledger and other definitive sources

Keep in touch

Join our newsletter and stay up to date withe NABA Charlotte!