Data Analyst with Banking and SQL Job at Dexian, Charlotte, NC

VnQrUHZDcWpOOHBpVXdSK2kySnQ1NS9sTnc9PQ==
  • Dexian
  • Charlotte, NC

Job Description

Job Summary:

Dexian is seeking a Data Analyst with Banking and SQL for an opportunity with a client located in Charlotte, NC.

Responsibilities:

  • Management of Project Mailbox and Office Hours for:
    • 1) LOB Questions and 2) Coordination of Completed Templates with Alteryx Workflow
  • Pull Year-End and front-book monthly LOB cuts for distribution with template by monthly timeline
    • a. Coordinate with PMs for distribution to LOB leads
  • Process and action (where applicable) Alteryx batches including the following distinct populations:
    • a. DQ Follow-ups to LOB
    • i. Email to LOB central contacts with follow-up request
    • ii. Communication and follow-up will need to be differentiated based on QA rule flagged
    • b. QA Results - Clean Results - not SPE or Look-through SPE
    • c. SPE (US & EU) and Look-through SPE (US)
    • i. Assess materiality
    • ii. Assess impacts for ECC communication
    • iii. Create override requests
    • iv. Verify overrides in production data
  • Coordinate with PMs for metric tracking and materials based on Alteryx data and ECC materials


Requirements:

  • Must have 5+ years in Financial Services industry with knowledge of database structures, data sourcing, data warehousing finance and accounting concepts
  • Strong understanding of key banking products including but not limited to loans, deposits, secured funding transactions, derivatives, and trading assets
  • Advanced SQL experience and understanding of relational database
  • Advanced Microsoft Office suite software skills (Excel, Access, Word, SharePoint, One Note, Project)
  • Experience with Oracle, SQL Server, Alteryx, Teradata, DB2, Netezza, Hadoop, SAP eLedger, Rally, Visio, ETL tools and Data Management tools
  • Counterparty data background/experience
  • Finance/Regulatory Reporting Knowledge
  • Builds Partnerships - broad-based business relationships across the bank line of business. Positively and skillfully influences peers, colleagues, leaders, and business
  • Partners to collaborate and deliver consistent quality results
  • Must be local to Charlotte
  • Must have SQL
  • No C2C

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

Local area, Worldwide,

Similar Jobs

Dignity Health

Nutrition Assistant 2 Job at Dignity Health

 ...Summary:**Participates and supports all aspects of healthcare food service operations. Works with facility staff to provide optimal nutritional care and demonstrates excellent customer service to patients, guests and staff. Follows diet manual handbook and diet... 

bondex app

Junior Backend Developer Job at bondex app

 ...Key Responsibilities: Develop, test and maintain backend services and APIs using Node.js and TypeScript. Collaborate with frontend developers and blockchain engineers to ensure seamless integration with smart contracts and web applications. Work with databases... 

UPS

Class 3 Delivery Driver Job at UPS

**** 500 UPS ******Responsibilities**+ Daily delivery and collection of inbound/outbound...

K.A. Recruiting, Inc.

Histotech OR Histotechnologist OR Histotechnician Job at K.A. Recruiting, Inc.

Histotech opening at a beautiful facility in the MANITOWOC, WI area Many different shift options available! Details: full time, permanent position extremely competitive pay excellent benefits Requirements: ASCP (or equivalent) certification as a Histotech Click...

Johns Hopkins Medicine

Nurse Practitioner or PA - Cardiac First Assist Job at Johns Hopkins Medicine

 ...in multiple specialties by U.S. News & World Report, we provide access to innovative treatments and therapies. With more than half of the...  ...Science in Physician Assistant with National Certification or Nurse Practitioner with RNFA certification.* 3 years minimum experience...