Data, Automation and Reporting Analyst Pennington, New Jersey;Charlotte, North Carolina **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. 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 Bank of America and its affiliates consider for employment and hire qualified candidates without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity and affirmative action, in accordance with all applicable federal, state, provincial and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our teammates. To view the "EEO is the Law" poster, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf) . To view the "EEO is the Law" Supplement, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP\_EEO\_Supplement\_Final\_JRF\_QA\_508c.pdf) . View the LA County Fair Chance Ordinance (https://dcba.lacounty.gov/wp-content/uploads/2024/08/FCOE-Official-Notice-Eng-Final-8.30.2024.pdf) . Bank of America aims to create a workplace free from the dangers and resulting consequences of illegal and illicit drug use and alcohol abuse. Our Drug-Free Workplace and Alcohol Policy (“Policy”) establishes requirements to prevent the presence or use of illegal or illicit drugs or unauthorized alcohol on Bank of America premises and to provide a safe work environment. To view Bank of America’s Drug-free Workplace and Alcohol Policy, CLICK HERE . This communication provides information about certain Bank of America benefits. Receipt of this document does not automatically entitle you to benefits offered by Bank of America. Every effort has been made to ensure the accuracy of this communication. However, if there are discrepancies between this communication and the official plan documents, the plan documents will always govern. Bank of America retains the discretion to interpret the terms or language used in any of its communications according to the provisions contained in the plan documents. Bank of America also reserves the right to amend or terminate any benefit plan in its sole discretion at any time for any reason.