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

About the position 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 • 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. Requirements • 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. • 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. Nice-to-haves • 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. Benefits • 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. Apply tot his job