Capital Markets Data Analyst

Insight Global is seeking experienced Data Analyst for a large financial services client in the Charlotte, NC area. This bank is hiring on a 12-24 month contract basis (with the potential to convert permanent). These positions will be hybrid (3 days on site), and we have openings across their different product lines. We are seeking experienced Data Analyst with strong SQL skills. The positions are spread amongst their Traded Products, Financial Products, Banking Products, and Treasury Products teams within their CFO Data Management organization. Candidates will be responsible for:• Assume ownership of current CFO Data Management 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 • 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 CFO 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 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 implementationRequired SkillsBachelor's degree3 to 6 years of data analysis and product expertise within the financial industry Alteryx or SQL experience preferred. Flexible if candidates have strong Excel skillsTreasury, Traded, Financial, or Banking Product experience (derivatives, securities, options, swaps, loans, debit cards, credit cards, checking/savings accounts, etc)Desired Skills:Counterparty data experienceAlteryx experienceLiquidity (2052 A reporting)/Treasury experience Experience with Oracle, SQL Server, Alteryx, Teradata, DB2, Netezza, Hadoop, SAP eLedger, Rally, Visio, ETL tools and Data Management toolsStrong knowledge and prior experience with Data Controls monitoring and/or Data Control governance practiceBank of America, Regulatory Reporting, Client onboarding, or data management experience a plusPrevious familiarity with Bank of America platforms (PRDS, WCC, GWIM, CED, CESIUM)Exposure to Agile methodology

Created: 2025-03-09