Opportunity Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list. Find me work
dataroles

Financial & Data Analyst

Pavago Open · verified Oct 24, 2026
Remote Colombia Mid-level Data Analysis & BI

At a glance

Mid-level Data Analysis & BI role at Pavago. Remote, Colombia.

Pay not stated Data Analysis & BI salary

RoleData Analysis & BI
SeniorityMid-level
LocationColombia
WorkplaceRemote
PostedSep 14, 2026 · 5w ago
Role brief

dataroles summary, based on the employer's posting.

What you'll do

  • Build and update three-statement models, then use forecasts and scenario work to inform business decisions
  • Query financial and operating data with SQL, check actuals against budgets, and surface trends or risks
  • Create leadership dashboards and prepare monthly reports, executive summaries, and board presentations
  • Support budgeting and rolling forecasts, improving projections through ongoing analysis of business results
  • Check data across systems and document model assumptions and reporting methods to keep outputs consistent

What you bring

  • At least two years in financial analysis, FP&A, data analytics, or another listed area
  • You have supported business decisions with analysis of financial and operational results
  • Strong SQL skills, including data extraction, joins, and query optimization
  • Advanced Excel or Google Sheets skills, with financial modeling, pivot tables, lookup functions, and advanced formulas
  • You can communicate clearly in written and spoken English

Who this fits

This role suits an analyst who can move between financial modeling, SQL analysis, and BI reporting, then explain findings to leadership. It is fully remote from Colombia, with working hours aligned to U.S. client business hours.

From the employer

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.

Opportunity

Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.

Each morning you get everything that fits, strongest first.

Data Analysis & BIRemote

Find me work

By the team behind dataroles.

Find me work
Opportunity

Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.

Each morning you get everything that fits, strongest first.

Find me work

By the team behind dataroles.