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

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

Hartree Partners

Power Settlements Analyst Job at Hartree Partners

 ...management Job Requirements: ~ Bachelors degree in Business, Accounting, or Finance strongly preferred ~23 years of experience in power settlements is required ~ Strong analytical and communication skills ~ Proficiency in Microsoft Excel, including VLOOKUPs,... 

Four Streams, LLC

Server Job at Four Streams, LLC

 ...POSITION SUMMARY: The server is responsible for greeting members and guests, taking orders and serving food and beverages. Also responsible...  ...setup, breakdown and cleanup for events # Answer incoming calls professionally and take reservations accurately and check... 

Beacon Hill

Dental Billing Coordinator - Aging Job at Beacon Hill

 ...Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting . Benefits Information: Beacon Hill offers a robust... 

Ajulia Executive Search

Marketing Director (Food Manufacturing) Job at Ajulia Executive Search

 ...Marketing Director (Food Manufacturing) Food Industry Experience Extensive experience in developing and executing marketing strategies...  ...is a search firm specializing in Manufacturing, Finance, IT, Legal and Pharmaceutical positions. This is a confidential search for... 

The US Sun

Freelance Consumer Reporter Job at The US Sun

 ...Part of News Corp, The Sun is a global publisher and one of the biggest news brands in the UK. Our talented and diverse team publishes the best coverage of news, sport, TV, showbiz, consumer and lifestyle. In early 2020 we launched a US edition and have built the newspaper...