name

Financial & Data Analyst

Remote, Colombia remote Mid Salary not listed
remote Mid level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

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

Initial Phone Screen

Spark Hire Intro Video (3–5 minutes)

Practical Assessment (Financial Model or Dashboard Exercise)

Final Client Interview

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.
Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Mid
Technology & IT Data Analysis Excel Finance MySQL Operations Mid level

Likely questions

  1. Tell us about work you have done that is close to the Financial & Data Analyst role.
  2. How would you approach your first 30 days at name?
  3. Which of Data Analysis, Excel and Finance have you used recently, and what did it help you achieve?
  4. Describe a time you solved a problem without waiting to be told exactly what to do.
  5. How do you stay organised and communicate clearly when working remotely?

Prepare before the call

  • A recent example that proves your experience with Data Analysis, Excel and Finance.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the Financial & Data Analyst role because I can bring practical experience in Data Analysis, Excel and Finance, learn the team quickly, and contribute to the outcomes name needs from this hire.

Related jobs.

More roles from this company or category.