Financial Data Analyst

LaTeam Partners; United States; Hybrid; USD 80,000 - 110,000; Full time

Job summary

Lateam Partners is seeking a Financial Data Analyst to join the Finance and Controllership team. The role focuses on validating and reconciling historical financial data across countries and currencies, ensuring transactions align with bank movements and accounting entries for audit readiness.

The ideal candidate has 3–5 years of experience, a finance or accounting degree, and strong SQL, Excel, and Power Query skills. Automation and cross-country collaboration are emphasized.

Qualifications

• 3–5 years of experience in financial analysis, auditing, management control, or financial data analytics.
• Bachelor's degree in Finance, Accounting, Economics, Industrial Engineering, or a related field.
• Advanced Excel and Power Query skills.
• Working knowledge of SQL for querying and analyzing databases.
• Experience reconciling financial transactions or identifying discrepancies across large datasets.
• Experience using mass data reconciliation or financial reconciliation platforms.
• Solid accounting knowledge and attention to detail.

Responsibilities

• Analyze financial data extracted from internal platforms, banks, and payment channels.
• Clean, standardize, and organize large datasets for accuracy.
• Identify incomplete records, duplicates, and discrepancies across databases.
• Match platform transactions with bank movements and accounting records; provide explanations with evidence.
• Perform large-scale reconciliations using Rexi and develop reconciliation rules.
• Prepare reconciliation reports and support accounting adjustments; assist with Rexi→Odoo entries.
• Automate data reconciliation and reporting using SQL, Python, Power Query, or AI tools.

Skills

Advanced Excel

Power Query

SQL

Analytical thinking

Attention to detail

Education

Bachelor's degree in Finance, Accounting, Economics, Industrial Engineering, or related field

Tools

Rexi

Odoo

Power BI

Job description

Location:

Remote – Latin America. Costa Rica preferred, hybrid role.

Job type:

Full-time, hired as a contractor

About the Client

Our client is a growing fintech group focused on expanding access to credit and financial services across Latin America through innovative technology-driven solutions. Operating in multiple markets, the company provides digital financing solutions and credit products to underserved populations, leveraging technology and data to scale its operations.

As the business continues to grow and strengthen its financial infrastructure, the company is investing in the reconstruction, reconciliation, and validation of historical financial information to support reliable financial reporting and external audit readiness.

About the Role

We are looking for a detail-oriented and analytical Financial Data Analyst to join the Finance and Controllership team. This role will focus on analyzing, cleaning, reconciling, and validating large volumes of historical financial data across multiple countries and currencies. The main objective is to ensure that every transaction recorded in the company's platforms can be accurately matched with its corresponding bank movement and accounting entry, providing reliable supporting documentation for financial reporting and audit purposes.

The ideal candidate combines strong financial and accounting knowledge with advanced data analysis capabilities, experience handling large datasets, and an interest in leveraging technology and automation to improve financial processes.

You will report to the Accounting Reconstruction Lead and work closely with the accounting team, Technology, and local finance teams across different countries.

Job Responsibilities

Financial Data Analysis and Validation

• Receive and analyze financial data extracted by the Technology team from internal platforms, banks, and payment channels.
• Clean, standardize, normalize, and organize large datasets to ensure accuracy and consistency.
• Identify incomplete records, duplicate transactions, inconsistencies, and discrepancies across financial databases.
• Build data relationships and cross-references to match platform transactions with corresponding bank movements and accounting records.
• Investigate discrepancies and provide clear explanations supported by data and evidence.
• Perform large-scale financial data reconciliations using Rexi, an AI-powered financial reconciliation platform.
• Create, maintain, and optimize reconciliation and validation rules within Rexi.
• Review unmatched transactions and continuously improve reconciliation rules to minimize unresolved items.
• Identify, quantify, and document differences, duplicate transactions, and unsupported entries.
• Prepare reconciliation reports and summaries to support the accounting team in recording adjustments.
• Support the generation of accounting entries from Rexi into Odoo.

Portfolio and Intercompany Analysis

• Reconstruct loan portfolio balances, collections, and revenue based on platform transaction data.
• Analyze financial flows between different legal entities to validate and support intercompany balances.
• Investigate discrepancies between operational, banking, and accounting information.

Documentation and Audit Support

• Document data sources, queries, reconciliation methodologies, and validation criteria to ensure processes are traceable and repeatable.
• Maintain detailed supporting documentation for financial reconciliations and adjustments.
• Prepare transaction samples, supporting schedules, and detailed information requested by external auditors.
• Ensure that reconciled financial information is accurate, complete, and properly supported.

Automation and Process Improvement

• Automate data reconciliation, validation, and reporting processes using SQL, Python, Power Query, or AI-powered tools.
• Identify opportunities to improve the efficiency and accuracy of financial data workflows.
• Leverage technology and digital tools to reduce manual work and streamline recurring processes.

Job Requirements

• 3–5 years of experience in financial analysis, auditing, management control, or financial data analytics.
• Bachelor's degree in Finance, Accounting, Economics, Industrial Engineering, or a related field.
• Advanced Excel and Power Query skills.
• Working knowledge of SQL for querying and analyzing databases.
• Previous experience reconciling financial transactions or identifying discrepancies across large datasets.
• Experience using mass data reconciliation or financial reconciliation platforms.
• Solid accounting knowledge and the ability to understand how data discrepancies impact financial statements.
• Strong analytical and problem-solving skills, with exceptional attention to detail and the ability to support findings with evidence.
• Intermediate English proficiency is required.
• Tech-oriented mindset, with experience using AI-powered tools and digital solutions to automate and streamline workflows.
• Ability to work independently while collaborating with cross-functional and international teams.

Nice to Have:

• Experience working with financial and banking information in Venezuela, including multi-currency transactions and BCV exchange rates.
• Familiarity with Odoo, particularly financial data extraction and reconciliation.
• Experience with Python, Power BI, or other data analysis and visualization tools.
• Previous experience in fintech, lending, banking, or payment processing companies.
• Experience supporting external audits or working in financial data analytics within a Big Four accounting firm.