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

Business Analysts / Data Migration Specialists

Treliant is an essential consulting firm serving banks, mortgage originators and servicers, fintechs, and other companies providing financial services globally. We are led by practitioners from the industry and the regulatory community who bring deep domain knowledge to help our clients drive business change and address the most pressing compliance, regulatory, and operational challenges. We provide data-driven, technology-enabled consulting, implementation, staffing, and managed services solutions to the regulatory compliance, risk, credit, financial crimes, and capital markets functions of our clients. Founded in 2005, Treliant is headquartered in Washington, DC, with offices across the United States, Europe, and Asia.

Treliant is committed to fostering a diverse, equitable and inclusive environment that values and embraces all races, religions, ages, abilities, genders, sexual orientations, ethnicities, languages, nationalities, political parties, socioeconomic groups and other characteristics that inform an individual's worldview, experiences and system of beliefs ("the principles"). We believe in championing every voice and ensuring everyone's full potential.

We are currently looking for Business Analysts / Data Migration Specialists to join a multi-person team on a hybrid, long-term engagement in the NYC metro area supporting our investment banking client's migration from ACBS to Loan IQ.

Responsibilities

While the scope of each project may be different, your duties & responsibilities may include :

• Business Analysis & Requirements Clarification :

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

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

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

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

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

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

We are committed to being an Equal Opportunity Employer and want to build a diverse, inclusive and authentic workplace. If you are interested in this role but don't tick all the boxes, we encourage you to apply as you may be the perfect candidate for this or other roles.

Qualifications

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.

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.

Benefits

Primary Location : Hybrid / NYC metro area

Primary Location Salary Range : $60 / hr - $90 / hr

Treliant offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefit package that reflects our commitment to creating a diverse and supportive workplace. In addition to a competitive base salary, candidate is eligible for incentive pay as well as a full range of health benefits, vacation plan, and 401k plan.

If you want to be part of a dynamic team of professionals, we invite you to join the team at Treliant. We invest in people, and challenge you to advance your career while achieving your aspirations and goals. Here at Treliant, we pride ourselves on our collaborative team culture, where we embrace diversity of thought and innovation. If you strive for excellence and seek an inclusive environment apply on line treliant.com and follow us on LinkedIn.

Right to Work

Treliant is not in the position to provide sponsorship for this current position and so applicants must be able to work in the United States without requiring sponsorship.

Please note, Treliant receives a high volume of applications for all roles. While we will endeavor to respond to all applicants, this is not always possible. Should you not receive a response to your application within 2 weeks, it is likely that you will have been unsuccessful on this occasion. However, we would like to retain your details on our systems and may contact you should another potentially suitable vacancy arise.

Treliant LLC is an Equal Opportunity Employer and does not discriminate on the basis of race, color, national origin, sex, sexual orientation, genetic information, religion, age, disability, or military status in employment or provision of services. When contacted for an interview, an applicant who requires special accommodations due to a disability should notify the office so that proper arrangements can be made.