BI Analyst

This is a remote position.

REMOTE / WORK FROM HOME POSITION

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.

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

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

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

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.
  
  

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

• Freedom and flexibility. Were 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 dont have someone micromanaging you or looking over your shoulder to make sure youre getting things done. Were 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.
  

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

• Remote-First Culture: Work from homeor 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: Were 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 companys 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 membershipbecause your well-being matters.