What are the responsibilities and job description for the Commercial Lending Business Analyst position at EDPSI?
Job Title: Technical Business Analyst Commercial Lending Consultant for NYC based international bank
Work location: midtown NYC, mostly remote
About the Role
We are seeking a highly skilled Technical Business Analyst for our direct client with deep subject matter expertise in commercial and syndicated lending.
In this role, you will act as the critical bridge between business stakeholders and our technical engineering teams. You will be responsible for translating complex lending requirements into technical specifications, mapping data architectures, and ensuring the successful delivery of new models and downstream integrations.
Key Responsibilities:
- Analyze, and document business requirements from different downstream and translating them into detailed technical specifications for development teams.
- Serve as the functional and technical SME for Commercial Lending. Must demonstrate deep understanding of the lifecycle and technical architecture of:
- Deal and Facility setup
- Drawdowns / Outstandings
- Payments, Fees, and Pricing
- Customer/Borrower profiles and Syndication
- Data Modeling & Mapping: Leverage deep knowledge of the Loan IQ Data Model to map source-to-target data requirements. Design data extraction rules for data warehousing, reporting, and integration with downstream banking systems.
- Database Querying & Analysis: Write and execute complex SQL queries (across Oracle, Databricks, Snowflake etc.) against the Loan IQ database to troubleshoot issues, validate data migrations, and verify system behavior.
- System Integration: Collaborate with software engineers and data architects to design event-driven data flows in and out of newly designed modals.
- Testing & Validation: Develop comprehensive functional and technical test cases, coordinate SIT (System Integration Testing) and UAT (User Acceptance Testing), and validate that technical deliveries meet the defined business objectives.
- Documentation: Maintain up-to-date functional and technical design documents, data dictionaries, and system process flows.
Required Qualifications & Skills
- Experience: 5 years of experience as a Technical Business Analyst, Data Analyst, or Systems Analyst within the banking, financial services, or commercial lending domain.
- Loan IQ Expertise: Minimum 3 years of hands-on technical experience with Finastra Fusion Loan IQ.
- Data Model Proficiency: Proven, demonstrable experience navigating and querying the Loan IQ underlying relational database. You must know how the core tables connect (e.g., how a Deal relates to a Facility, and how a Payment impacts outstanding balances at the table level).
- Technical Acumen: Strong proficiency in SQL and relational database concepts. Familiarity with modern data platforms (e.g., Databricks, Snowflake) is a strong plus.
- Lending Knowledge: Strong foundational knowledge of corporate lending, syndicated loans, agency functions, and bilateral loans.
- Communication: Excellent verbal and written communication skills, with the ability to explain complex technical data models to non-technical business stakeholders.
Education Requirement: Undergraduate degree top 50 universities preferred.