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

Overview

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.
  • 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.
• Data Validation & Integrity:
  • 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.
• SQL Analysis & Data Comparison:
  • 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.
• Test Planning & Execution:
  • 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.
• Collaboration with Technology Teams:
  • 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.
• Data Migration & Remediation:
  • 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.

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

• ACBS & Loan IQ Experience:
• Proven experience with loan systems, specifically ACBS and Loan IQ, and a strong understanding of the complexities involved in loan data migration.
• SQL Expertise:
• Strong proficiency in SQL for data extraction, analysis, comparison, and validation across multiple systems, ensuring data quality and consistency.
• Business Analysis & Documentation:
• 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 w