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

b0dSZ3FmTWRBTktickVTQ2xWMWlZeE5RaHc9PQ==
  • 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

Harnham

Principal Software Engineer Job at Harnham

 ...Principal Software Engineer Location: San Francisco Bay Area Job Type: Open to remote for highly experienced candidates (6+ years minimum) Summary: My client is a biotech startup leveraging AI/ML technologies to develop precision cancer therapeutics. We are... 

Cassia CONNECT

Certified Nurse Assistant (CNA) Job at Cassia CONNECT

 ...Begin a fulfilling career as a Certified Nursing Assistant (CNA) at Park View Care Center and make a meaningful impact! At Park View Care Center, we're not just colleagues; we're a supportive, family-centered community. Were dedicated to bringing joy and enthusiasm... 

Bureau Works

Freelance translator (remote) Job at Bureau Works

 ...experiences that get results - all backed by enterprise-grade hosting and security. We are currently accepting applications for our freelance translator talent pool.We will review your application and contact you if we have any suitable opportunities. We look forward... 

BakeMark

Warehouse Manager Job at BakeMark

 ...Time Off SUMMARY: Directs and coordinates activities of warehouse operations to obtain optimum use of equipment, facilities, and...  ...the following duties personally or through associates. SHIFT: 1st Shift - Starting at 5:00am ESSENTIAL DUTIES AND RESPONSIBILITIES... 

Dobbi

Community Manager Job at Dobbi

 ...COMPANY OVERVIEW At Dobbi, we are a dynamic digital marketing agency dedicated to helping businesses achieve their marketing goals. Our team specializes in creating tailored digital strategies that drive growth and engagement for our clients. We pride ourselves on staying...