Business Analyst - Loan Calculations

Republic Finance; Plano (TX); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

15 days of Paid Time Off (PTO)

401k with employer match

Company provided Life Insurance

Employee Assistance Program

Job summary

A financial services company in Plano, TX is seeking a Mid-Senior level Analyst to focus on loan calculations and compliance testing. The ideal candidate should hold a bachelor’s degree in a related field, possess strong Excel and SQL skills, and have a basic understanding of loan amortization concepts. This hybrid position allows for work onsite three days a week and includes various benefits like PTO and a 401k plan.

Qualifications

• Ability to create amortization schedules in Excel.
• Proficiency in SQL and basic understanding of data infrastructure.
• Great documentation and communication skills.

Responsibilities

• Perform loan calculation tasks and compliance testing.
• Enhance operational strategies through analysis of data.
• Ensure compliance with applicable laws and regulations.

Skills

Loan amortization concepts

Excel (Goal Seek, Solver)

SQL

Python

Collaboration

Education

Bachelor’s degree in computer science, IT, or related field

Tools

Excel

SQL

Python

Job description

Overview

Republic Finance has been in business for more than 70 years and is a trusted lender in over 250 communities across the United States. We specialize in providing flexible lending solutions and incomparable customer service. Our shared mission is to pursue excellence for our team, our customers, and our performance. We continually improve our offerings while opening more branches in new states each year. We regularly promote from within and give back to the communities we serve. Our culture is about helping customers, investing in our employees' future, and ensuring that our performance makes an impact on our community.

**PLEASE NOTE that this is a hybrid position and requires working onsite at our Plano, TX office three days each week.

Responsibilities

• Perform loan calculation tasks and compliance testing on loan calculations.
• Focus on how the loan system is programmed and ensure it meets compliance standards.
• Continuously challenge and enhance operational strategies through analysis of customer behavior data and sophisticated statistical and financial modeling.
• Maintain a rigorous performance monitoring framework and management dashboards to highlight performance trends and areas of opportunity.
• Develop best-in-class products that provide our consumers with solutions while minimizing portfolio risk.
• Establish a robust test and learn environment for continual strategy improvement.
• Build and maintain a robust economic framework that will serve as the foundation for business decision-making.
• Ensure policies remain compliant with all applicable laws and regulations.
• Maintain transparent communication and trust with all key stakeholders.
• Demonstrate strong math skills and the ability to handle various responsibilities.

Requirements

• Bachelor’s degree or higher in computer science, Information Technology, or a related field (or equivalent practical experience).
• Basic understanding of loan amortization concepts, including how payments are split between principal and interest over time.
• Ability to create amortization schedules in Excel, including building from scratch using formulas.
• Proficiency with Excel tools such as Goal Seek and Solver to reverse-engineer variables like payment amount or interest rate based on loan parameters.
• Proficient in SQL and have a fundamental understanding of data infrastructure.
• Knowledge of Python is an added advantage.
• Great documentation and communication skills.
• Ability to work collaboratively with the internal team.
• Eagerness to learn and adapt to new technologies.

Benefits

• 15 days of Paid Time Off (PTO) to start + 1 additional personal holiday
• 401k + employer match
• Company provided Life Insurance & Long Term Disability
• Employee Assistance Program - Confidential mental health support

Additional benefits

• Access to LinkedIn Learning's library of 10,000+ professional development courses
• Employee of the Month Program
• Philanthropic support for multiple charities including an annual drive for St. Jude Children's Research Hospital
• Regular drawings for Sports tickets
• Professional offices with a friendly team environment

Equal Opportunity

Republic Finance, LLC is an Equal Opportunity Employer and does not discriminate on the basis of race, sex, color, religion, national origin, age, disability or veteran status in employment opportunities and benefits. Republic Finance, LLC maintains a Drug-Free Workplace.

Location

Plano, TX (Hybrid: onsite three days per week)

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Research, Analyst, and Information Technology