Consumer Product Strategy Analyst III - Analytics & Model Development

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

Job summary

An established industry player is seeking a talented analyst to join their dynamic Analytics and Model Development team. This role focuses on data sourcing, automation, and reporting, utilizing cutting-edge technologies like SQL, Tableau, and Alteryx. You will have the opportunity to enhance reporting processes, uncover insights from data, and collaborate with cross-functional teams to drive impactful decision-making. If you are passionate about analytics and eager to make a difference in a collaborative environment, this position offers a fantastic opportunity for growth and development.

Benefits

Industry-leading benefits

Access to paid time off

Support for employee wellness

Discretionary incentive eligibility

Qualifications

• 3+ years of SQL coding experience with various systems.
• Proficient in Tableau and PowerBI for reporting.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop executive dashboards using Tableau and PowerBI.
• Create SQL logic for data sourcing from various systems.
• Perform statistical analysis using SAS and Python.

Skills

SQL Coding

Tableau

PowerBI

Excel

Analytical Thinking

Problem Solving

Data Visualization

Communication Skills

Project Management

Data Quality Management

Education

Bachelor's degree in quantitative discipline

Tools

Alteryx

SAS

Python

Hadoop

Teradata

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.

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

US - MD - Hunt Valley - 11333 MCCORMICK RD - HUNT VALLEY II (MD5032), US - NY - Elma - 611 Jamison Rd - (NY7507), US - NY - Utica - 5701 Horatio St - 5701 Horatio Arterial (NY7501) Pay and benefits information 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.