Data Mgmt Analyst w/ traded products, SQL, Excel in Charlotte, NC at Signature Consultants

Date Posted: 11/10/2020

Job Snapshot

Job Description

Data Mgmt Analyst w/ traded products, SQL and excel experience:

Signature Consultants is seeking the Data Management Analyst for an opportunity with a client in Charlotte, NC.


  • Research & Analysis - Supporting Traded Products Counterparty Capital Management team from a Treasury Data Management (TDM) perspective in analyzing, monitoring and improving critical Data Flow and Data Quality.
  • 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 - Expert in the understanding of Data Flow, Data Quality and Data Usage of information from upstream sources and consolidation points for capital calculations and reporting. Be SME in identifying, analyzing and solving complex data issues in an efficient, transparent and collaborative fashion within TDM.
  • Data Controls - Ensuring process controls, data validation activities, Data Quality 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.

Required Skills and Experience:

  • Minimum 5 years of experience within a financial institution with hands-on experience in Data Analysis
  • Understanding of Traded Products including Derivatives, Repo, Fixed Income, FX, Equities 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 complex data issues for 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:

  • Hands-on experience querying and analyzing large sets of data.
  • 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 (Derivatives, Repo, Fixed Income, FX, Equities)
  • Knowledge and experience with General Ledger data and reconciliation

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.