Data Analyst with Capital Markets & SQL - Charlotte, NC

Job Summary:

Dexian is seeking a Data Analyst with Capital Markets & SQL for an opportunity with a client located in Charlotte, NC.

Responsibilities:

• Assume ownership of current controls across multiple finance products. Ownership will include building, delivering and monitoring daily data controls essential for Regulatory Reporting
• Unwind SQL and ETL layers in Oracle database to identify issues/root cause analysis, understand logic/derivations and work with internal and upstream tech partners to resolve issues in a timely fashion
• Generate daily and monthly reports on data quality breaks and data validation shifts outside of BAU thresholds
• Drives and participates in design, development and implementation of future Treasury data controls
• Data Control Governance - Ensuring process controls, data validation activities, and measurement processes remain timely and relevant
• Change Management - Validates data and signs off on reports within test environments to confirm application accuracy, functionality and EDM Standards are met
• Manage relationships with diverse data partners and technology teams to support initiative work that demand aggressive timelines
• Collaborate with PMO Leads to and provide updates on project timelines, deliverables and obstacles / challenging
• Create reporting for senior management that proactively provides project status, issue / enhancement tracking and project implementation

Requirements:

• Bachelor's degree, or higher, in Business / related field, or related work experience
• 3+ years of experience in the Financial Services industry researching and remediating data issues impacting financial, risk, or regulatory reporting functions, project management or other data management & data control environment
• Knowledge/familiarity with loans, letters of credit and components of loans process in a financial institution
• Advanced knowledge of Microsoft software (Excel, Word, Power Point) including advanced excel functions such as pivot tables, Vlookup and Microsoft Visual Basic (VBA) to supplement SQL skills in data analysis exercises
• Demonstrated experience of key data analysis concepts through creation of SQL queries (Oracle, Teradata, and/or MS-SQL) to analyze large, complex sets of data, and develop quantitative + qualitative analytical determinations
• A balance of strong analytical & problem-solving skills and excellent communication & presentation skills - the ability to dig into complex issues and then summarize in a clear, concise message to facilitate decisions and drive action
• Must be highly organized and self-motivated, able to work as part of a team in a fast-paced environment and balance multiple priorities simultaneously
• Prior experience with managing relationships with diverse data partners and technology teams to support initiative work that demand aggressive timelines

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.