Data Analyst with Banking and SQL

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.