Bank Of America Data Automation Reporting Analyst 

United States, New Jersey 

911034726

This job is responsible for driving and executing on internal control discipline and operational excellence within a Line of Business (LOB) or Enterprise Control Function (ECF). Key responsibilities include providing analytical and administrative support for LOB or ECF specific processes and tools to drive adherence to enterprise-wide standards. Job expectations include monitoring and testing controls and implementing quality assurance and quality control processes within the LOB or ECF by evaluating data to help identify, track, and report issues and control improvements for remediation.

Line of Business Job Description:

Core responsibilities include analyzing and resolving highly complex problems and initiatives requiring exceptional handling and coordination of multiple operational and/or product specialists to resolve.

Responsibilities:

• Oversees the design and effectiveness of the risk and control environment to support Client Operational Services and ensure adherence to enterprise-wide standards
• Supports the monitoring and testing of controls by evaluating data to identify issues and control improvements for remediation
• Implements optimized controls and enhanced Quality Assurance (QA) practices to support business continuity efforts
• Conducts and coordinates quality inspection reviews to enhance employee performance and control effectiveness
• Performs QA activities including executing on controls, managing cases, and reporting results
• Executes initiatives by identifying areas of potential testing automation, procedural updates, thematic trends, test script updates, and coaching opportunities to enhance QA program success
• Supports the overall management of and research required for regulatory exams, internal audits, and other monitoring and inspection reviews and evaluates data and information relevant to inspection metrics to support governance activities for dashboard reporting

Additional Responsibilities may include:

• Managing an initiative from end-to-end starting with understanding the business need, gathering requirements, setting expectations, analyzing the data, and delivering the final solution; with transparency throughout
• Navigating multiple data environments and utilizing different analytics tools in order to transform data into actionable, data-driven solutions.
• Understanding relational databases containing customer, associate, product, and transaction data
• Analyzing problems and identifying both tactical and strategic solutions in support of operational processes and performance to the business controls organization
• Turning data into insights in order to ‘tell the story’ and present findings to various levels of the organization, including senior management and risk leaders
• Monitoring and testing the effectiveness of key controls and status of mitigation and/or action plans to remove bottlenecks and identify root cause of issues
• Adherence to a strong risk culture, including champion/challenger roles, peer reviews, change management discipline, standardization of processes, and rigorous documentation
• Striving for continuous process improvement through standardization and automation to reduce errors and increase efficiency
• Provide project management support for various transformational and reporting initiatives, including operational metrics and presentation materials

Required Skills:

• 3-5+ years of relevant work experience with automation, analytics, business controls, or combination of similar experience
• Demonstrated proficiency in utilizing data and analytic tools (HUE, Hadoop, HQL, Toad, Microsoft SQL, SAS, Oracle, Power BI, Impala, Hive)
• Ability to organize data for executive level reporting
• Strong organizational skills and high attention to detail
• Competent at adapting to changing business needs, applying critical thinking and demonstrating initiative
• Well versed in business automation and analysis via Excel-based analytics using;
  • External data source Links (Power Query)
  • V-Lookups and advanced formula’s
  • Pivot Tables
  • Visual Basic for Applications (VBA) / automation
  • Macros
• Strong interpersonal and overall communication skills (written and verbal)
• Highly motivated, proactive and a self-starter; strong sense of ownership & ability to create and execute plans without daily oversight
• Must be collaborative/ curious/ driven/ continuous learner
• Must be flexible and have experience working in a fast paced & high pressure environment; managing multiple projects at once
• Demonstrated proficiency in Microsoft Office applications:
  • Excel, Word, PowerPoint, Access
• Solid understanding and proficiency in the following BI / Automation tools
  • Hadoop/HUE
  • Power BI
  • Tableau
  • Alteryx
  • Toad for Data Point
  • Toad for Oracle
  • Structure Query Languages (TSQL, PL/SQL, HQL)
  • Sharepoint (Maintenance & Advanced Features)

Desired Skills:

• Bachelor’s degree in a quantitative field (e.g. Statistics, Engineering, Mathematics or Technology)
• Knowledge of AML and/or GBAM businesses focused on QA/QC Testing

Skills:

• Controls Management
• Issue Management
• Monitoring, Surveillance, and Testing
• Quality Assurance
• Risk Management
• Analytical Thinking
• Attention to Detail
• Critical Thinking
• Problem Solving
• Written Communications
• Decision Making
• Innovative Thinking
• Prioritization
• Recording/Organizing Information
• Research

1st shift (United States of America)