Client Reporting Analyst III

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 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.

This is a business critical role that supports Business Controls Reporting. Responsible for developing control reporting utilizing multiple database platforms. Must have the ability to understand and manage data relationships across different systems. This role requires the ability to develop and own end to end processes, maintain existing code, analyze report requirements, and develop based on reporting needs using Tableau, SAS, SSRS, ETL Process and/or other technology recommended BI Tools. Knowledge of Credit Furnishing & Disputes (CFD), Consumer Tax Operations (CTO) is a benefit. This position requires the ability to communicate effectively and work across multiple teams to support various initiatives. Self-motivated, responsible, and due diligence are key drivers to be successful in this role.

Responsible for performing more complex analysis for minimizing risk and operating losses and/or other financial and marketing exposures. Develops complex program models to extract data and uses multiple databases to acquire statistical and financial data. Utilizes portfolio trends to propose policy/procedural changes within segmentation structure to produce optimal results. Excels at risk/reward trade off. Build relationships with internal partners. Duties primarily include the regular use of discretion, independent judgment, the ability to communicate with multiple levels of management and the utilization of core leadership behaviors.

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

Skills:

• Automation
• Data Mining
• Data Quality Management
• Data Visualization
• Reporting
• Agile Practices
• Attention to Detail
• DevOps Practices
• Production Support
• Technical Documentation
• Business Acumen
• Business Process Analysis
• Continuous Improvement
• Innovative Thinking
• Quality Assurance

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, SAS
• 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

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