girl looking into her desktop
Back to search results

Ops Project Consultant - Business Systems Analysis (SQL, Decision Engine, Workflow)

Westlake Village, California;

Job Description:

This position fills a critical role in supporting Loan Modification production systems.  The role involves conducting root-cause analyses of potential production defects, determining the scope of the issue, devising rules-based controls as stop-gap, then collaborating with the business units and development teams for creative solutions.

System components include but are not limited to: data aggregation, business rules decision engine, finance math functions, workflow and case management.

Responsibilities

  • Conduct gap assessments between current loan modification processes and new laws, rules and regulations
  • Perform defect root-cause analysis of complex issues, determine impact using advanced querying skills then devise short-term and long-term solutions
  • Develop queries to validate implemented technology solutions
  • Develop ad hoc reporting
  • Communicate statuses, escalate and articulate issues to stakeholders
  • Analyze historical issues and defects, detect patterns then promote thematic analysis for strategic solutions
  • Understand business processes, solicit and generate own enhancement ideas, document for and articulate to technology partners
  • Provide coaching and mentoring for other employees but does not directly manage others

Required Skills

  • Demonstrable experience with handling large data set with the ability to transform information, conceptualizing the impact, then presenting concisely with sound business conclusions and recommendations.
  • Medium to advanced proficiency in SQL - including ability to write queries
  • Ability to perform data reporting from Excel
  • Prior working experience in Software Quality Assurance Testing - UAT
  • Have a solid understanding of development and deployment standards
  • Should have the ability to work in a complex environment that involves articulate discussions with business, legal, risk and technology teams
  • Must be accountable, highly motivated and able to work independently

Desired skills

  • Believes in value of diversity so we can reflect, connect and meet the diverse needs of our clients and employees
  • Bachelor's degree, preferably in a quantitative discipline such as mathematics, statistics, operations research, engineering, computer science, finance or business
  • MBA or MS in Engineering
  • Prior working experience in Production Support
  • Pega Business Architect certified or equivalent prior working experience
  • SAFe® Product Owner / SAFe® Product Manager certified or equivalent prior working experience
  • Knowledge of Mortgage Default Servicing laws, rules and regulations
  • Knowledge of MSP
  • Knowledge of Fannie Mae, Freddie Mac, FHA, USDA, VA loan modification programs
  • Knowledge of Home Equity products and loan modification programs
  • Prior working experience in business rules configuration

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 position fills a critical role in supporting Loan Modification production systems.  The role involves conducting root-cause analyses of potential production defects, determining the scope of the issue, devising rules-based controls as stop-gap, then collaborating with the business units and development teams for creative solutions.

System components include but are not limited to: data aggregation, business rules decision engine, finance math functions, workflow and case management.

Responsibilities

  • Conduct gap assessments between current loan modification processes and new laws, rules and regulations
  • Perform defect root-cause analysis of complex issues, determine impact using advanced querying skills then devise short-term and long-term solutions
  • Develop queries to validate implemented technology solutions
  • Develop ad hoc reporting
  • Communicate statuses, escalate and articulate issues to stakeholders
  • Analyze historical issues and defects, detect patterns then promote thematic analysis for strategic solutions
  • Understand business processes, solicit and generate own enhancement ideas, document for and articulate to technology partners
  • Provide coaching and mentoring for other employees but does not directly manage others

Required Skills

  • Demonstrable experience with handling large data set with the ability to transform information, conceptualizing the impact, then presenting concisely with sound business conclusions and recommendations.
  • Medium to advanced proficiency in SQL - including ability to write queries
  • Ability to perform data reporting from Excel
  • Prior working experience in Software Quality Assurance Testing - UAT
  • Have a solid understanding of development and deployment standards
  • Should have the ability to work in a complex environment that involves articulate discussions with business, legal, risk and technology teams
  • Must be accountable, highly motivated and able to work independently

Desired skills

  • Believes in value of diversity so we can reflect, connect and meet the diverse needs of our clients and employees
  • Bachelor's degree, preferably in a quantitative discipline such as mathematics, statistics, operations research, engineering, computer science, finance or business
  • MBA or MS in Engineering
  • Prior working experience in Production Support
  • Pega Business Architect certified or equivalent prior working experience
  • SAFe® Product Owner / SAFe® Product Manager certified or equivalent prior working experience
  • Knowledge of Mortgage Default Servicing laws, rules and regulations
  • Knowledge of MSP
  • Knowledge of Fannie Mae, Freddie Mac, FHA, USDA, VA loan modification programs
  • Knowledge of Home Equity products and loan modification programs
  • Prior working experience in business rules configuration

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21065105

Band: H5

Manages People: No

Travel: Yes, 10% of the time

Manager:

Talent Acquisition Contact:

Kerry Lucas

Referral Bonus:

0