Financial & Data Analyst at Pavago in Colombia, Colombia

Financial Analyst / Data Analyst – Remote

SQL | Financial Modeling | Business Intelligence | FP&A

Position Type: Full-Time, Remote Working Hours: U.S. Client Business Hours

About the Role

At Pavago, one of our clients is hiring a Financial Analyst / Data Analyst to transform financial and operational data into actionable insights that support strategic business decisions.

This role sits at the intersection of finance, analytics, and business strategy, combining financial modeling, forecasting, SQL-based data analysis, and business intelligence reporting. You’ll build dashboards, analyze trends, develop financial models, and provide leadership with accurate, data-driven recommendations that influence company performance.

If you’re passionate about turning complex data into meaningful insights and enjoy working with both financial analysis and business intelligence, this is an excellent opportunity to make a measurable impact.

What You’ll Own

Financial Modeling & Analysis

• Build and maintain three-statement financial models (P&L, Balance Sheet, and Cash Flow).
• Develop forecasts, budgets, and rolling financial projections.
• Perform scenario analysis, sensitivity analysis, and forecasting.
• Analyze ROI, IRR, break-even points, and investment performance.
• Support strategic business decisions through financial analysis and modeling.

Data Analysis & Business Insights

• Query, extract, and analyze data using SQL.
• Clean, structure, and transform datasets using Excel, Python, R, or similar tools.
• Conduct variance analysis comparing actual results against forecasts and budgets.
• Identify business trends, operational risks, and growth opportunities.
• Translate complex datasets into clear business recommendations.

Reporting & Business Intelligence

• Design and maintain dashboards using:
  • Tableau
  • Power BI
  • Looker
• Prepare monthly financial reports, executive summaries, and board-level presentations.
• Ensure reporting is accurate, consistent, and easy to understand.
• Automate recurring reporting where possible.

Forecasting & FP&A Support

• Support budgeting and financial planning processes.
• Maintain rolling forecasts using real-time business performance.
• Improve forecasting accuracy through continuous analysis.
• Assist leadership with strategic planning and financial decision-making.

Data Quality & Governance

• Validate financial and operational data across multiple systems.
• Maintain documentation for models, assumptions, and reporting methodologies.
• Ensure reporting integrity and consistency.
• Improve data governance and reporting standards.

Cross-Functional Collaboration

• Partner with Finance, Operations, Sales, and Leadership teams.
• Present findings and recommendations in clear business language.
• Support cross-functional initiatives with structured financial analysis.
• Help leadership make informed, data-driven decisions.

Requirements

Must-Have Qualifications

Experience

• 2+ years of experience in:
  • Financial Analysis
  • FP&A
  • Data Analytics
• Experience supporting business decision-making through financial and operational analysis.

Core Skills

• Advanced Microsoft Excel or Google Sheets, including:
  • Pivot Tables
  • INDEX/MATCH
  • Financial Modeling
  • Advanced formulas
• Strong SQL skills, including:
  • Data extraction
  • Joins
  • Query optimization
• Experience with financial reporting, forecasting, and variance analysis.
• Strong analytical and problem-solving abilities.
• Excellent written and verbal English communication skills.

Technical Stack

• SQL
• Microsoft Excel / Google Sheets
• Tableau
• Power BI
• Looker

Nice to Have

• Python or R for data analysis.
• Experience with ERP systems such as:
  • NetSuite
  • SAP
  • Oracle
• Experience supporting SaaS, Finance, Healthcare, or similar industries.
• Experience building executive dashboards and automated reporting.

What Makes You a Strong Fit

• Strong analytical mindset with exceptional attention to detail.
• Able to simplify complex financial and operational data.
• Comfortable working with large datasets and ambiguity.
• Strong business acumen with a data-driven approach.
• Excellent communicator who presents insights clearly.
• Proactive and continuously identifies opportunities for improvement.

What a Typical Day Looks Like

• Extract and clean financial and operational data using SQL.
• Update financial models with current business performance.
• Perform variance and scenario analysis.
• Build and refine dashboards for leadership.
• Present insights and recommendations to stakeholders.
• Improve reporting processes and forecasting accuracy.

In short: You transform financial and operational data into reliable insights that help leadership make smarter, faster business decisions.

Key Metrics for Success (KPIs)

• Forecast accuracy within target ranges (±5–10%)
• Timely delivery of financial and operational reports
• Dashboard reliability and stakeholder adoption
• Data accuracy and reporting consistency
• Quality of financial insights supporting business decisions
• Leadership satisfaction with reporting and analysis

Why This Role Stands Out

• High visibility with leadership and decision-makers.
• Opportunity to influence business strategy through data.
• Strong blend of finance, analytics, and business intelligence.
• Exposure to forecasting, financial planning, and executive reporting.
• Fully remote work environment with long-term growth opportunities.
• Clear career progression into:
  • Senior Financial Analyst
  • FP&A Manager
  • Business Intelligence Manager
  • Finance Manager

Interview Process

1. Initial Phone Screen
2. Spark Hire Intro Video (3–5 minutes)
3. Practical Assessment (Financial Model or Dashboard Exercise)
4. Final Client Interview
5. Offer & Background Verification

What Happens After You Apply

Right after you apply, you’ll receive an email invitation from Spark Hire to record your Intro Video. This short, self-recorded video is the next step that completes your application and can be recorded whenever it’s convenient for you.

Instead of repeating yourself across multiple screening calls, you’ll introduce yourself once, and your video will be shared with the hiring team. This helps the hiring team evaluate your communication style early, making future interviews more meaningful while reducing unnecessary interview rounds.

Don’t overthink it—you can record your video as many times as you’d like before submitting it. Only your final submission will be reviewed.

Please keep an eye on both your inbox and spam folder for your Spark Hire invitation after submitting your application.

Apply Now

If you’re passionate about financial analysis, data analytics, and business intelligence—and enjoy turning numbers into strategic business insights—we’d love to hear from you. Apply today and help drive smarter, data-backed decisions within a growing organization.