Servicing Transfers Data Mapping Analyst

Summary

Join Valon's Servicing Transfers team as a Data Mapping Analyst and contribute to building custom integrations for third-party data into Valon's system. You will translate data mappings into a SQL converter framework, ensuring data is ready for ingestion. Collaborate with subject matter experts to iterate on mappings and processes. Contribute to defining optimal processes and tooling for building and maintaining converter mappings. This role involves implementing converter mapping using existing Access-based tooling and transitioning to SQL-based solutions. The position requires strong SQL proficiency, data manipulation skills, and excellent communication. Valon offers competitive compensation, comprehensive benefits, and generous time off.

Requirements

• Bachelor’s Degree preferred
• 3-4+ years of experience working in data mapping / conversion (ideally at a mortgage or financial technology company)
• SQL proficient
• Excellent data manipulation skills
• Excellent communication skills (both verbal and written)
• Excellent critical thinking and logical reasoning abilities
• Excellent organizational skills and attention to detail

Responsibilities

• Coordinate with Servicing Transfers personnel to obtain written converter mapping instructions for new servicer relationships
• Utilize existing Microsoft Access framework to convert written converter mapping instructions into automated converters to output Valon-formatted ingestion-ready data files (csv)
• Coordinate with Servicing Transfers personnel to test newly written converter mapping code, iterating until correct
• Partner with Servicing Transfers management to define/design/build/maintain SQL based tooling to convert disparate servicing transfer data into Valon-formatted input files automatically
• Convert legacy Access-based mappings into the new SQL tooling structure
• Create/modify validation queries in Valon-custom expression language based on feedback/input from Valon cross-functional teams
• Other similar duties as assigned

Preferred Qualifications

• Deep understanding of mortgage servicing concepts, including but not limited to: mortgage loan documents, data fields, and terminology
• Exceptional project management skills and ability to prioritize and complete multiple projects with deadlines and high velocity
• Considered within the entire company to be an expert in their process areas
• Experience with Access
• Experience with Python
• Experience with Monarch
• Experience with large-scale servicing systems (Black Knight, Sagent, Loanserv)
• Experience building out automated data file movement / ingestion

Benefits

• Compensation: competitive salary with a meaningful stake in the company via equity, and 401k plan
• Health & well-being: we’ll invest in your physical and mental well-being with comprehensive medical, dental, & vision benefits
• Commuter benefits: We offer pre-tax deductions for public transportation, rideshare services, and parking expenses to make your commute more affordable and convenient
• Grow together: Company wide orientation for you to successfully onboard and other learning & development opportunities including regular review cycles that feature 360 degree feedback
• Generous time off: 17 days paid time off, sick days, and 11 company holidays
• Baby bonding time!: 12 weeks off for both birthing and non-birthing parents - fully paid so you can focus your energy on your newest addition