Consumer Product Strategic Analyst IV, Business Intelligence Fraud and Claims

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 performing more complex analysis aimed at improving portfolio risk, profitability, performance forecasting, and operational performance for consumer products and related divisions, such as credit cards. Key responsibilities include applying knowledge of multiple business and technical-related topics and independently driving strategic improvements, large-scale projects, and initiatives. Job expectations include working with business counterparts within the Line of Business and partner organizations including Risk and Product teams.

Responsible for performing complex analysis and data modeling for multiple products with the goal of maximizing profits and asset growth and 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. Develops subject matter expertise on the products and businesses they support in Fraud and Claims. Excels at risk/reward trade off. Build relationships with external agencies. Participates in the rollout of company-wide pilot programs developed as a result of business intelligence delivery frameworks and methods. 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. SAS or SQL and Microstrategy or Tableau experience is required. 5+years of programming and BI experience is required. May mentor or train junior associates as needed.

The Client Protection Business Intelligence analyst will provide analytical and data support for Consumer fraud and non-fraud products supporting adhoc report and analytical requests to support fraud and claims LOBs. The candidate will coordinate the production of performance reports and updates for key stakeholders in strategy, claims, finance, and product. The candidate will utilize established databases to provide performance insights to key stakeholders. The candidate will be tasked with analyzing and completing adhoc reports that will provide insights into performance, risk, client impacts, recoveries, and potential gaps.  SAS/SQL and Tableau or Microstrategy technical skills required.  Good working experience with HIVE SQL and Python is a plus.

•Act as a Business Analyst, interfacing with business stakeholders and translate business requirements into technical specifications.

•Develop and maintain innovative reports and dashboards using MicroStrategy 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, and help drive Self-Serve analytic capabilities.

•Help drive efficient yet robust reporting solutions that will help drive report consolidation and provide more self-serve opportunities

•Be positive, highly motivated, innovative, self-starter with strong sense of ownership and ability to create and execute plans with little oversight.

▪ Clearly articulate output and demonstrate reporting functionalities to all levels of Management

  ▪Validate the integrity and quality of data required for performing analysis

 ▪Partner with finance, capacity planning, claims, policy, strategy, and product teams to deliver data insights and analysis that inform critical decisions and help achieve goals.

Responsibilities:

• Performs complex analysis of financial models, market data, financial data, and portfolio trends to understand product performance and improve portfolio risk, profitability, performance forecasting, and operational performance

• Coaches and mentors peers to improve proficiency in a variety of systems and serves as a subject matter expert on multiple business and technical-related topics

• Identifies business trends based on economic and portfolio conditions and communicates findings to senior management

• Supports execution of large scale projects, such as platform conversions or new project integrations by conducting advanced reporting and drawing analytics based insights

Required Qualifications:

• 5+ years of experience leading end to end BI solutions including requirements gathering, sourcing, transformation, and reporting

• 5+ years of experience in data analysis and reporting, demonstrating advanced proficiency using SAS/SQL query language to access Teradata / SQL server databases

• 4+ years of Tableau / Microstrategy experience

• Ability to manage varied set of priorities, both planned and ad-hoc, and adapt within a dynamic and fast-paced environment. High level of multi-tasking with focus and oversight on requests across the team

• Excellent verbal and written communication, interpersonal, organizational, documentation, and presentation skills

• Ability to communicate and interact with a high degree of professionalism with executive level personnel across the business

• Ability to work independently as well as part of a virtual team

• Innovative mindset with the ability to challenge the status quo

• Ability to proactively identify, analyze, and improve upon existing processes for optimization and to meet deadline

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.

• Cutting-edge visualization and storytelling with data. Hands on experience designing data models and data transformation workflow.

• Experience with Alteryx, Hadoop, Impala, HIVE SQL, SQL server stored procedures and JAMS/Autosys schedulers.

• Certified MicroStrategy Architect (or other MicroStrategy Certification)

• Python, Hadoop, Pyspark

Skills:

• Analytical Thinking

• Business Analytics

• Data and Trend Analysis

• Fraud Management

• Problem Solving

• Collaboration

• Innovative Thinking

• Monitoring, Surveillance, and Testing

• Presentation Skills

• Risk Management

• Data Visualization

• Interpret Relevant Laws, Rules, and Regulations

• Issue Management

• Oral Communications

• Written Communications

Shift:

Hours Per Week: