BI Analyst

Fountain Forward

Bogotá

Remote

COP 60,000,000 - 120,000,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote-First culture
Flexible schedule
Unlimited PTO
Parental leave
Room to grow
Professional development
Quarterly bonuses
Referral program
Health reimbursement

Job summary

Fountain Forward is seeking a BI Analyst to execute daily analytics processes, maintain dashboards, and deliver standardized reports for clients and internal teams. You will process data from CRM, GA4, and ad platforms, producing actionable insights and supporting campaign optimization.

The role emphasizes data accuracy, SLA-driven reporting, and collaboration with CSMs, PMs, and analysts across pods in a remote-first, globally distributed team.

Qualifications

  • Strong organizational, time management, and analytical skills.
  • Proficiency in Google Workspace (Sheets, Slides, Docs).
  • Basic knowledge of Google Analytics (GA4).
  • Ability to process large datasets with accuracy and speed.
  • Strong attention to detail and ability to work under time constraints.

Responsibilities

  • Data Entry & Processing: Prepare, compile, and verify data from CRM, GA4, inventory feeds, offline events, and competitor pools.
  • Enter and update data in Fountain Tracker, ADF Templates, BM templates, and client trackers.
  • Ensure accuracy by following SOP techniques and flagging discrepancies.
  • Reporting & Analytics Execution: Generate Forward Progress Reports (FPRs) within SLA.
  • Produce ad performance reports for Meta Ads (twice weekly) and Google Ads (monthly).
  • Deliver ad hoc reports and discretionary client requests in collaboration with Seniors.
  • Guide goal-pacing sessions to focus on prioritizing the actionable data dealerships need to attain their sales targets.
  • Analyse campaign and advertising results to provide insights and recommendations during pod calls.

Skills

Organizational skills
Time management
Analytical skills

Education

Bachelor's degree in a related field

Tools

Google Analytics GA4
CRM software
Google Tag Manager
Google Sheets
Excel

Job description

The entire application process must be completed in English. Fluent written and spoken English is required and will be evaluated.

Applicants must be independent freelancers, not represented by another agency, and currently based in Latin America or Asia.

JOB DESCRIPTION

The BI Analyst is responsible for executing the daily analytics processes that ensure accurate, timely, and actionable data for Fountain Forward and its clients. This role combines data entry, reporting, and analysis execution. Specialists maintain dashboards, process data from multiple sources, and deliver standardized reports. Accuracy and efficiency are critical, as this role provides the foundation for all insights used by Seniors, the Director, and client-facing teams.

Responsibilities & Duties

Data Entry & Processing

  • Prepare, compile, and verify data from CRM, GA4, inventory feeds, offline events, and competitor pools.
  • Enter and update data in Fountain Tracker, ADF Templates, BM templates, and client trackers.
  • Ensure accuracy by following SOP techniques and flagging discrepancies.
Reporting & Analytics Execution
  • Generate Forward Progress Reports (FPRs) within SLA.
  • Produce ad performance reports for Meta Ads (twice weekly) and Google Ads (monthly).
  • Deliver ad hoc reports and discretionary client requests in collaboration with Seniors.
  • Guide goal-pacing sessions to focus on prioritizing the actionable data dealerships need to attain their sales targets.
  • Analyse campaign and advertising results to provide insights and recommendations during pod calls. Use cross-channel reviews to inform budget allocation decisions, address performance issues for struggling clients, and improve overall outcomes through strategic budget assignment.
Process Compliance
  • Follow templates, SOPs, and process characterizations for each deliverable.
  • Ensure requests and reports are completed within SLA timelines.
  • Document tasks in ClickUp for visibility and traceability.
  • Work with CSMs and PMs to gather client requirements for reports.
  • Collaborate with Client Success Managers (CSMs), Project Managers (PMs), and Search and Social Media Analysts during pod meetings to coordinate task requirements, ensuring the establishment of definitive project scopes, deliverables, and timelines.
  • Coordinate with Tech & Innovation to troubleshoot data pipelines and dashboards.
  • Support Seniors in process improvements by providing feedback on execution challenges.
Requirements
Required Skills & Qualifications
  • Strong organizational, time management, and analytical skills.
  • Proficiency in Google Workspace (Sheets, Slides, Docs).
  • Basic knowledge of Google Analytics (GA4).
  • Ability to process large datasets with accuracy and speed.
  • Strong attention to detail and ability to work under time constraints.
Preferred Experience & Competencies
  • Experience with CRM software.
  • Familiarity with Google Tag Manager.
  • High proficiency with Google Sheets/Excel formulas and chart creation.
  • Background in digital marketing or the automotive industry is a plus.
How We Work
  • Freedom and flexibility. We’re a team working from around the world. That is, as long as they show up on our weekly calls, do their job correctly, and have a good sense of accountability.
  • Autonomy and ownership. Working on a distributed team means you don’t have someone micromanaging you or looking over your shoulder to make sure you’re getting things done. We’re a team of do-ers who take full ownership for their results.
  • Be helpful and dedicated. We help our clients be successful. We help our prospects get the right information and make the right decision whether or not it includes our services. We help our team members reach their full potential.
What We Offer
  • Technical ownership of a flagship product from day one.
  • A clear leadership path with a team to grow and develop.
  • Modern stack, pragmatic processes, and fast decision-making.
  • Competitive compensation aligned with seniority and impact.
The Perks!
  • Remote-First Culture: Work from home—or anywhere in the world. We value results, not where you log in from.
  • Flexible Schedule: We offer flexibility in your daily schedule (within reason) to help you do your best work while maintaining a healthy work-life balance.
  • Unlimited Paid Time Off: Enjoy an unlimited vacation policy with just two weeks’ notice and manager approval. We also offer paid sick days because your well-being matters.
  • Parental Leave: We understand the importance of supporting our team members during significant life events. Our maternity and paternity leave policy ensures you can prioritize your growing family without added stress.
  • Room to Grow: We’re a fast-growing company with massive opportunities for upward mobility. As we grow, you grow with us.
  • Professional Development: Get access to training in digital marketing, advertising, and leadership to sharpen your skills and advance your career.
  • Quarterly Performance Bonuses: Earn bonuses based on your performance and contributions to the company’s success.
  • Paid Referral Program: Earn rewards for referring great talent to join our team!
  • Health & Fitness Reimbursement (upon tenure): Get support for health insurance or a gym membership—because your well-being matters.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Ads Director
Ads Director

Fountain Forward • Bogotá

Remote
COP 388,802,000 - 583,204,000
Remote-First Culture
Flexible Schedule
Unlimited Paid Time Off
+6
Ads Director
Ads Director

Fountain Forward • Bogotá

Remote
COP 298,498,000 - 397,997,000
Remote-First Culture
Flexible Schedule
Ads Specialist (Media Buyer)
Ads Specialist (Media Buyer)

Fountain Forward • Bogotá

Remote
COP 66,333,000 - 106,132,000
Remote-First Culture: Work from home
Flexible Schedule
Unlimited Paid Time Off
+6
Reporting and Dashboard Specialist - CO
Reporting and Dashboard Specialist - CO

within • Puerto Bogotá

On-site
COP 30,000,000 - 55,000,000
Unlimited vacation
Phone stipend
Food stipend
+2
Fashion Paid Media Senior Performance Analyst
Fashion Paid Media Senior Performance Analyst

Power Digital Marketing • Colombia

On-site
COP 60,000,000 - 120,000,000
Paid Advertising Specialist - Ecommerce
Paid Advertising Specialist - Ecommerce

Power Digital Marketing • Colombia

On-site
COP 30,000,000 - 54,000,000
Paid Advertising Strategist, Leadgen
Paid Advertising Strategist, Leadgen

Power Digital Marketing • Colombia

Hybrid
COP 20,000,000 - 40,000,000
Base salary + commission opportunities
Prepaid Medicine Plan
15 paid vacation days (PTO)
+7
Head Of Growth (Paid Media + Client Accounts + Ai) | Marketing For Multi-Location Brands | Remote (Latam)
Head Of Growth (Paid Media + Client Accounts + Ai) | Marketing For Multi-Location Brands | Remote (Latam)

Atomic Hr • Sur

Remote
COP 388,777,000 - 615,564,000
Fully remote contractor role from LATM
Unlimited PTO
Direct line to the CEO
+1
Senior Paid Advertising Strategist - Ecommerce
Senior Paid Advertising Strategist - Ecommerce

Power Digital Marketing • Colombia

Remote
COP 291,319,000 - 420,794,000
Head Of Growth (Paid Media + Client Accounts + Ai) | Marketing For Multi-Location Brands | Remote (Latam)
Head Of Growth (Paid Media + Client Accounts + Ai) | Marketing For Multi-Location Brands | Remote (Latam)

Atomic Hr • Medellín

Remote
COP 217,092,000 - 325,639,000
Fully remote
US business hours
Paid in USD as a contractor
+3