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

Responsibilities

• 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.

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 with the business’s objectives.
• Data Migration Knowledge: 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.
• Collaboration & Communication: 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.