Cons Prod Strat Analyst III

Bank of America
Published
November 17, 2021
Location
Jacksonville, FL
Category
Job Type

Description

Job Description:

This is a business critical role that supports Life & Specialty Servicing Business Controls Reporting.  Responsible for developing control reporting utilizing multiple source system of records and formation in different 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, research legacy reports for transformation, analyze report requirements, and develop based on reporting needs using Tableau and/or other technology recommended BI Tools.  Knowledge of Life and Specialty Servicing businesses including , Process Quality, Procedure Remediation & Data Validation, SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, National Service & Solution, and Unclaimed Property & Escheatment. This position requires the ability to communicate effectively, present the outcome, and work across multiple teams to support various initiatives.

Required Skills: •

Experience with systems functional analysis, technology business analysis, and basic understanding of the different technical platforms, databases, and related technologies

• Proficiency with both SAS/SQL (ex. SAS EG, SAS Grid, SQL Server) and proven experience with complex JOIN criteria

• Scripting and automation experience:  SAS, SSIS, TOAD, Excel

• Experience in BI Tools (Tableau and SSRS)  • Experience with Enterprise Databases (The W), Teradata, and the Strategic Data Platform (SDP) 

• Experience with data loading and processing from various data sources to create staging buffer and import the output into data platform

• Ability to translate high level business requirements into technical data requirements

• Strong communication skills (verbal, written and presentations) • 2 years experience developing and producing reporting

Desired Skills:

• High aptitude for self-motivation and self-determined project work • Knowledge of IQs AIT

• Data Mining Experience using SQL/SAS querying

• Tableau, SSRS, Microstrategy

• Consumer Operations Data Mart (CODM) experience

• Various database experience, such as Oracle, SQL Server, HADOOP and Teradata

• Professional experience as a data scientist / analyst / statistician is a plus • Experience with HIVE and/or Impala Driver Tools

• Life & Specialty Servicing business acumen/knowledge

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

-->

Job Description:

This is a business critical role that supports Life & Specialty Servicing Business Controls Reporting.  Responsible for developing control reporting utilizing multiple source system of records and formation in different 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, research legacy reports for transformation, analyze report requirements, and develop based on reporting needs using Tableau and/or other technology recommended BI Tools.  Knowledge of Life and Specialty Servicing businesses including , Process Quality, Procedure Remediation & Data Validation, SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, National Service & Solution, and Unclaimed Property & Escheatment. This position requires the ability to communicate effectively, present the outcome, and work across multiple teams to support various initiatives.

Required Skills: •

Experience with systems functional analysis, technology business analysis, and basic understanding of the different technical platforms, databases, and related technologies

• Proficiency with both SAS/SQL (ex. SAS EG, SAS Grid, SQL Server) and proven experience with complex JOIN criteria

• Scripting and automation experience:  SAS, SSIS, TOAD, Excel

• Experience in BI Tools (Tableau and SSRS)  • Experience with Enterprise Databases (The W), Teradata, and the Strategic Data Platform (SDP) 

• Experience with data loading and processing from various data sources to create staging buffer and import the output into data platform

• Ability to translate high level business requirements into technical data requirements

• Strong communication skills (verbal, written and presentations) • 2 years experience developing and producing reporting

Desired Skills:

• High aptitude for self-motivation and self-determined project work • Knowledge of IQs AIT

• Data Mining Experience using SQL/SAS querying

• Tableau, SSRS, Microstrategy

• Consumer Operations Data Mart (CODM) experience

• Various database experience, such as Oracle, SQL Server, HADOOP and Teradata

• Professional experience as a data scientist / analyst / statistician is a plus • Experience with HIVE and/or Impala Driver Tools

• Life & Specialty Servicing business acumen/knowledge

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:
This is a business critical role that supports Life & Specialty Servicing Business Controls Reporting.  Responsible for developing control reporting utilizing multiple source system of records and formation in different 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, research legacy reports for transformation, analyze report requirements, and develop based on reporting needs using Tableau and/or other technology recommended BI Tools.  Knowledge of Life and Specialty Servicing businesses including , Process Quality, Procedure Remediation & Data Validation, SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, National Service & Solution, and Unclaimed Property & Escheatment. This position requires the ability to communicate effectively, present the outcome, and work across multiple teams to support various initiatives.

Required Skills: •

Experience with systems functional analysis, technology business analysis, and basic understanding of the different technical platforms, databases, and related technologies

• Proficiency with both SAS/SQL (ex. SAS EG, SAS Grid, SQL Server) and proven experience with complex JOIN criteria

• Scripting and automation experience:  SAS, SSIS, TOAD, Excel

• Experience in BI Tools (Tableau and SSRS)  • Experience with Enterprise Databases (The W), Teradata, and the Strategic Data Platform (SDP) 

• Experience with data loading and processing from various data sources to create staging buffer and import the output into data platform

• Ability to translate high level business requirements into technical data requirements

• Strong communication skills (verbal, written and presentations) • 2 years experience developing and producing reporting

Desired Skills:

• High aptitude for self-motivation and self-determined project work • Knowledge of IQs AIT

• Data Mining Experience using SQL/SAS querying

• Tableau, SSRS, Microstrategy

• Consumer Operations Data Mart (CODM) experience

• Various database experience, such as Oracle, SQL Server, HADOOP and Teradata

• Professional experience as a data scientist / analyst / statistician is a plus • Experience with HIVE and/or Impala Driver Tools

• Life & Specialty Servicing business acumen/knowledge
Shift:

1st shift (United States of America)

Hours Per Week: 

40

Apply
Drop files here browse files ...

Related Jobs

December 2, 2021
Security Engineer   Jacksonville, FL new
December 2, 2021
December 2, 2021
Applied Data Scientist   Atlanta, GA new
December 2, 2021
Applied Data Scientist   Atlanta, GA new
December 2, 2021

Author: