Senior Data Migration Analyst – AFS in Springfield, Illinois

Senior Data Migration Analyst – AFS

Remote – USA,USA

About Us

SolomonEdwardsGroup, LLC (“SolomonEdwards”) is a full-service professional services firm offering financial, operational, and technology consulting and operations support. We work with some of the world’s most prominent companies to help them envision and achieve a better future. We know that our consulting services are only as meaningful as the people and talent behind them, and we are committed to recruiting incredibly talented, committed, and collaborative individuals who can help us deliver exceptional client service. For more information, visit SolomonEdwards

Position Summary:

As a Senior Data Migration Analyst, you will play a critical role in leading and executing complex loan data migrations within banking platforms, specifically related to LoanIQ, AFS, and other ancillary system integrations. You will be responsible for data scripting, data mapping, data extraction, transformation, and validation while ensuring data integrity, compliance, and business continuity. One of your functions will be to build a progress tracker for data migration and manage the execution of all data-related aspects of the project.

This role requires a seasoned data migration specialist with at least two successful migrations involving LoanIQ and AFS, strong SQL skills, and expertise in drag-and-drop migration tools for analyzing and processing structured and unstructured data. You will be working across multiple systems, helping migrate loan data into a unified platform, and collaborating with engineering, product, operations, and compliance teams.

Essential Duties:

Data Migration Execution and Strategy:

• Lead end-to-end loan data migration projects from AFS, AFS Vision, LoanIQ, and other platforms.

• Perform data extraction, mapping, transformation, and validation to ensure accurate migration.

• Analyze structured and unstructured data sources to identify inconsistencies and data quality issues.

• Utilize SQL, ETL tools, and scripting to support data migration, ensuring compliance and accuracy.

Data Mapping and System Integration:

• Work across multiple banking systems merging into one unified platform.

• Map and analyze data formats (alphanumeric, numeric, special characters) to understand sourcing and structuring.

• Identify gaps and discrepancies in data between legacy and target systems.

• Collaborate with engineering, risk, and compliance teams to define migration rules and business logic.

Testing, Validation and Troubleshooting:

• Develop and execute data reconciliation strategies to validate successful migration.

• Conduct pre-migration and post-migration data integrity checks.

• Troubleshoot and resolve data anomalies, missing records, and inconsistencies in real time.

• Work closely with business stakeholders to validate loan terms, calculations, and servicing post-migration data.

Project Management and Agile Transformation:

• Transition from Waterfall migration methodology to SCRUM/Agile for future projects.

• Understand and track BNY’s banking processes and maintain a detailed migration tracker.

• Work cross-functionally with Product, Data Engineering, and Compliance teams to support data-related initiatives.

• Conduct stakeholder meetings, reporting, and documentation to track progress and ensure risk mitigation.

Qualifications:

• Minimum 7 years in data migration, data engineering, or loan servicing within the banking sector.

• Minimum 2 successful migrations involving LoanIQ and AFS in a financial institution.

• Hands-on experience with multiple system consolidations in a banking environment.

• SQL: ability to query, manipulate, and validate data.

• ETL Tools: experience with drag-and-drop data migration platforms (e.g., Informatica, Talend, SSIS).

• Data Mapping and Analysis: strong ability to analyze, cut, and transform data from disparate sources.

• Banking Systems Knowledge: LoanIQ, AFS, and related banking platforms.

• Understanding of loan data structures, servicing processes, and financial risk factors.

Skills and Job-Specific Competencies:

• Strong problem-solving abilities with a data-driven approach.

• Ability to jump in quickly, assess data environments, and deliver results.

• Experience in Waterfall methodologies with a transition into Agile/SCRUM.

• Excellent communication skills – ability to collaborate with engineers, business leaders, and compliance teams.

Travel Requirements: No travel will be required unless at the client’s discretion.

Physical Requirements: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be provided to qualified applicants or candidates with disabilities upon request to enable them to perform essential functions. This role may require mobility to attend in-person meetings, sitting or standing for extended periods, and the use of telephone, computer, or other electronic communication devices.

Salary Range: SolomonEdwards values your unique and individual experience and background. As such, we take a comprehensive approach when determining compensation for our roles. The compensation for this specific role is based on a wide range of factors, including but not limited to education, licensure and certifications, location, experience, and training. A reasonable estimate for the current hourly range for this role is $100 – 115.

Benefits: We are committed to providing health and financial stability by offering a comprehensive suite of benefits. Benefits include access to top-tier employers and job opportunities, health insurance, sick leave, and 401(k).

Inclusion and Diversity Statement: SolomonEdwards is an Equal Opportunity/Affirmative Action employer. We firmly believe in fostering an inclusive and diverse workplace environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, gender identity, sexual orientation, veteran status, or any other characteristic protected by applicable laws. All employees, including managers and supervisors, are responsible for upholding our EEO and diversity principles. Discrimination or harassment of any kind will not be tolerated.

We value the contribution and wisdom of the team. At SolomonEdwards, we have built a vibrant and inclusive community. Our team members are curious, committed, and diverse. In keeping with our mission to build value through people, we cultivate a culture where differences are celebrated, and all members are treated fairly and equitably. Employees, business partners, and our extended stakeholder family are empowered to share their experiences, ideas, and perspectives and to be their whole selves.

Privacy: We adhere to the California Consumer Privacy Act (CCPA). Your privacy is important to us, and we never sell your data to third parties. Personal information is only collected to match applicants with job opportunities. Copy/paste this URL to learn more about your rights: SolomonEdwards’ Privacy Policy.

Our Recruiter Promise: Our talent acquisition team prioritizes integrity, professionalism, and transparency in every interaction. When you engage with SolomonEdwards, you can trust a respectful, secure experience from verified contacts. Copy/paste this URL to learn more about how we protect your candidate experience: Recruiter Promise.

Job Ref: 141925