Required Qualifications & SkillsExperience:
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.
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 & SkillsExperience:
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.
Please email your resume orUse this link to apply directly:
https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16810743
Or email:
igork@brainsworkgroup.com
Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers
Keywords: lending commercial loan iq finastra sql business analyst bank finance
Our client, a major bank in New York City, is looking for Technical Business Analyst with Loan IQ or other Commercial Lending tools experience.
This role is remote.
This is 6 months contract with possible extensions or option to hire.
** Must be authorized to work for ANY employer in US - NO H1 Visa support for this role
Rate: $76 - 81 per hour on W2 DOE, possible C2C as well.
Technical Business Analyst - Commercial Lending
We are seeking a highly skilled Technical Business Analyst 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.