Financial & Data Analyst
Pavago · Colombia
Skills in this posting
Extracted from the posting text by the instrument — the demand side, read literally.
The posting
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.
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
Excerpt from the original listing. The full, current text lives at the source. Read and apply there →
The PivotHop read
- What a data analyst actually earnsmedian, seniority, by country
- Where data analysts move nextevery measured route out
- BI Developer → Data Analyst83% readiness
- Data Engineer → Data Analyst60% readiness
- Product Analyst → Data Analyst52% readiness
- All open data analyst rolesthe full board
Where these skills also reach
Adjacent occupations measured from the same postings — readiness is what a data analyst’s profile already covers.
- 33 open product analyst roles62% readiness from data analyst
- 21 open bi developer roles48% readiness from data analyst
- 250 open business analyst roles40% readiness from data analyst
- 250 open data engineer roles29% readiness from data analyst
More data analyst roles
- Senior Data Analyst (AI-Enabled Analytics) (all genders)Gotphoto · Berlin, Hybrid
- Marketing AnalystPergolux · Berlin | Global Team
- Revenue Data AnalystDoorDash · United States
- Data AnalystBH Properties · Philippines
- Senior Marketing Data Analyst - Marketing Mix ModellingN26 · Berlin
Backfilled listing, refreshed with the nightly scrape; the employer has not claimed it yet. Are you the employer? Claim this listing and it can be featured to the candidates whose skills already reach it, first month free.