Technical Business Analyst Loan IQ

Brains Workgroup • New York, NY

3d • Remote

About The Position

Our client, a major bank in New York City, is looking for a Technical Business Analyst with Loan IQ experience. This role is remote. This is a 6-month contract with possible extensions or an option to hire. The rate is $76 - $81 per hour on W2 DOE, with possible C2C as well. 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.

Requirements

• 5+ years of experience as a Technical Business Analyst, Data Analyst, or Systems Analyst within the banking, financial services, or commercial lending domain.
• Minimum 3+ years of hands-on technical experience with Finastra Fusion Loan IQ.
• 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).
• Strong proficiency in SQL and relational database concepts.
• Strong foundational knowledge of corporate lending, syndicated loans, agency functions, and bilateral loans.
• Excellent verbal and written communication skills, with the ability to explain complex technical data models to non-technical business stakeholders.
• Must be authorized to work for ANY employer in US - NO H1 Visa support for this role.

Nice To Haves

• Familiarity with modern data platforms (e.g., Databricks, Snowflake) is a strong plus.

Responsibilities

• Analyze and document business requirements from different downstream sources and translate them into detailed technical specifications for development teams.
• Serve as the functional and technical SME for Commercial Lending.
• 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.
• 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.
• 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.
• Collaborate with software engineers and data architects to design event-driven data flows in and out of newly designed models.
• 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.
• Maintain up-to-date functional and technical design documents, data dictionaries, and system process flows.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed