Juan Camilo Rodríguez Arcos

Juan Camilo Rodríguez Arcos

About

Detail

Growth Specialist | Business Consultant | Business Strategy, Leadership | Data Analyst | Real Estate Entrepreneur
Bogotá, Cundinamarca, Colombia

Contact Juan regarding: 
work
Full-time jobs
Starting at COP8M/month ~USD2.32k/month
Flexible work
Starting at USD38/hour
groups
Networking

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Cabify
    Growth Specialist
    Cabify
    May 2025 - Current (1 year 2 months)
    • Developed user segmentation models using behavioral and transactional data to drive targeted growth strategies. • Optimized incentive structures through A/B testing and cohort analysis, increasing conversion and retention rates. • Automated KPI tracking and performance dashboards using Tableau. • Collaborated cross-functionally to implement lifecycle campaigns and pricing experiments based on ride frequency and price sensitivity. • Utilized SQL daily to query and join large operational and user datasets from our internal data warehouse, ensuring accurate data analysis. Combined advanced Excel skills, including Power Query, pivot tables, XLOOKUP, and complex formulas, to clean, transform, and analyze ride performance, retention coh
  • O
    Business Consultant
    Ofi services
    Nov 2024 - Feb 2025 (4 months)
    • Integrated enterprise systems with Celonis to automate workflows and visualize real-time data. • Led ETL processes, built SQL queries, and developed dashboards to support data-driven decisions. • Created apps and automated flows that increased client operational efficiency by up to 30%.
  • N
    Consulting Analyst
    Nextant LLC
    Nov 2023 - Oct 2024 (1 year)
    • Supported the Microsoft Worldwide Learning division by analyzing employee development KPIs and course completion rates. • Assisted in the planning and scheduling of global training initiatives, improving internal engagement metrics. (WWL) • Delivered actionable dashboards using Excel and Power BI to inform decision-making processes. • Provided IT consultancy for process optimization and digital learning adoption, while also leveraging data management skills to collect, organize, and maintain large operational datasets related to global training schedules and resource allocation. This included creating structured tracking systems and documenting data sources, definitions, and transformations to ensure accuracy and consistency across
  • Consultandes
    Junior Consultant
    Consultandes
    Feb 2023 - Jun 2023 (5 months)
  • L
    Legal Representative & Business Developer
    Lodgi Rentals (formerly HOKAR SAS)
    Feb 2023 - Current (3 years 5 months)
    • Founded and led real estate operations focused on mid-to-long-term rentals for corporate and expatriate clients. • Generated and nurtured a pipeline of over 30 monthly leads through inbound and outbound strategies. • Negotiated rental agreements with international clients, achieving a client lifetime value (LTV) of over $10M COP. • Managed digital marketing campaigns and CRM tracking to optimize acquisition and conversion rates. • Centralized and managed operational and financial data from multiple property owners, platforms, and banks, enhancing overall data management practices. • Built and maintained advanced Excel models to analyze revenue, expenses, occupancy, and ROI, normalizing heterogeneous data for better comparability
  • A
    Research Assistant
    ANEIA-Agribusiness, Food Industry, and Ecotourism
    Feb 2023 - Jun 2023 (5 months)
    • Researched sustainable agribusiness trends under former Minister Carlos Gustavo Cano, contributing to eco-friendly market strategies. • Utilized Google Sheets to collect, clean, and analyze field data, including rainfall, soil pH, temperature, and planting density from multiple farms, enhancing the accuracy of research findings. • Developed dynamic spreadsheets with advanced formulas to automate data consolidation, significantly reducing manual work and increasing efficiency. • Created interactive dashboards featuring pivot tables, slicers, and conditional formatting to visualize crop performance and trends, while applying forecasting functions to predict yields under various climate scenarios.
Education verified_user 0% verified
  • Pontificia Universidad Javeriana
    Entrepreneurship Mentoring Program
    Pontificia Universidad Javeriana
    May 2025 - Jul 2025 (3 months)
    • Entrepreneurship Mentoring Program – Pontificia Universidad Javeriana Completed the 36-hour program “12 herramientas que incrementarán tus ventas” focused on sales growth, mentoring, and go-to-market strategies (May – Jul 2025).
  • Universidad de los Andes
    Capital Markets and Portfolio Structuring Bootcamp
    Universidad de los Andes
    Jan 2025 - Mar 2025 (3 months)
    • Conducted technical analysis and trading simulations to evaluate market trends and key indicators. • Analyzed stock indices, public bonds, and their correlation with macroeconomic variables. • Studied monetary and fiscal policies, as well as foreign exchange market dynamics. • Applied Markowitz's portfolio theory to optimize risk-return efficiency in investment strategies.
  • Universidad de los Andes
    Diploma in Entrepreneurship and Accelerated Business Scalability (PEMP)
    Universidad de los Andes
    Aug 2024 - Nov 2024 (4 months)
  • E
    Diploma in Business Valuation
    Escuela de Administración y Negocios
    Mar 2022 - May 2022 (3 months)
    Certificate on DCF, M&A, and risk analysis.
  • Universidad de los Andes
    Business Administrator (BBA)
    Universidad de los Andes
    Feb 2018 - Jun 2023 (5 years 5 months)