Client Reporting Analyst III

adesso SE; Fort Worth (TX); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading financial institution is seeking a skilled reporting analyst to develop innovative automated reports and dashboards. The ideal candidate will have advanced knowledge of SQL, SAS, and Tableau, with strong analytical and communication skills. This role involves collaborating with cross-functional teams to deliver comprehensive reporting solutions and support decision-making processes.

Qualifications

• Experience with systems functional analysis and technology business analysis.
• Advanced knowledge of SQL and SAS.
• Strong communication skills and attention to detail.

Responsibilities

• Designs and maintains automated reports and dashboards using BI tools.
• Develops and manages ETL processes from various database platforms.
• Collaborates with stakeholders to translate requirements into 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

SQL

SAS

Python

Excel

PowerPoint

MicroStrategy

Tableau

Oracle

Hadoop

Teradata

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