Consumer Product Strategy Analyst III - Analytics & Model Development

Bank of America; Charlotte (NC); On-site; USD 79,000 - 119,000; Full time

Job summary

An established industry player seeks a Consumer Product Strategy Analyst to join their Analytics & Model Development team. This pivotal role involves data sourcing, automation, and reporting to enhance client services and resource planning initiatives. The successful candidate will utilize advanced tools like SQL, Tableau, and SAS to develop insightful dashboards and conduct statistical analyses. With a commitment to diversity and inclusion, this dynamic workplace offers opportunities for professional growth and a chance to make a meaningful impact in the financial sector. If you're ready to take your career to the next level, this is the opportunity for you.

Benefits

Industry-leading benefits

Paid time off

Discretionary incentive eligibility

Support for employee wellness

Qualifications

• 3+ years of SQL coding experience with SQL Server, Oracle, and Hadoop.
• Strong analytical and problem-solving skills to communicate effectively.

Responsibilities

• Develop reporting and dashboards using Tableau and PowerBI.
• Perform statistical analysis using tools like SAS and Python.
• Gather and document business requirements for new development.

Skills

Business Analytics

Data Visualization

Analytical Thinking

Problem Solving

Collaboration

Written Communications

Oral Communications

Data Quality Management

Critical Thinking

Research

Education

Bachelor’s degree in a quantitative discipline

Tools

SQL

Tableau

PowerBI

Excel

Alteryx

SAS

Python

Oracle

Teradata

Hadoop

Job description

Consumer Product Strategy Analyst III - Analytics & Model Development

Consumer Product Strategy Analyst III - Analytics & Model Development

Apply locations: Charlotte, Rio Rancho, Plano, Greensboro, Scranton

Time type: Full time

Posted on: Posted Yesterday

Job requisition id: 25017344

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.

Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations.

At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

This position is not eligible for sponsorship.

Job Description:

The Analytics and Model Development team is part of Retail Banking’s CSCA Operations Enablement group, focused on supporting Client Services and CSCA resource planning initiatives. The AMD team is responsible for data sourcing, automation, reporting, and forecasting, utilizing a variety of systems/platforms including, but not limited to, Excel, SQL, Tableau, Alteryx, and SAS. The candidate will perform a combination of functions including 1) data sourcing, automation, and ETL workflow builds, 2) performing analysis and creating reports utilizing latest technologies, and 3) uncover insights from data that can be used in decisioning and present findings to executive stakeholders.

Additional areas of focus include forecasting support, modeling of various performance metrics, monitoring of variance deviations in forecasting performance, and development of data quality controls. Other objectives include supporting the rollout of new projects, defining project requirements, monitoring development progress, and the assessment and development of tools to automate and streamline existing processes.

Responsibilities:

• Develop new reporting and executive dashboards using tools such as Tableau and PowerBI
• Enhance existing reports and forecasting processes to improve delivery time and model accuracy
• Design processes to support data extraction and transformation using tools such as Alteryx and SAS
• Create SQL logic to source data from various systems including Oracle, Teradata, SQL Server, and Hadoop
• Gather and document business requirements for new development items
• Identify OpEx and streamlining opportunities and escalate for addition to team backlog
• Partner with other CSCA teams to identify optimization opportunities
• Perform statistical analysis using tools such as SAS and Python
• Work with leadership to maintain appropriate prioritization of concurrent ongoing projects in a changing environment
• Identify data quality gaps and develop controls to mitigate
• Collaborate and build relationships with cross-functional teams who supply required data for our processes
• Complete required development testing to ensure data quality and accuracy
• Perform ad hoc analysis as needed on various call center metrics

Required Qualifications:

• 3+ years of SQL coding experience with SQL Server, Oracle, Hadoop, and Teradata systems
• 3+ years of Tableau, PowerBI, or MicroStrategy experience
• Advanced Excel proficiency
• Strong written and oral communication skills with broad business acumen
• Ability to manage multiple projects in a complex and rapidly-changing environment
• Excellent time management skills
• Ability to work independently as well as part of a team
• Strong analytical and problem-solving skills to effectively communicate with technical and non-technical audiences and quickly escalate any risks or challenges
• Positive attitude and willingness to learn

Desired Qualifications:

• Proficient in one of SAS, Python, R
• Experience with Alteryx or other ETL tools
• Advanced analytical and quantitative skills with demonstrated ability in using data and metrics to identify root causes
• Familiarity with SDLC and Project Management methodologies such as Agile and Six Sigma
• Bachelor’s degree, ideally in a quantitative discipline such as mathematics, statistics, economics, business, engineering, finance, or operations research

Skills:

• Business Analytics
• Business Intelligence
• Data Quality Management
• Fraud Management
• Monitoring, Surveillance, and Testing
• Collaboration
• Data Visualization
• Oral Communications
• Problem Solving
• Written Communications
• Analytical Thinking
• Critical Thinking
• Data and Trend Analysis
• Innovative Thinking
• Research

Shift:

1st shift (United States of America)

Hours Per Week:

40

Pay Transparency details:

Pay range: $79,700.00 - $118,900.00 annualized salary, offers to be determined based on experience, education, and skill set. Discretionary incentive eligible. This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company. Benefits: This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.