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. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.

Being a Great Place to Work is core to how we drive Responsible Growth. This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve.

Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations.

At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

Job Summary

This role sits in Merrill Wealth Management Finance and focuses on building analytics solutions for balances, flows, and performance metrics. You will use SQL to explore and extract data from enterprise tables, design scalable reporting datasets, and deliver dashboards and automated reporting that improve decision-making and reduce manual effort across the areas of the workflow.

Line of Business Description:

This role is predominately focused on Merrill Wealth Management finance support. Merrill serves high-net-worth and ultra-high-net-worth individuals, businesses, institutions, and organizations. Anchored in financial planning, their personal advisor relationships help individual investors, and their families plan for and achieve their unique financial goals by investing and providing access to banking and lending services. The Regional Banking & Wealth Management Finance team works to support the Merrill business leaders by providing all aspects of financial reporting, planning, and analytics. Our team acts as a trusted partner enabling better decisions through transparency and strategic insights.

Responsibilities

• Write and optimize SQL queries to extract, validate, and reconcile finance and business metrics from enterprise data tables
• Build repeatable reporting datasets and automate recurring monthly/weekly deliverables (reduce manual Excel effort)
• Develop dashboards and executive-ready reporting (Power BI/Tableau/Excel) to track balances, flows, profitability, and IC drivers
• Partner with FP&A, controllership, and business teams to translate questions into data requirements and clear analytical outputs
• Perform variance analysis vs plan/forecast/prior period and explain drivers using data-backed storytelling
• Implement controls/QA checks (reconciliations, tie-outs, data quality flags) to ensure reliable outputs
• Improve processes by documenting logic, creating standardized definitions, and enabling self-serve reporting

Required Qualifications:

• 3+ years of work experience in finance analytics, FP&A, business analytics, or data-centric financial reporting
• SQL experience (writing joins, aggregations, CTEs; comfortable exploring unfamiliar tables)
• Advanced Excel skills (Power Query / Power Pivot strongly preferred)
• Experience building reporting/dashboards and automating recurring deliverables
• Strong problem-solving skills; able to independently investigate data issues and propose solutions
• Strong written/verbal communication; can explain “what changed and why” to non-technical partners
• Strong control mindset (reconciliations, documentation, repeatability)

Desired Qualifications:

• BS/BA Finance / Accounting
• Desire to learn and leverage emerging technologies (Tableau, Alteryx, Workiva, Picklinks, Power Query, Power Pivot)
• Knowledge of the GWIM business and associated corporate functions
• Deep understanding of corporate finance calendar and deliverables
• SAP/eLedger

Skills: Financial Processing, Analytical Thinking, Attention to Detail, Financial Accounting, Financial Forecasting and Modeling, Reporting, Scenario Planning and Analysis, Consulting, Critical Thinking, Business Analytics, Business Acumen, Influence, Prioritization, Problem Solving

Shift:

1st shift (United States of America)

Hours Per Week:

40

Pay Transparency details

US - NJ - Pennington - 1400 American Blvd - Hopewell Bldg 4 (NJ2140), US - NY - New York - 1100 Ave Of The Americas - Two Bryant Park (NY1540)

Pay and benefits information

Pay range

$90,000.00 - $125,900.00 annualized salary, offers to be determined based on experience, education and skill set.

Discretionary incentive eligible

This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.

Benefits

This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.