DA w SQL and Derivatives Job at Dexian, Charlotte, NC

VkxVVEhHUGJiYk1vSE5rSTJtcDdncDdnTXc9PQ==
  • Dexian
  • Charlotte, NC

Job Description

Job Summary:

Dexian is seeking a DA w SQL and Derivatives for an opportunity with a client located in Charlotte, NC.

Responsibilities:
  • Research & Analysis - Supporting Traded Products Counter party Capital Management team from a Treasury Data Management (TDM) perspective in analyzing, monitoring and improving critical Data Flow and Data Quality with the goal of ensuring the timeliness and accuracy of Capital calculations for the Bank. 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 into Capital for capital calculations and reporting. Be Subject Matter Expert 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


Requirements:

  • Minimum 8 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
  • 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
  • No C2C
  • Must Have SQL and Derivatives

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

Job Tags

Worldwide,

Similar Jobs

LGM Glass Designs

Project Manager Job at LGM Glass Designs

 ...illness and heavy workload. General Qualifications College graduate or equivalent industry experience with a degree in Building...  ...with a variety of products on all sizes of projects in the new and remodel market segments. Ability to relate to architects,... 

Heyden Supply

Outside Sales Representative Job at Heyden Supply

 ...long-lasting relationships and delivers outstanding results. Role Description This is a full-time on-site role for an Outside Sales Representative located in Duluth, GA. The Outside Sales Representative will be responsible for identifying and developing new... 

U.S. Tsubaki Power Transmission, LLC

Large Press Operator (SDKY) - 3rd Shift Job at U.S. Tsubaki Power Transmission, LLC

Description: The TSUBAKI name is synonymous with excellence in quality, dependability and customer service. U.S. Tsubaki is a leading manufacturer and supplier of power transmission and motion control products. As a part of a vast, international network of corporate and...

Roots and Wings

Program Assistant Job at Roots and Wings

 ...Roots and Wings Inc. is seeking a part-time Program Assistant to support ProjectUpLift, our free after-school literacy program serving students at 20 Title I elementary schools throughout Palm Beach County. ProjectUpLiftprovides small-group after-school reading instruction... 

ClinLab Solutions Group

Quality Assurance Manager Job at ClinLab Solutions Group

 ...DAP Quality Assurance Manager West Chester, Ohio My client is a technology-focused biomanufacturing company thats changing the way medicine is made. Were building a sustainable network of high-tech, end-to-end manufacturing solutions to better withstand disruptive...