Client Reporting Analyst III

Bank of America; Fort Worth (TX); On-site; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a talented reporting analyst to develop and maintain innovative automated reports and dashboards. This role involves collaborating with business stakeholders to translate their needs into actionable insights, utilizing advanced tools like Tableau and SAS. You will play a crucial part in enhancing reporting processes and ensuring data quality across multiple platforms. Join a dynamic team that values diversity and fosters personal growth, while making significant contributions to the financial sector. If you are detail-oriented and passionate about data, this opportunity is perfect for you.

Qualifications

• Experience in systems functional analysis and technology business analysis.
• Strong SQL and SAS knowledge with experience in reporting tools.

Responsibilities

• Develop and maintain automated reports, dashboards, and scorecards.
• Collaborate with stakeholders to translate business needs into technical specifications.

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

Tools

Tableau

SAS

SQL

Excel

PowerPoint

MicroStrategy

Autosys

Shell Scripting

Python

MS SQL Server

Oracle

Hadoop

Teradata

Strategic Data Platform (SDP)

BIT/GIT Bucket

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

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