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 https://dexian.com/ 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.