[Hiring] BI Analyst @Fountain Forward

Role 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.
  • Update dashboards (Fountain Forward Portal, Slides, AES, ASA, FPR Dashboards).
  • 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.
• Collaboration
  • 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.

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.

Requirements

• 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.

Benefits

• How We Work
  • Freedom and flexibility. We’re a team working from around the world.
  • Autonomy and ownership. Working on a distributed team means you don’t have someone micromanaging you.
  • Be helpful and dedicated. We help our clients be successful.
• 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.
  • Flexible Schedule: We offer flexibility in your daily schedule.
  • Unlimited Paid Time Off: Enjoy an unlimited vacation policy with just two weeks’ notice.
  • Parental Leave: Our maternity and paternity leave policy ensures you can prioritize your growing family.
  • Room to Grow: We’re a fast-growing company with massive opportunities for upward mobility.
  • Professional Development: Access to training in digital marketing, advertising, and leadership.
  • Quarterly Performance Bonuses: Earn bonuses based on your performance.
  • 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.