Back to search results

Cons Prod Strat Analyst III

Simi Valley, California;

Job Description:

This is a business critical role that supports Life & Specialty Services Business Controls Reporting.  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, Micro Strategy, and/or other technology recommended BI Tools.  Knowledge of Life and Specialty Servicing businesses including SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, Consumer Mortgage Tax, Escheatment, Corporate Accounts Payable, or Procedure Management is a benefit.  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 with both SAS/SQL (ex. SAS EG, SAS Grid, SQL Server)

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

• Experience with Enterprise Databases (The W), MS SQL Server, Oracle, Hadoop, Teradata, and the Strategic Data Platform (SDP) 

• 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

• Tableau, Micro Strategy

• Consumer Operations Data Mart (CODM) experience

• HADOOP experience

• Professional experience as a data scientist / analyst / statistician is a plus, but not a requirement

• Experience with HIVE and/or Impala Driver Tools

• MSP experience

• Life & Specialty Servicing business acumen/knowledge

• Experience with Python

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 Services Business Controls Reporting.  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, Micro Strategy, and/or other technology recommended BI Tools.  Knowledge of Life and Specialty Servicing businesses including SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, Consumer Mortgage Tax, Escheatment, Corporate Accounts Payable, or Procedure Management is a benefit.  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 with both SAS/SQL (ex. SAS EG, SAS Grid, SQL Server)

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

• Experience with Enterprise Databases (The W), MS SQL Server, Oracle, Hadoop, Teradata, and the Strategic Data Platform (SDP) 

• 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

• Tableau, Micro Strategy

• Consumer Operations Data Mart (CODM) experience

• HADOOP experience

• Professional experience as a data scientist / analyst / statistician is a plus, but not a requirement

• Experience with HIVE and/or Impala Driver Tools

• MSP experience

• Life & Specialty Servicing business acumen/knowledge

• Experience with Python

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-22001389

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

James Sladicka

Referral Bonus:

0