Loan Conversion Specialist

This is a technical data-focused role rather than a software engineering or traditional project management position. The ideal candidate will combine knowledge of loan origination processes with hands-on experience using SQL reviewing structured data files analyzing system logs troubleshooting configurations and documenting findings. While this individual will communicate with financial institution customers when needed they will not serve as the primary customer contact throughout the implementation.

What Youll Do

• Support data conversions and technical activities for Hawthorn River loan origination software implementations.

• Review source data received from core banking systems loan origination platforms and third-party vendors.

• Map source data fields to Hawthorn Rivers standardized conversion specifications.

• Use SQL to review reconcile validate and transform loan data.

• Analyze CSV fixed-width XML JSON and other structured data files to identify formatting issues missing values and discrepancies.

• Validate that source fields align with target-system requirements before data is loaded into Hawthorn River.

• Investigate rejected missing or improperly translated data and document the cause and resolution.

• Review system and integration logs to identify configuration connectivity and data-flow issues.

• Troubleshoot file-based and API-driven integrations in partnership with implementation product support and engineering teams.

• Assist with data transformations including field translations supplemental file processing and loan account number changes.

• Use SQL Python or other scripting tools when appropriate to improve the efficiency and accuracy of conversion activities.

• Support testing data validation user acceptance testing go-live activities and post-conversion issue resolution.

• Maintain thorough documentation of data mappings conversion decisions validation results identified issues and resolutions.

• Communicate technical findings clearly to customers and internal stakeholders when conversion or configuration issues require additional information or action.

• Develop a strong understanding of the Hawthorn River platform its data requirements integration capabilities and loan origination workflows.

• Collaborate closely with implementation product support and technical teams to ensure successful customer conversions.

• Manage assigned conversion tasks and priorities across multiple implementations.

What Were Looking For

• Two or more years of experience in data conversion technical implementation systems integration banking operations fintech or a related field.

• Working knowledge of loan origination processes including application evaluation approval documentation closing and funding.

• Hands-on SQL experience involving data review validation reconciliation or transformation.

• Experience working with structured data files such as CSV fixed-width XML or JSON.

• Understanding of data conversion activities including source-to-target mapping field-level transformation validation and exception handling.

• Ability to read system or integration logs and use the information to troubleshoot technical issues.

• Experience reviewing configurations and identifying dataflow formatting or connectivity problems.

• Strong analytical and problem-solving skills with close attention to data accuracy.

• Excellent documentation organization and follow-through.

• Ability to explain technical findings to both technical and non-technical audiences.

• Strong written and verbal communication skills.

• Ability to work independently while collaborating effectively with cross-functional and customer-facing teams.

• Ability to manage multiple assignments and changing priorities in a remote environment.

Preferred Qualifications

• Experience supporting a loan origination system or other lending technology.

• Experience with core banking system conversions or integrations.

• Practical knowledge of banking or lending operations.

• Experience working with loan data from a financial institution core provider or third-party vendor.

• Familiarity with file-based and API-driven integration methods.

• Experience using Python or another scripting language to automate data review or transformation activities.

• Exposure to data migration data quality or conversion reconciliation processes.

• Educational background in computer science information systems data analytics finance banking or a related discipline.

What Will Help You Succeed

• You are comfortable investigating issues and working through logs data files and system configurations to determine what went wrong.

• You understand that accurate documentation is an essential part of successful data conversion.

• You can connect technical data requirements with real-world loan origination processes.

• You enjoy detail-oriented work and can identify when a field value or record does not align with the expected result.

• You communicate clearly and professionally when additional information is needed from a customer or internal stakeholder.

• You are interested in using SQL scripting or automation to make repeatable data work more efficient.

• You are comfortable contributing behind the scenes while playing an important role in the success of customer implementations.