Client Reporting Analyst III

Bank of America; Chandler (AZ); On-site; USD 60,000 - 100,000; Full time

Job summary

Join a forward-thinking financial institution where your skills in data analysis and reporting will shine. This role is pivotal in developing automated reports and dashboards that support management decision-making. You'll work with a variety of technologies, including SQL, SAS, and Tableau, to create comprehensive reporting solutions. Collaborate with cross-functional teams to translate business needs into technical specifications while enhancing your career in a supportive and inclusive environment. If you're driven, detail-oriented, and eager to make an impact, this opportunity is perfect for you.

Qualifications

• Experience in systems functional analysis and technology business analysis.
• Advanced knowledge of SQL and SAS required.

Responsibilities

• Design and maintain automated reports and dashboards using BI tools.
• Analyze disparate database sources and build relational data models.

Skills

SQL

SAS

Tableau

Data Mining

Automation

Data Visualization

Data Quality Management

Business Process Analysis

Attention to Detail

Agile Practices

Education

Bachelor's Degree in a related field

Tools

MicroStrategy

Excel

PowerPoint

Hadoop

Oracle

Teradata

BIT/GIT

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

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

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

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

Shift:

1st shift (United States of America)

Hours Per Week:

40