girl looking into her desktop
Back to search results

Cons Prod Strat Analyst III

Chandler, Arizona;

Job Description:

Line of Business 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 SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, National Service and Solution, Unclaimed Property & Escheatment, Procedure Remediation & Data Validation is a benefit. This position requires the ability to communicate effectively, present the outcome, and work across multiple teams to support various initiatives.

Job Posting Description:

Responsible for performing more complex analysis and modeling for multiple products with the goal of maximizing profits and asset growth and minimizing risk and operating losses and/or other financial and marketing exposures. Develops complex program models to extract data and uses multiple databases to acquire statistical and financial data. Utilizes portfolio trends to propose policy/procedural changes within segmentation structure to produce optimal results. Excels at risk/reward trade off. Build relationships with external agencies. Participates in the rollout of company-wide pilot programs developed as a result of programmed models. Duties primarily include the regular use of discretion, independent judgment, the ability to communicate with multiple levels of management and the utilization of core leadership behaviors. SAS and/or MicroStrategy experience preferred; 2-5 years experience preferred.

Required Skills:

  • 2 years experience developing and producing reports

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

  • Proficiency with SQL and proven experience with complex JOIN criteria

  • Various database experience, such as ETL, Oracle, SQL Server, HADOOP, Tableau or Teradata

  • Experience with Scripting and automation including  SAS, SSIS, TOAD, Excel

  • 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 requirement

  • Strong communication skills (verbal, written and presentations)

Desired Skills:

  • High aptitude for self-motivation and self-determined project work

  • Data Mining Experience using SAS querying

  • Tableau, SSRS, Micro Strategy

  • Consumer Operations Data Mart (CODM) experience

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

  • 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:

M-F 8am-5pm

Referral Bonus Amount:

0

Job Description:

Line of Business 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 SCRA, BK, Credit Reporting, LOCRO, CAML, Deceased, National Service and Solution, Unclaimed Property & Escheatment, Procedure Remediation & Data Validation is a benefit. This position requires the ability to communicate effectively, present the outcome, and work across multiple teams to support various initiatives.

Job Posting Description:

Responsible for performing more complex analysis and modeling for multiple products with the goal of maximizing profits and asset growth and minimizing risk and operating losses and/or other financial and marketing exposures. Develops complex program models to extract data and uses multiple databases to acquire statistical and financial data. Utilizes portfolio trends to propose policy/procedural changes within segmentation structure to produce optimal results. Excels at risk/reward trade off. Build relationships with external agencies. Participates in the rollout of company-wide pilot programs developed as a result of programmed models. Duties primarily include the regular use of discretion, independent judgment, the ability to communicate with multiple levels of management and the utilization of core leadership behaviors. SAS and/or MicroStrategy experience preferred; 2-5 years experience preferred.

Required Skills:

  • 2 years experience developing and producing reports

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

  • Proficiency with SQL and proven experience with complex JOIN criteria

  • Various database experience, such as ETL, Oracle, SQL Server, HADOOP, Tableau or Teradata

  • Experience with Scripting and automation including  SAS, SSIS, TOAD, Excel

  • 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 requirement

  • Strong communication skills (verbal, written and presentations)

Desired Skills:

  • High aptitude for self-motivation and self-determined project work

  • Data Mining Experience using SAS querying

  • Tableau, SSRS, Micro Strategy

  • Consumer Operations Data Mart (CODM) experience

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

  • 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

Learn more about this role

Full time

JR-21033352

Band: H5

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Monali Shah

Referral Bonus:

0