Client Reporting Analyst III-Pre-Paid Card
Charlotte, North Carolina;Belfast, Maine; Jacksonville, Florida; Phoenix, Arizona; Plano, Texas; Fort Worth, Texas; Chandler, Arizona; Wilmington, Delaware; Chicago, Illinois
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 Summary
Client Reporting Analyst III within the Prepaid Card Data Analytics and Reporting team provides reporting that is insightful, reliable, easy-to-use, scalable and sustainable. The team is responsible for managing reports for the Pre-Paid Card product and claims.
This position manages existing SQL/SAS/Tableau reporting solutions, assists with the development new reporting capabilities, as well as modernize legacy reporting using SAS EG and Tableau technology. To perform this work, the person in this role will be required to understand customer, associate, product, and transaction data to create ETL, architect an efficient data environment, and develop actionable reports. As such, the analyst must have strong communication skills and an ability to “translate” business and analytics requirements into technical specifications. Furthermore, the successful candidate will be expected to:
• Interface with business stakeholders and translate business requirements into technical specifications.
• Develop and maintain innovative reports, dashboards, and processes using SAS, SQL, and Tableau.
• Analyze disparate database sources, including relational structures, dimensional data models and cubes.
• Develop and maintain database objects and ETL to support data preparation for BI reports, dashboards, scorecards, and Self-Serve analytic capabilities.
• Work collaboratively in a cross-functional team.
Job Description:
Responsible for developing reporting from data acquisition through report development and delivery. Can also be responsible for complex components of large reporting platforms. Frequent client engagement at all levels is required as part of day to day work. Participates in client meetings to understand needs and occasionally is asked to contribute specialized knowledge. Leads smaller reporting projects or components of a larger effort. Little to no direct associate management. Expert at tools and process used to build reports end to end. Seen as having good working experience, knows data and business well. May have an area of expertise others look to for coaching and best practices. Good understanding of data gathering tools, proficient with business intelligence reporting tools, 5+ years of experience.
Required Skills
• 3+ years of experience in data analysis and reporting, demonstrating advanced proficiency using SAS EG/SQL query language to access Teradata / SQL Server / Hadoop databases.
• 3+ years of Tableau developer experience preferred.
• Ability to analyze, diagnose and resolve data management related problems.
• Meet development project deadlines and enhance existing reporting while maintaining production service level agreements.
• Excellent verbal and written communication, interpersonal, organizational, documentation, and presentation skills.
Desired Qualifications:
• Bachelor's Degree in Statistics, Finance, Computer Science, Information Systems, Mathematics, Engineering, or an analytical field, or equivalent experience
• Experience in financial services with emphasis on business insights and data/financial analysis; specific experience with card services.
• Experience with Unix commands, Shell scripting and Teradata BTEQ scripting
Skills:
Automation
Data Mining
Data Quality Management
Data Visualization
Technical Troubleshooting
Agile Practices
Business Acumen
DevOps Practices
Reporting
Technical Documentation
Change Management
Continuous Improvement
Innovative Thinking
Production Support
Technical Strategy Development
Shift:
1st shift (United States of America)
Hours Per Week:
40
Bank of America and its affiliates consider for employment and hire qualified candidates without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity and affirmative action, in accordance with all applicable federal, state, provincial and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our teammates.
To view the "EEO is the Law" poster, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf) .
To view the "EEO is the Law" Supplement, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf) .
Bank of America aims to create a workplace free from the dangers and resulting consequences of illegal and illicit drug use and alcohol abuse. Our Drug-Free Workplace and Alcohol Policy (“Policy”) establishes requirements to prevent the presence or use of illegal or illicit drugs or unauthorized alcohol on Bank of America premises and to provide a safe work environment.
To view Bank of America’s Drug-free workplace and alcohol policy, CLICK HERE .
I have 3 years of experience analyzing data and creating reports using tools like Excel and SQL.
Functioning as the Reporting Analysts, we are accountable for developing the systems and standards that are necessary for business reports. We are responsible for assisting with financial reporting. We are able to communicate and collaborate with different business stakeholders for giving insightful analysis through metrics. As Reporting Analysts, we contribute to organizational improvement by introducing process improvements throughout the reporting process. We set realistic expectations for stakeholders regarding delivery dates and their standards. It is also a part of our work to provide technical insights while streamline reporting. We are self-motivated, highly analytical, and detail-oriented professionals.
Core tasks:
