Cons Prod Strat Analyst III
Phoenix, Arizona;Greensboro, North Carolina; Newark, Delaware; Charlotte, North Carolina; Fort Worth, Texas; Tampa, Florida; Jacksonville, Florida
**Job Description:**
This is a business critical role that supports Operational Reporting within the Enterprise Transaction Services and Paycheck organization. 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 financial business workflows, fundamental data structure, and varierty of data environments such as Teradata, Oracle, Hadoop and SQL Server is a plus. 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.
**Required Skills** :
Experience with systems functional analysis, technology business analysis, and basic understanding of the different technical platforms, databases, and related technologies
Proficiency in SQL (2+ years experience with T-SQL, HIVE, IMPALA, and/or PL/SQL)
Scripting and automation experience: SAS, Visual Studio, SSIS, TOAD, Excel
Experience with Enterprise Databases; MS SQL Server, Oracle, Hadoop, Teradata
Experience with Tableau is highly desired
Ability to work in a fast pace environment
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:**
High aptitude for self-motivation and self-determined project work
Data Mining Experience using SQL/SAS querying
ETL process experience using TOAD Automation, SSIS, SAS, or other data processing tools
Consumer Operations Data Mart (CODM) experience
SDP HADOOP experience
Professional experience as a data scientist / analyst / statistician is a plus
MSP experience
Financial LOB workflow knowledge
Experience with Python
Cross platform data source experience, such as Oracle, SQL Server, Hadoop, Teradata
Alteryx Designer
**Job Band:**
H5
**Shift:**
1st shift (United States of America)
**Hours Per Week:**
40
**Weekly Schedule:**
M-F 8-5
**Referral Bonus Amount:**
0
**Job Description:**
This is a business critical role that supports Operational Reporting within the Enterprise Transaction Services and Paycheck organization. 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 financial business workflows, fundamental data structure, and varierty of data environments such as Teradata, Oracle, Hadoop and SQL Server is a plus. 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.
**Required Skills** :
Experience with systems functional analysis, technology business analysis, and basic understanding of the different technical platforms, databases, and related technologies
Proficiency in SQL (2+ years experience with T-SQL, HIVE, IMPALA, and/or PL/SQL)
Scripting and automation experience: SAS, Visual Studio, SSIS, TOAD, Excel
Experience with Enterprise Databases; MS SQL Server, Oracle, Hadoop, Teradata
Experience with Tableau is highly desired
Ability to work in a fast pace environment
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:**
High aptitude for self-motivation and self-determined project work
Data Mining Experience using SQL/SAS querying
ETL process experience using TOAD Automation, SSIS, SAS, or other data processing tools
Consumer Operations Data Mart (CODM) experience
SDP HADOOP experience
Professional experience as a data scientist / analyst / statistician is a plus
MSP experience
Financial LOB workflow knowledge
Experience with Python
Cross platform data source experience, such as Oracle, SQL Server, Hadoop, Teradata
Alteryx Designer
**Shift:**
1st shift (United States of America)
**Hours Per Week:**
40
Learn more about this role
Full time
JR-22084391
Band: H5
Manages People: No
Travel: Yes, 5% of the time
Manager:
Talent Acquisition Contact:
Jim Sladicka [C]
Referral Bonus:
0
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 Americas Drug-free workplace and alcohol policy, CLICK HERE .
