Business Intelligence Analyst

IMPORTANT: Please fill out our company application page to be considered for the role

https://zurl.to/aS2w

Job Overview / Purpose Statement

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.

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.

ADDITIONAL INFORMATION

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.

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.

Salary range: Up to $1,000 depending on experience