LoanIQ Platform Data Analyst

We are currently hiring a position role within. Role will require to work closely with Transaction Managers (Front Office), External Clients, KYC , Data services and the Operations team to ensure the controlled on-boarding of all new transactions from the pre-closing/funding stages through certain ongoing portfolio administration tasks. The individual will have responsibility for the completion of many key portfolio and transaction tasks and for reporting of aged items and ownership of resolution. As such they are required to be detail orientated, organized and able to maintain accurate and complete records at all times. The ideal candidate will be a proactive and meticulous critical thinker. Must possess attributes of sound judgement, tact, and diplomacy. Strong analytical skills with an ability to identify issues. Ability to act independently (decision making) and be a team player as well.

Responsibilities:

LoanIQ Expertise:

• Exhibit a strong understanding of Loan IQ, including complex syndicated lending and Loan Operations/Servicing.

• Provide insights and recommendations for optimizing LoanIQ processes and data management.

• Leverage LoanIQ for data extraction, analysis, and reporting.

• Experience in data migration to Loan IQ from other systems.

• Familiarity with Loan IQ API and SDK model is a plus.

Data Analysis and Management:

• Utilize SQL and Python to extract, manipulate, and analyse data (ETL) from various sources.

• Demonstrate strong knowledge of database schema design, data types, and SQL best practices.

• Perform data comparisons between different platforms to ensure consistency and accuracy.

• Conduct automatic checks on data sets using SQL and/or Python to identify and rectify discrepancies.

Data Visualization/Reporting:

• Utilize Loan IQ Datanet module (IBM Cognos Analytics based) to create reports and data summaries.

• Create and maintain dashboards and reports using PowerBI to present data insights to stakeholders.

Process Improvement and Automation:

• Identify opportunities for process improvements and automation within LoanIQ and other data systems.

• Implement automation solutions to streamline data workflows and enhance efficiency.

Experience:

• Proven experience in data analysis, data comparison, and quality checks using SQL and Python.

• Knowledge of agency, non-agency, bilateral, and structured lending.

• Experience in providing insights and recommendations for process improvements and automation.

• Prior knowledge of Cognos IBM Analytics is a plus.

• Familiarity with PowerBI or other data visualization tools.

Qualifications

• Bachelor’s degree in computer science, Information Technology, Finance, or a related field.

• Minimum of 5 years of experience in a similar role.

• Strong analytical and problem-solving skills.

• Excellent communication and interpersonal skills.

• Ability to work independently and as part of a team.

Why Join Us:

• Opportunity to work with a dynamic and innovative team.

• Professional development and career growth opportunities.

• Collaborative and inclusive work environment.

About Kroll-

In a world of disruption and increasingly complex business challenges, our professionals bring truth into focus with the Kroll Lens. Our sharp analytical skills, paired with the latest technology, allow us to give our clients clarity—not just answers—in all areas of business.

We embrace diverse backgrounds and global perspectives, and we cultivate diversity by respecting, including, and valuing one another. As part of One team, One Kroll, you’ll contribute to a supportive and collaborative work environment that empowers you to excel.

Kroll Agency and Trustee Services provides conflict-free, flexible, and highly efficient administrative and trustee services to the global loan and bond markets. As a leading independent service provider, we specialize in the administration of privately placed notes, restructuring situations, syndicated, bi-lateral and private credit transactions. Our team of industry leading experts coupled with our high touch service, speed of execution and 24/7 responsiveness sets us apart from other providers. To learn more, please visit https://www.kroll.com/en/services/agency-and-trustee-services

Kroll is committed to equal opportunity and diversity, and recruits people based on merit.

In order to be considered for a position, you must formally apply via careers.kroll.com.

#LI-IK1