You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Camila Camarena De La CruzCC

Camila Camarena De La Cruz

Data Analyst, Power BI Dashboards, Python Automation

€120/day
Lima, PE
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Camila

I studied Economics because I was always attracted to understanding why things happen in a business, not just what happens. That curiosity led me to Business Intelligence almost by accident: in my first internship at Idego, I discovered that a good dashboard could answer in seconds questions that used to take days to assemble in Excel, and I haven't stopped since.
At Scania del Perú, I learned to work with financial and operational data of a large corporation, and there I also learned that automation is not just about "saving clicks": I led a pricing automation that gave the team back more than 70% of the time previously spent on repetitive tasks. Today, at Zafira Inmobiliaria, I manage the commercial CRM and built a web scraping system that consolidates competitor information from various external sources, something that was previously done manually and with delays.
I dove headfirst into Python, SQL, and Power BI because they are the tools that allow me to do what I like most: find the pattern no one saw and turn it into something actionable. I recently completed a specialization in AI for Business at ESAN to keep adding tools to that toolbox.
Now I want to put that same way of working at the service of more businesses, not just one: to help your data stop being a problem and become an advantage.
  • Spanish

    Native or bilingual

  • English

    Conversational

Remote only
Primarily works remotely

Experience

  • Zafira Inmobiliaria
    Business Intelligence Analyst
    REAL ESTATE
    December 2025 - Today (8 months)
    Lima, Peru
    •I manage the commercial CRM as a Super User, ensuring the quality, consistency, and availability of information used for commercial management and tracking.
    •I develop and track commercial indicators (KPIs) for sales, stock, prices, and revenue, identifying opportunities for improvement in project performance.
    •I execute ETL processes in SQL and Python to integrate information from multiple sources into Power BI, ensuring data quality and traceability.
    •I perform cleaning, transformation, and modeling of large volumes of raw data using PostgreSQL (pgAdmin) and Power BI.
    •I develop executive dashboards for the Commercial, Marketing, and Finance areas, facilitating data-driven decision-making.
    Achievements:
    •I designed and implemented an automated solution in Python (web scraping) that integrates 3 external sources and consolidates data from approximately 50 real estate projects for competitive analysis.
    •I implemented automated commercial dashboards connected to the CRM, replacing manual reports and enabling daily monitoring of key indicators used in commercial committees.
    Microsoft Power BI Python (Programming Language) Process Automation SQL Server Microsoft Excel
  • Scania del Perú
    Business Intelligence Intern
    TRANSPORTATION
    April 2024 - November 2025 (1 year and 7 months)
    Lima, Peru
    •I managed the commercial CRM (Microsoft Dynamics) as a Super User, ensuring the quality, consistency, and availability of information for commercial management.
    •I defined, monitored, and analyzed commercial and financial indicators (KPIs) for continuous business tracking.
    •I developed executive dashboards in Power BI for monitoring commercial and operational performance.
    •I analyzed trends, deviations, and improvement opportunities using information from the CRM and corporate databases.
    •I designed and optimized ETL processes in SQL to clean and structure large volumes of raw data from corporate databases, ensuring reliable information for decision-making.
    Achievements:
    •I automated the tracking of commercial indicators through CRM-connected dashboards, reducing report update time by 50%.
    •I led the proposal and implementation of an automated solution (RPA) for pricing analysis, which increased process efficiency by more than 70%.
  • Idego
    Business Intelligence Intern
    CONSULTING AND AUDITS
    January 2023 - March 2024 (1 year and 2 months)
    Lima, Peru
    •I developed automated reports and interactive dashboards in Power BI, providing key visibility on performance and operational indicators.
    •I analyzed and managed internal and external databases, identifying patterns and opportunities to optimize information processes.
    •I collaborated with internal teams to improve efficiency in the information flow and the quality of data used in decision-making.
    Achievements:
    •I designed and implemented an automated dashboard, adopted as a permanent consultation tool in the head office, improving the availability and clarity of information.

Recommendations

Be the first to recommend Camila

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Bachelor's Degree
    Universidad Nacional Federico Villarreal
    2024
    Bachiller
  • Specialization
    Universidad ESAN
    Especialización

Categories