Business Intelligence Analyst

BloomGuarden; Norte; Presencial; COP 60.000.000 - 120.000.000; Jornada completa

Descripción de la vacante

BloomGuarden is seeking a Business Intelligence Analyst to centralize, analyze, and visualize data across Marketing, CRM, Leasing, Operations, and Revenue, delivering a single source of truth for the organization.

This role builds dashboards, develops reports, analyzes the end-to-end customer journey, identifies business trends, audits and optimizes marketing/CRM automation workflows, and delivers actionable insights that support decision-making across Rent Ready Homes and other assigned brands.

Formación

• 3+ years of experience in BI, data analytics, or marketing analytics.
• Strong analytical and problem-solving skills.
• Experience creating dashboards and executive reports.
• Ability to translate data into business insights.

Responsabilidades

• Build and maintain dashboards in Metabase, Looker Studio, and other BI tools.
• Create weekly and monthly executive reports.
• Analyze the complete customer journey from lead to lease.
• Monitor marketing, CRM, leasing, occupancy, and revenue performance.
• Identify funnel bottlenecks and conversion opportunities.
• Audit and optimize Go High Level automation workflows.
• Consolidate data from platforms like AppFolio, GA4, Google Ads, and CRM systems.
• Ensure KPI accuracy and standardized reporting across brands.
• Present findings and actionable recommendations to leadership.

Conocimientos

Analytical skills

Dashboard reporting

Data insights

BI analytics experience

Communication of findings

Educación

Bachelor's degree in a related field

Herramientas

SQL

Metabase or Looker Studio

GA4

Advanced Excel / Google Sheets

Google Ads

Meta Ads

Go High Level (GHL)

AppFolio

BigQuery

AI tools for reporting

Descripción del empleo

Role Purpose

The Business Intelligence Analyst is responsible for centralizing, analyzing, and visualizing business data across Marketing, CRM, Leasing, Operations, and Revenue to provide a single source of truth for the organization.

This role builds dashboards, develops reports, analyzes the end-to-end customer journey, identifies business trends and performance gaps, audits and optimizes marketing/CRM automation workflows, and delivers actionable insights that support decision-making across Rent Ready Homes and other assigned brands.

Key Responsibilities

• Build and maintain dashboards in Metabase, Looker Studio, and other BI tools.
• Create weekly and monthly executive reports.
• Analyze the complete customer journey, from lead generation through signed lease.
• Monitor marketing, CRM, leasing, occupancy, and revenue performance.
• Identify funnel bottlenecks, conversion opportunities, and operational inefficiencies.
• Audit and optimize automation workflows in Go High Level (lead routing, nurture sequences, follow-up cadences) to close gaps identified through reporting.
• Consolidate data from platforms such as AppFolio, Go High Level, GA4, Meta Ads, Google Ads, and CRM systems.
• Ensure KPI accuracy and maintain standardized reporting across brands.
• Present findings and actionable recommendations to the Marketing Director and Brand Managers.

Core KPIs

• Lead Volume
• Qualified Lead Rate
• Lead-to-Lease Conversion
• Speed to Lead
• Response Time
• Tour Rate
• Application Rate
• Lease Conversion Rate
• Occupancy Rate
• Revenue Performance
• Funnel Performance
• Property Performance

Qualifications

• 3+ years of experience in Business Intelligence, Data Analytics, or Marketing Analytics.
• Strong analytical and problem-solving skills.
• Experience creating dashboards and executive reports.
• Ability to translate data into business insights.

Technical Skills

Required

• SQL
• Metabase or Looker Studio
• Google Analytics 4 (GA4)
• Advanced Excel / Google Sheets
• Google Ads & Meta Ads
• Go High Level (GHL) — workflow and automation configuration

Preferred

• AppFolio
• BigQuery
• AI tools (ChatGPT, Claude, Gemini) for reporting and data analysis.

Success in this Role

Success means providing leadership with accurate dashboards, reliable reporting, and actionable insights that improve marketing performance, leasing conversion, occupancy, and revenue — while also keeping automation workflows healthy and up to date — creating a unified view of the business across all data sources and brands.