Vice President, Cons Prod Strategic Analyst

Bank of America Bank of America · Banking · Charlotte, NC

This role focuses on data analysis, extraction, and automation using Python, SAS, and SQL for a financial institution. It involves handling complex data structures, evaluating documents, and developing scripts for strategy simulations and control monitoring. The role requires experience in translating business requirements into SQL, creating testing solutions, and manipulating large datasets.

What you'd actually do

  1. Handle complex data structures across multiple lines of business and acquiring in-depth knowledge and demonstrating impact in a timely manner.
  2. Analyze data and determining root causes and summarizing Regulatory/Policy impacts.
  3. Apply knowledge of Python to extract and digitalize data from word and PDF documents, allowing for expanded monitoring automation.
  4. Leverage Python’s data imaging capabilities for use in strategy simulations, as well as evaluating numerous internal documents and summarize key themes to provide concentrated high priority items for review.
  5. Develop end to end Attribute Simulations scripts for different Lines of Business.

Skills

Required

  • Python
  • SAS
  • SQL
  • Selenium
  • Beautifulsoup
  • pdfminer
  • TOAD
  • Bacardi
  • Data analysis
  • Data extraction
  • Automation
  • Quantitative analysis

What the JD emphasized

  • 4 years of experience in the job offered or a related Quantitative occupation.
  • Must include 4 years of experience in each of the following: Translating complex business/system requirements into SQL coding to establish control monitoring; Creating and executing testing solutions using SQL coding, TOAD, SAS, and Bacardi; Identifying Python data extract options to evaluate documents for control monitoring; Using Python, Selenium, BeautifulSoup, and pdfminer packages to extract data and automate monitoring; and, Manipulating large data sets across complex data structures in coding tools using SAS and SQL coding.