Data Analyst with SQL and Traded Products

Job Summary:

Dexian is seeking a Data Analyst with SQL and Traded Products for an opportunity with a client located in Charlotte, NC.

Responsibilities:

• Assume ownership of current Data Management controls across multiple finance products. Ownership will include building, delivering and monitoring daily data controls essential for Liquidity / 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 data controls
• Liaise between Treasury lines of business and Technology team and other Data Management analysts to communicate control status and escalate issues according to defined process
• Data Control Governance - Ensuring process controls, data validation activities, and measurement processes remain timely and relevant
• Create and maintain required documentation and evidence to ensure adherence to EDM Standards and RDA requirements
• Work under minimal supervision on Corporate Treasury projects that require creative solutions under very tight deadlines
• Operational Excellence - Improving Treasury Data Management functions for production, data governance, data change and regulatory/audit activities
• 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 time lines
• Collaborate with PMO Leads to and provide updates on project time lines, deliverables and obstacles / challenging

Requirements:

• Bachelor's degree
• Advanced knowledge of Microsoft software (Excel, Word, Power Point) including advanced excel functions such as pivot tables, VLOOKUP to supplement SQL skills in data analysis exercises
• Demonstrated experience querying and analyzing large sets of data using SQL (data warehouse is Oracle)
• Ability to work in a fast-paced environment, be creative, and be able to balance multiple priorities simultaneously
• Strong analytical and problem solving capabilities skills needed to perform complex data analysis
• Must possess very strong communication skills with teammates and leadership within Data Management (DM)
• Ability to work independently and take lead on addressing issues
• Strong knowledge and prior experience with Data Controls monitoring and/or Data Control governance practices
• Banking or Financial Experience
• Experience supporting or working in Liquidity Management with concentration in Global Markets Products (Derivatives, Secured Funding, etc.)

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.