Executes daily data processing, dashboard updates, standardized reporting, and campaign analysis. The role compiles data from CRM, advertising, analytics, inventory, and offline sources; maintains trackers and dashboards; produces recurring and ad hoc reports; supports goal pacing and budget allocation insights; follows SOPs and SLAs; documents work in ClickUp; and collaborates with client success, project management, analytics, and technical teams.
This is a remote position.
REMOTE / WORK FROM HOME POSITION
Before applying, please note:
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.
- 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.
Benefits
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.
Similar Jobs
Energy • Renewable Energy
Leads data governance, quality, business intelligence, operational analytics, and process improvement across the Service organization. Develops executive dashboards, analyzes operational and financial data, establishes governance standards, improves reporting, and automates workflows using Microsoft Power Platform. Partners with business teams to deliver actionable insights and evaluates AI-enabled tools, cloud data platforms, and automation opportunities.
Top Skills:
AirtableAzureDaxMicrosoft 365Microsoft CopilotExcelMicrosoft FabricMicrosoft TeamsOnedrivePower AppsPower AutomatePower BIPower QuerySharepoint
Financial Services
Analyzes data from multiple sources to identify trends, develop member segmentation and lifecycle models, support competitive analysis, and recommend strategies for improving member participation and financial products. Builds reports, dashboards, and data-driven tools for leaders and staff, collaborates with stakeholders, trains power users, and provides ongoing analytical support using SQL, R or Python, ETL, data modeling, and business intelligence tools.
Top Skills:
Data WarehousingDb2ETLOraclePower BIPythonRRdbmsSisenseSQLSQL ServerTableau
Edtech
Build and maintain production data models while migrating workflows from Alteryx to dbt. Manage Redshift pipelines using Dagster or Airflow, create Tableau dashboards, and translate technical data into business insights for Revenue Operations. Collaborate on AI, predictive analytics, churn prediction, and lead scoring initiatives using LLMs and Amazon SageMaker. Serve as a liaison between data teams and business stakeholders across Sales, Marketing, and Customer Experience.
Top Skills:
AirflowAlteryxAmazon RedshiftAmazon SagemakerBigQueryDagsterDbtLarge Language Models (Llms)Machine LearningPythonSalesforceSnowflakeSQLTableau
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory



