Apply on Employer Site

Treliant (Acquired by Huron - 2025) · 9 hours ago

Business Analyst/Data Migration Specialist (ACBS to Loan IQ)

New York, NY

Full-time

Hybrid

Mid Level

$60/hr - $90/hr

Treliant is a consulting firm that serves financial services companies globally. They are seeking Business Analysts/Data Migration Specialists to support the migration of data from ACBS to Loan IQ for an investment banking client, involving business analysis, data validation, SQL analysis, and collaboration with technology teams.

Management Consulting

No H1B

Responsibilities

Conduct detailed business analysis to define business requirements and ensure alignment with the target Loan IQ system

Collaborate closely with business stakeholders to confirm business logic, use cases, and field mappings between ACBS and Loan IQ

Document business requirements, functional specifications, and field definitions, ensuring consistency with migration needs

Validate the current behavior of ACBS data to ensure consistency and completeness as per the migration requirements

Define and implement data integrity checks, including automated reconciliation, to guarantee the accuracy and completeness of migrated data to Loan IQ

Perform validation of data sources, ensuring they meet predefined migration standards for seamless transfer

Execute SQL queries to extract and compare datasets from ACBS and Loan IQ, identifying discrepancies, gaps, and data quality issues

Provide insights into the integrity and quality of the data, helping define the migration strategy and addressing issues promptly

Work with business and technology teams to develop test plans, test cases, and migration plans for system testing and UAT (User Acceptance Testing)

Support dress rehearsals and other validation processes, ensuring that all test cases are properly executed, and results are documented

Collaborate closely with technology teams to implement data integrity checks and resolve any technical issues related to the migration

Support the migration of loan and risk data from ACBS to Loan IQ and ensure its successful migration to Snowflake, following up with troubleshooting and remediation as needed

Lead the efforts to ensure that all in-scope loan data is accurately migrated from ACBS to Loan IQ, then to Snowflake

Resolve any data-related issues during the migration process, working closely with both business and technology teams to ensure smooth progress

Qualification

ACBS & Loan IQ ExperienceSQL ExpertiseData Migration KnowledgeBusiness Analysis & DocumentationCollaboration & Communication

Required

Proven experience with loan systems, specifically ACBS and Loan IQ, and a strong understanding of the complexities involved in loan data migration

Strong proficiency in SQL for data extraction, analysis, comparison, and validation across multiple systems, ensuring data quality and consistency

Ability to clearly define business requirements and document functional specifications related to the data migration project

Strong attention to detail to ensure data integrity and alignment with the business's objectives

Experience migrating data from legacy systems (such as ACBS) to newer platforms like Loan IQ, as well as cloud environments such as Snowflake, is highly desirable

Excellent communication skills to collaborate effectively with cross-functional teams, including business stakeholders, technology teams, and external partners

Ability to work in a dynamic environment, handle multiple stakeholders, and address issues proactively

Benefits

Competitive compensation

Flexible benefit package

Full range of health benefits

Vacation plan

401k plan

Company

Treliant (Acquired by Huron - 2025)

Together, Huron and Treliant combine deep financial services expertise and technology with digital, data, advisory, managed services, and staffing solutions to support client needs across functions—including banking, financial crimes, fraud, risk, compliance, credit, M&A, capital markets, wealth management, finance, legal, technology, and audit—helping organizations transform, optimize, and modernize their programs while driving efficiency and effectiveness.

Founded in 2005