Client Reporting Analyst III - Global Operations - Global Market Operations

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 a diverse and 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.

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 developing reports to support management decision making. Key responsibilities include performing all phases of the report development process including participating in client meetings to understand needs and develop requirements, performing data research and data discovery, data sourcing including data automation, creating report visualizations, and managing report deployment including user on-boarding. Job expectations include developing, maintaining, or enhancing components of large reporting platforms to deliver comprehensive end-to-end reporting solutions.

The Global Data & Reporting Operations (GDRO) Business Intelligence and Data Strategy Team (BIDS) is seeking an individual responsible for developing reports to support management decision making.

Responsibilities:

• Designs, develops, and maintains innovative automated reports, dashboards, and scorecards using Business Intelligence tools including MicroStrategy and Tableau
• Designs, develops, and maintains automated data Extract, Transform, and Load (ETL) processes from various database platforms, storing data in ‘Fit for Use’ relational tables
• Analyzes disparate database sources including relational structures, dimensional data models, and cubes
• Designs and builds relational data models to support the development of actionable reports, dashboards, and scorecards
• 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, learns from colleagues, and provides routine updates on calls related to projects

Required Skills:
Experience with systems functional analysis, technology business analysis, and basic understanding of the different technical platforms, databases, and related technologies
Advanced knowledge of SQL,
Intermediate knowledge of Autosys, Shell Scripting or Python
Advanced knowledge of Excel (functions and formulas) and PowerPoint
Understand concepts of the Enterprise Databases (The W), MS SQL Server, Oracle, Hadoop, Teradata, and the Strategic Data Platform (SDP)
Working knowledge of software version control systems such as BIT/GIT Bucket
Ability to translate high level business requirements into technical data requirements
Strong communication skills (verbal, written and presentations)
Strong attention to detail and due diligence

Skills:
Desired Skills:
• Advanced knowledge of Tableau
• Intermediate knowledge of Alteryx
• High aptitude for self-motivation and self-determined project work
• Data Mining Experience using SQL/SAS querying
• Understanding of Reporting Data Governance
• Process designer experience is a plus

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Pay Transparency details

US - IL - Chicago - 540 W Madison St - Bank Of America Plaza (IL4540), US - NY - New York - 1100 Ave Of The Americas - Two Bryant Park (NY1540)

Pay and benefits information

Pay range

$73,200.00 - $121,200.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.