Data Analyst w/ Capital Markets in Charlotte, NC at APEX Systems

Date Posted: 7/13/2018

Job Snapshot

Job Description

Job #:  830450

  • Data Analyst w/ Capital Markets
  • Charlotte, NC
  • Duration: 12-18 months +
  • Please email resumes to

Secured Funding Data Steward/Analyst 
3-8yrs experience 
• Previous Financial Institution experience with Secured Funding or Secured Financing experience preferred. 
• Functional knowledge and experience with Repurchase Agreement (Repo), Reverse Repo, Securities Lending, and Securities Borrowing 
• Ability to mine data via multiple database management tools including Aginity for Netezza, Oracle, MySQL, DB2 , Teradata RDBMS, Sybase, SQL Server, Spotfire, and Tableau. 
• Intermediate/Advanced Excel. VBA a plus. 
• Functional knowledge and experience with Balance Sheet/General Ledger systems. 
• Strong relationship building and organizational skill with ability to identify, research, analyze and resolve complex problems. 
• Detail and deadline oriented with strong analytical skills. 
• Ability to works independently, with limited direction. 
• Ability to understand, document, and explain complex data flows. 
• Ability to work in a fast-paced environment with competing priorities while maintaining a degree of creativity. 

Description : 
 Candidate will be involved with daily control and governance work supporting PB/SF/AT products and measurements along with various Liquidity Risk Management initiative workstreams including; Recovery and Resolution Planning (RRP), Net Stable Funding Ratio (NSFR), FR2052a (Fed 5G), Funds Transfer Pricing (FTP/Cost of Carry), Liquidity Coverage Ratio (LCR), Capital Requirements Directive (CRD IV), Additional Monitoring Metrics (AMM), and Basel III. Candidate will be responsible for consistent, timely, and accurate data stewardship while providing product and technical expertise. Candidate must manage relationships with upstream data providers and downstream provisioning to ensure data quality and usability, work with data architects and application managers to deliver technology solutions. Define strategic technical solutions with business and technology partners. Develop functional designs based on analysis of line of business needs, objectives and existing systems infrastructure. Ensure requirements and designs are translated to working technical designs, so that test plans serve customer needs. Responsible for instituting and maintaining Data Quality, Data Validation, and reconciliation controls. 

Required: Top 3 skillsets including number of years needed for each 
1. Data mining via multiple database management tools including Aginity for Netezza, Oracle, MySQL, DB2 , Teradata RDBMS, Sybase, SQL Server, Spotfire, and Tableau. 1-3 yrs 
2. Familiarity with Project Management SDLC methodologies including Agile, Scrum, Waterfall. 1-3yrs 
3. Middle Office/Finance background. 3-8 yrs









EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 844-463-6178.