Remote - Analytics Analyst

World Business Lenders, LLC; Bogotá; Remote; COP 44,677,529 - 67,016,293; Full time

Benefits offered by this job

PTO Available

100% Work from home

Job summary

A financial services company in Bogotá is seeking a Data Analyst to assist in analytics, reporting, and financial modeling. Candidates should have a Bachelor's degree and 1-4 years of relevant experience, along with strong Excel skills and fluency in English. This contract position offers a base salary between $1000 and $1500 with 100% remote work capability.

Qualifications

• 1-4 years of experience in financial analysis/modeling.
• Solid knowledge of business, accounting, quantitative analysis, and finance.
• FP&A experience is desirable.

Responsibilities

• Assist in Data Analytics, Business Intelligence, and Loan Servicing.
• Develop comprehensive reporting suites.
• Prepare cash flow forecasts and financial reports.

Skills

Financial analysis/modeling

Excellent English fluency

Excel proficiency

Education

Bachelor's degree in Accounting, Finance, Mathematics, Business Administration

Tools

SQL

Job description

Overview

This is a Contract/Consultant position. Generally, working hours will be 9:00am-6:00pm Eastern Time, Monday through Friday, although hours worked may be greater based upon operational requirements. You must be comfortable working with productivity monitoring systems. The job requires excellent oral and written command of the English language. RESUMES MUST BE SUBMITTED IN ENGLISH.

Responsibilities

• Assist in the Data Analytics, Business Intelligence, and Loan Servicing functions within the company
• Support the development and implementation of comprehensive reporting suites across the organization
• Contribute to the development of financial models and algorithms to analyze loan level and overall portfolio credit risk, identifying patterns, correlations, and sensitivities among portfolio variables
• Assist in constructing pricing models for loan amortization schedules
• Maintain the integrity of the loan records with the loan administration system
• Prepare, analyze, and interpret monthly financial results
• Monitor and support the management of mortgage and title policy for loan portfolios
• Assist in identifying, analyzing, and documenting client portfolio risk and risk mitigating factors
• Prepare loan monitoring reports on a regular schedule to review overall asset quality, including performance against original underwriting expectations
• Generate monthly and quarterly financial reports, tracking actuals vs. budget/forecast for key metrics
• Prepare cash flow forecasts and various long-term financial and statistical projections for strategic planning
• Generate aging reports, showing the delinquency status and payment performance
• Conduct periodic reviews and analyses of underwriting expectations post-funding: categorize exception distribution, rationale, and justifications; issue monthly executive-level exception reports to validate compliance with the underwriting policy and procedure
• Support financial and functional due diligence requests for corporate transactions
• Assist with other projects and duties as assigned by the Business Analytics Manager

Qualifications

• Bachelor's degree or equivalent in Accounting, Finance, Mathematics, Business Administration or a related field
• 1-4 years progressive experience in financial analysis/modeling in the financial lending or mortgage industry
• Solid knowledge of the principles of general business, accounting, quantitative analysis and finance
• FP&A experience desirable
• High degree of proficiency in Excel, including complex financial analysis/modeling, VBA/macros, relational databases and SQL
• Excellent English fluency, both written and verbal

Benefits

• USD Base salary ($1000 - $1500)
• Contract/Consultant position
• PTO Available
• 100% Work from home