Client Reporting Senior Analyst

Bank of America; Pennington (AL); On-site; USD 110,000 - 157,000; Full time

Benefits offered by this job

Annual discretionary plan

Benefits eligible

Job summary

Bank of America is seeking an experienced BI reporting professional to lead automated reporting solutions across lines of business. You will design and maintain ETL processes, model data, and collaborate with partners to deliver insightful dashboards and reports.

Requirements include 5+ years with SQL and analytics, proficiency in MS365, and experience with SSMS/Oracle/Hadoop/Teradata. In-office role with 40 hours/week and a competitive benefits package.

Qualifications

• Experience with BI reporting tools and ETL processes.
• Strong SQL and data modeling skills.
• Experience across multiple data sources and bank products.
• Excellent communication and collaboration skills.
• 5+ years in database software and analytics.
• MS365 proficiency (Excel/PowerPoint).
• Experience with SSMS, Oracle, Hadoop, Teradata.

Responsibilities

• Leads critical aspects in the development and maintenance of innovative automated BI solutions.
• Designs, develops, and maintains automated ETL processes from various databases.
• Leads analysis of disparate data sources including relational structures and cubes.
• Ensures on-time delivery following procedures and quality guidelines.
• Partners with stakeholders to translate requirements into technical specs.
• Creates and maintains metadata, workflows, and desktop procedures.
• Works collaboratively in a cross-functional team and provides project updates.

Skills

Automation

Data Mining

Data Quality Management

Data Visualization

Technical Troubleshooting

Agile Practices

Business Acumen

DevOps Practices

Reporting

Technical Documentation

Change Management

Continuous Improvement

Innovative Thinking

Production Support

Technical Strategy Development

Job description

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 and providing a culture of caring is core to how we drive Responsible Growth. We are intentional about fostering an inclusive workplace where every teammate has the opportunity to succeed, build a career and contribute to our shared success. This includes attracting and developing exceptional talent, recognizing and rewarding performance, and supporting our teammates’ physical, emotional, and financial wellness through affordable, competitive and flexible benefits. We value the unique perspectives individuals bring from all backgrounds and career paths - whether shaped by military service, community college education, or a wide range of work and life experiences. These journeys foster resilience, leadership and innovation, strengthening our workforce and positively impact the communities we serve. Bank of America is committed to an in-office culture that supports collaboration, engagement, and career development. Our approach includes clear in-office expectations, while providing an appropriate level of flexibility based on role‑specific responsibilities and business needs. At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

Job Description:

This job is responsible for providing reporting support including leading the development work for automated reporting solutions serving one or more lines of business or business disciplines. Key responsibilities include developing and maintaining systems of knowledge delivered via easy to navigate automated self‑serve business intelligence solutions. Job expectations include working with business partners to understand client needs, creating solutions to meet those needs and leading aspects of the end to end development and deployment of the required reporting and analytical solutions.

Responsibilities:

• Leads critical aspects in the development and maintenance of innovative automated business intelligence solutions, supporting data-driven business decisions
• Designs, develops, and maintains automated data Extract, Transform, and Load (ETL) processes from various database platforms, storing data in ‘Fit for Use’ relational tables
• Leads analysis of disparate database sources including relational structures, dimensional data models, and cubes
• Ensures on‑time delivery of work while following established procedures and quality guidelines
• Partners with business stakeholders to translate business requirements into technical specifications
• Creates and maintains required standard documentation including metadata, detailed workflows documenting program, and desktop procedures
• Works collaboratively in a cross‑functional team, processing information from colleagues and providing routine updates during meetings related to projects

Required Qualifications

• Solid understanding of data gathering tools
• Proficient with business intelligence reporting tools
• Knowledge of bank data and ability to source across multiple products, services and line of businesses
• Strong analytical skills, with an investigative mindset and ability to use data to enhance efficiency and develop reporting to drive business insights
• 5+ years’ experience using database software and analytical tools to access large databases including SQL and/or coding experience
• Advanced proficiency in MS365 applications (Excel, PowerPoint, Copilot)
• Ability to think strategically across businesses to identify opportunities to improve overall performance efficiency
• Strong partnership and relationship building skills
• Proactive and organized with attention to detail, strong time management skills and follow through
• Excellent written, verbal communication skills
• Experience with SSMS, Oracle, Hadoop, Teradata
• Prior experience managing multiple projects and adjusting to changing deadlines

Desired Qualifications

• Experience with Python and statistical methods in understanding relationships in data

Managerial Responsibilities:

This position may also have responsibilities for managing associates. At Bank of America, all managers at this level demonstrate the following responsibilities, in addition to those specific to the role, listed above.

• Opportunity & Inclusion Champion: Models an inclusive environment for employees and clients, aligned to company Great Place to Work goals.
• Manager of Process & Data: Demonstrates deep process knowledge, operational excellence and innovation through a focus on simplicity, data based decision making and continuous improvement.
• Enterprise Advocate & Communicator: Communicates enterprise decisions, purpose, and results, and connects to team strategy, priorities and contributions.
• Risk Manager: Ensures proper risk discipline, controls and culture are in place to identify, elevate and debate issues.
• People Manager & Coach: Provides inspection, coaching and feedback to motivate, differentiate and improve performance.
• Financial Steward: Actively manages expenses and budgets in alignment with objectives, making sound financial decisions.
• Enterprise Talent Leader: Assesses talent and builds bench strength for roles across the organization.
• Driver of Business Outcomes: Delivers results by effectively prioritizing, inspecting and appropriately delegating team work.

Skills:

• Automation
• Data Mining
• Data Quality Management
• Data Visualization
• Technical Troubleshooting
• Agile Practices
• Business Acumen
• DevOps Practices
• Reporting
• Technical Documentation
• Change Management
• Continuous Improvement
• Innovative Thinking
• Production Support
• Technical Strategy Development

Shift:

1st shift (United States of America)

Hours Per Week:

40

Pay Transparency details

US - NJ - Pennington - 1400 American Blvd - Hopewell Bldg 4 (NJ2140)

Pay and benefits information

Pay range

$110,000.00 - $156,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.