Job Title: Loan Accounting Systems Data Analyst
Must live or relocate to Austin TX. Must be able to work Onsite Tuesday -Wednesday (Remote Monday and Friday). Department: Loan Accounting Systems Location: Austin, TX 78746 Work Hours: WFH Hybrid Job Type: Contract to Hire Job Summary: The Loan Accounting System Data Analyst plays a key role in supporting the integrity, accuracy, and efficiency of loan accounting data and systems. This position bridges the gap between finance, lending operations, and IT by analyzing loan data, identifying trends or anomalies, ensuring compliance with accounting standards, and supporting system enhancements and reporting requirements. The ideal candidate will have strong analytical skills, an understanding of loan products and accounting principles, and experience working with loan accounting systems and data reporting tools. Key Responsibilities: - Analyze loan accounting system data to ensure accuracy, completeness, and compliance with internal policies and external regulations.
- Support the configuration, testing, and implementation of enhancements or updates to the loan accounting system (e.g., Loan IQ).
- Reconcile loan balances and transactions between the loan system and general ledger.
- Develop, maintain, and automate recurring and ad-hoc reports using tools such as SQL, DataBricks, Excel, Power BI, or Tableau.
- Collaborate with IT, finance, and loan operations teams to resolve data quality issues and streamline processes.
- Perform root cause analysis on data discrepancies and recommend corrective actions.
- Assist in audits and regulatory reporting by providing supporting data and documentation.
- Participate in system conversions, upgrades, and integration projects involving loan accounting data.
- Maintain system data dictionaries, mapping documents, and process documentation.
- Monitor and analyze portfolio trends, delinquencies, accruals, interest income recognition, and other key metrics.
Qualifications: Required: - Bachelor s degree in Finance, Accounting, Information Systems, Data Analytics, or related field.
- 2 5 years of experience in financial services, loan operations, or data/system analysis.
- Experience working with loan accounting systems and financial data.
- Proficiency in SQL and advanced Excel (pivot tables, lookups, formulas).
- Strong understanding of accounting principles related to loan products (e.g., interest accruals, amortization, reserves).
- Excellent problem-solving, communication, and documentation skills.
Preferred: - Experience with business intelligence tools (Power BI, Tableau, etc.).
- Familiarity with data warehousing and ETL processes.
- Knowledge of regulatory requirements (CECL, SOX, GAAP) related to loan accounting.
- Experience in system testing, UAT, or working with IT on data/system projects.
Key Competencies: - Analytical thinking and attention to detail
- Process improvement mindset
- Ability to work independently and cross-functionally
- Strong organizational and time management skills
- Adaptability to changing systems and business needs
Best Regards, Email: |