Job Overview
Job description
- Location:
- Colombia
- Work arrangement:
- On-site
Role Summary
- Financial Analyst / Data Analyst – Remote
- SQL | Financial Modeling | Business Intelligence | FP&A
- Position Type: Full-Time, Remote
- Working Hours: U.S. Client Business Hours
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.
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.
Advanced Microsoft Excel or Google Sheets, including
- Pivot Tables
- INDEX/MATCH
- Financial Modeling
- Advanced formulas
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
Responsibilities
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
Requirements
Must-Have Qualifications
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.
About the Company
Work directly with leadership in a highly visible role.
Operate at the forefront of AI, marketing, and automation.
Gain exposure across content, growth, outreach, events, and operations.
Significant ownership and creative freedom.
Opportunity to build systems that directly impact business growth.
Fully remote work environment.
Additional Information
- 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.
- Role:
- Financial & Data Analyst
- Job Type:
- Full Time