Address
Form of work Job title: Business Support Analyst
Location: Trenton, NJ. Note: Hybrid Role - 3 Days onsite, 2 days remote.
Duration: 3 months
Job description
Single Family Division Business Support Analyst
Point person to IT Division; DB Management; Front-end system testing; create reports using report generator; ILRS; perform systems analyses.
3 + yrs experience doing user acceptance testing
3+ yrs experience in building and maintaining configuration of business rules in rules-based engine
3+ yrs experience using MS Excel, visual basic, MS Access and/or SQL for reporting
Mortgage or housing experience preferred
4yr college degree or 5 yrs of related work experience
Under supervision, Assist Division Director with assessing and implementing SF Division business systems priorities; participate in Steering Committee meetings as needed; serve as the SF day to day point-person and liaison to the IT Division with respect to all aspects of SF business systems and programming requests and to the Marketing Division for website updates; assist the Director as a point-person in all SF system user planning, SF staff user training, and user acceptance testing participation for new and modified systems applications; perform as technical liaison to SF staff to provide daily and ongoing support to system users as required; respond to Divisional requests for assistance or program analysis; lead user data conversion and on-going data validity, data mapping and data clean-up efforts; create, distribute and maintain reports; ensure required IRS reporting forms are current; create technical tools for Single Family to increase job efficiency gains, using MS Access, MS Excel Macros, other third-party efficiency tools; build reporting database in MS Access for Servicing REOs; including but not limited to, entry form, ability to update records and reporting. Inputs from MITAS and Cenlar must be uploaded and incorporated into reporting; create and maintain loan collateral and securitization database using MS Access, including entry form, ability to update records, reporting; inputs from MITAS will need to be uploaded and incorporated into reporting; create edit reporting in MS Access to find data inconsistencies and policy violations. Perform related duties as required.
JOB RESPONSIBILITIES
1. Assist Division Director with assessing and implementing SF Division business systems priorities. Participate in Steering Committee meetings as needed.
2. Serve as the SF day to day point-person and liaison to the IT Division with respect to all aspects of SF business systems and programming requests and to the Marketing Division for website updates.
3. Assist the Director as a point-person in all SF system user planning, SF staff user training, and user acceptance testing participation for new and modified systems applications.
4. Perform as technical liaison to SF staff to provide daily and ongoing support to system users as required. Respond to Divisional requests for assistance or program analysis.
5. Lead user data conversion and on-going data validity, data mapping and data clean-up efforts.
6. Create, distribute and maintain reports. Ensure required IRS reporting forms are current. Generate periodic and special reports for the Director, SF users, and Executive Staff as requested.
7. Respond to questions and trouble-shoot Mitas and other applications for participating lenders/servicers.
8. Provide continual routine user support with respect to Single Family applications.
9. Work with SF and IT staff and consultants to prepare business requirements for system functions, features and data capture, reporting and management.
10 Assist Business Development team with training of participating lender and other appropriate parties in the SF Internet systems.
11. Attend systems training sessions when offered by the Agency, Mitas or other parties.
12. Create technical tools for Single Family to increase job efficiency gains, using MS Access, MS Excel Macros, other third-party efficiency tools.
13. Build reporting database in MS Access for Servicing REOs; including but not limited to, entry form, ability to update records and reporting. Inputs from MITAS and Cenlar must be uploaded and incorporate into reporting. Create and maintain loan collateral and securitization database using MS Access, including entry form, ability to update records, reporting; inputs from MITAS will need to be uploaded and incorporated into reporting.
14. Create edit reporting in MS Access to find data inconsistencies and policy violations. Create and maintain tool to record user validation of these edit reports.
15. Perform special projects and related duties as assigned by the Division Director.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES
- Extensive knowledge of Mortgage Industry and Residential Lending Products.
- Knowledge of Mortgage Investor Guides and industry standards.
- Extensive knowledge in MS Access and MS Excel
- Extensive knowledge in SQL reporting and relational database modeling
- Experienced in building and maintaining configuration of business rules in rules-based engine
- Ability to analyze information and make appropriate recommendations.
- Ability to prepare accurate, concise and informative reports.
- Ability to assist in training SF system users on how-to-processes involved with application systems.
- Ability to document and escalate software problems and to recommend solutions.
- Ability to communicate effectively orally, in writing, and to listen actively.
- Ability to plan, organize and accomplish multiple assignments simultaneously.
- Ability to work independently with minimum supervision.
- Ability to maintain a positive work atmosphere in an appropriate manner of behavior that ensures cooperation and effective communication with customers, clients, peers and management.
Location: Trenton, NJ. Note: Hybrid Role - 3 Days onsite, 2 days remote.
Duration: 3 months
Job description
Single Family Division Business Support Analyst
Point person to IT Division; DB Management; Front-end system testing; create reports using report generator; ILRS; perform systems analyses.
3 + yrs experience doing user acceptance testing
3+ yrs experience in building and maintaining configuration of business rules in rules-based engine
3+ yrs experience using MS Excel, visual basic, MS Access and/or SQL for reporting
Mortgage or housing experience preferred
4yr college degree or 5 yrs of related work experience
Under supervision, Assist Division Director with assessing and implementing SF Division business systems priorities; participate in Steering Committee meetings as needed; serve as the SF day to day point-person and liaison to the IT Division with respect to all aspects of SF business systems and programming requests and to the Marketing Division for website updates; assist the Director as a point-person in all SF system user planning, SF staff user training, and user acceptance testing participation for new and modified systems applications; perform as technical liaison to SF staff to provide daily and ongoing support to system users as required; respond to Divisional requests for assistance or program analysis; lead user data conversion and on-going data validity, data mapping and data clean-up efforts; create, distribute and maintain reports; ensure required IRS reporting forms are current; create technical tools for Single Family to increase job efficiency gains, using MS Access, MS Excel Macros, other third-party efficiency tools; build reporting database in MS Access for Servicing REOs; including but not limited to, entry form, ability to update records and reporting. Inputs from MITAS and Cenlar must be uploaded and incorporated into reporting; create and maintain loan collateral and securitization database using MS Access, including entry form, ability to update records, reporting; inputs from MITAS will need to be uploaded and incorporated into reporting; create edit reporting in MS Access to find data inconsistencies and policy violations. Perform related duties as required.
JOB RESPONSIBILITIES
1. Assist Division Director with assessing and implementing SF Division business systems priorities. Participate in Steering Committee meetings as needed.
2. Serve as the SF day to day point-person and liaison to the IT Division with respect to all aspects of SF business systems and programming requests and to the Marketing Division for website updates.
3. Assist the Director as a point-person in all SF system user planning, SF staff user training, and user acceptance testing participation for new and modified systems applications.
4. Perform as technical liaison to SF staff to provide daily and ongoing support to system users as required. Respond to Divisional requests for assistance or program analysis.
5. Lead user data conversion and on-going data validity, data mapping and data clean-up efforts.
6. Create, distribute and maintain reports. Ensure required IRS reporting forms are current. Generate periodic and special reports for the Director, SF users, and Executive Staff as requested.
7. Respond to questions and trouble-shoot Mitas and other applications for participating lenders/servicers.
8. Provide continual routine user support with respect to Single Family applications.
9. Work with SF and IT staff and consultants to prepare business requirements for system functions, features and data capture, reporting and management.
10 Assist Business Development team with training of participating lender and other appropriate parties in the SF Internet systems.
11. Attend systems training sessions when offered by the Agency, Mitas or other parties.
12. Create technical tools for Single Family to increase job efficiency gains, using MS Access, MS Excel Macros, other third-party efficiency tools.
13. Build reporting database in MS Access for Servicing REOs; including but not limited to, entry form, ability to update records and reporting. Inputs from MITAS and Cenlar must be uploaded and incorporate into reporting. Create and maintain loan collateral and securitization database using MS Access, including entry form, ability to update records, reporting; inputs from MITAS will need to be uploaded and incorporated into reporting.
14. Create edit reporting in MS Access to find data inconsistencies and policy violations. Create and maintain tool to record user validation of these edit reports.
15. Perform special projects and related duties as assigned by the Division Director.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES
- Extensive knowledge of Mortgage Industry and Residential Lending Products.
- Knowledge of Mortgage Investor Guides and industry standards.
- Extensive knowledge in MS Access and MS Excel
- Extensive knowledge in SQL reporting and relational database modeling
- Experienced in building and maintaining configuration of business rules in rules-based engine
- Ability to analyze information and make appropriate recommendations.
- Ability to prepare accurate, concise and informative reports.
- Ability to assist in training SF system users on how-to-processes involved with application systems.
- Ability to document and escalate software problems and to recommend solutions.
- Ability to communicate effectively orally, in writing, and to listen actively.
- Ability to plan, organize and accomplish multiple assignments simultaneously.
- Ability to work independently with minimum supervision.
- Ability to maintain a positive work atmosphere in an appropriate manner of behavior that ensures cooperation and effective communication with customers, clients, peers and management.
