Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Data, Automation and Reporting Analyst

AT Merrill
Merrill

Data, Automation and Reporting Analyst

Charlotte, NC

Job Description:

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.

One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. We're devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being.

Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization.

Want more jobs like this?

Get jobs delivered to your inbox every week.

Select a location
By signing up, you agree to our Terms of Service & Privacy Policy.


Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!

Job Description:
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:

The Global Credit AML & Onboarding Operations (GCAOO) organization is a central control function which governs, facilitates, and oversees the global end-to-end GCAOO program across all GB&GM businesses and jurisdictions through the implementation of processes and controls to effectively manage AML and economic sanctions risks. The team performs AML Know Your Customer/Client Due Diligence (KYC/CDD) and covers refresh (periodic review) as its core activity.

This role is within the GCAOO Business Controls Team and will support the team in mitigating risk, monthly control execution, and with execution and management of the ILQA Program through various initiatives to drive process improvements and control performance sustainability.

The candidate will be responsible for supporting GCAOO Business Controls operational functions and programs through automation of existing processes, routine ad-hoc data analysis, reporting, presentations, as well as providing general initiative support for the GCAOO Business Controls team. Will work closely with operational, reporting teams, Project Management Office and Technology to support existing automation, analytics and reporting capabilities while supporting the creation of new capabilities.

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

Shift:
1st shift (United States of America)

Hours Per Week:
40

Client-provided location(s): Charlotte, NC, USA; Jacksonville, FL, USA; Pennington, NJ 08534, USA
Job ID: Merrill-JR-24036670
Employment Type: Full Time