Business Analyst - Financial Spreading

Business Analyst - Financial Spreading Software

Responsibilities and Duties

• Elicit, analyze, and document detailed business requirements for financial spreading software from various stakeholders, including lenders, credit analysts, and underwriters.
• Translate business needs into functional and non-functional requirements, user stories, use cases, and process flows for the development team6.
• Collaborate with the development team to ensure the software design and functionality align with the documented requirements.
• Ensure the software design and functionality adhere to relevant regulations and industry standards in financial spreading and credit risk assessment.
• Create comprehensive user acceptance testing (UAT) plans and test cases to validate the software against the defined requirements.
• Participate in UAT sessions, document defects, and work with the development team to resolve issues.
• Contribute to the development of user manuals, training materials, and online help documentation to support user adoption and understanding of the software.
• Support the product management team in defining the product roadmap and prioritizing features based on market needs and client feedback.
• Support the implementation and adoption of the software by users, including providing training and facilitating change management activities.
• Incorporate feedback from stakeholders, such as product managers and lead developers, to refine and improve the software requirements and design.

Required Skills and Experience

• Proven experience as a Business Analyst in the financial services industry, with a focus on lending and credit risk management.
• Strong understanding of financial spreading methodologies, including the analysis of financial statements, tax returns, and cash flow projections .
• Familiarity with credit risk assessment tools and techniques, such as financial ratios, credit scoring models, and stress testing .
• Experience with data analysis and financial modeling tools, such as Excel, SQL , and statistical software packages.
• Familiarity with leading financial spreading software solutions and platforms in the market (e.g., Moodys CreditLens, Sageworks, nCino, Baker Hill NextGen) .
• Strong analytical and problem-solving skills, with the ability to identify and articulate business needs and translate them into software requirements .
• Proficiency in using requirement management tools and techniques, such as JIRA, Confluence, and Agile methodologies .

Educational Qualifications

• Bachelor’s degree in business administration, Finance, Economics, or a related field.
• Master’s degree in business administration (MBA) or a related field is preferred .
• Relevant certifications, such as Certified Business Analysis Professional (CBAP) or Certified associate in project management (CAPM), are a plus .

Understanding of Credit Risk Assessment and Mitigation

The Business Analyst needs a strong understanding of credit risk assessment and mitigation strategies:

• Creditworthiness Assessment:

• Ability to analyze borrower financial statements, including balance sheets, income statements, and cash flow statements .
• Understanding of key financial ratios and metrics used to assess creditworthiness .

• Risk Mitigation:

• Familiarity with various credit risk mitigation techniques, such as loan covenants, collateral requirements, and guarantees .

Experience with Data Analysis and Financial Modeling

The Business Analyst should have a strong foundation in data analysis and financial modeling:

• Proficiency in using spreadsheet software, such as Microsoft Excel, for financial analysis and modeling.
• Experience with database query languages, such as SQL, to extract and analyze data from financial systems .