About Guillermo
Is your data reliable enough to support critical business decisions?
I help companies transform scattered, inconsistent and manual data processes into structured, automated and decision-ready systems.
As a Business Intelligence and Data Specialist, I work with organizations that need clarity, performance and reliability in their reporting.
For small and growing businesses, I help:
- Clean and structure messy datasets (Excel, databases, multiple sources)
- Automate repetitive reporting tasks
- Build clear and interactive dashboards in Power BI
- Centralize data into a reliable single source of truth
For more mature teams, I support:
- Data modeling for accurate and scalable reporting
- SQL query optimization and performance improvements
- ETL process design and automation
- Data quality validation and reporting reliability
My focus is simple:
Deliver structured, automated and trustworthy data solutions that drive better business decisions.
Whether you need to fix reporting inefficiencies or improve your data foundation, I provide practical and business-oriented solutions adapted to your level of data maturity.
Spanish
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- QualifactsBusiness Intelligente Engineer IIHEALTH AND WELLNESSDecember 2025 - Today (6 months)Tennessee, USA
- Participated in a Real World Data project, automating the extraction, transformation, and centralization of data into a Snowflake Data Warehouse for client consumption.
- Developed and maintained data models in DBT, ensuring data quality, scalability, and availability of analytical information.
- Pacifico SegurosData & AI Analyst Sr.HEALTH AND WELLNESSJune 2024 - November 2025 (1 year and 5 months)Lima, Peru
- Designed and implemented end-to-end data pipelines and dashboards in Databricks, Python, and SQL, enabling advanced analytics used by 8+ business areas and C-Level executives (CEO, CFO, Board) for strategic decisions.
- Automated the generation and calculation of corporate indicators, reducing consolidation times from 5 days to 4 hours and improving organizational efficiency.
- Implemented automated alerts and continuous monitoring with Python and Power Automate, streamlining periodic reviews and reducing risks in critical business processes.
- Established data governance guidelines (quality checks, SharePoint access controls, and coding standards for Python/Jupyter notebooks), ensuring traceability, standardization, and script reusability across teams.
- Led the adoption of Generative AI, developing a corporate chatbot in Copilot Studio and document automation use cases that replaced manual tasks, enabling 100+ users to self-serve queries and reducing audit report generation from 16 hours to less than 3 minutes.
- Pacifico SegurosData & AI Analyst Jr.HEALTH AND WELLNESSAugust 2023 - May 2024 (9 months)Lima, Peru
- Automated continuous audit tests using SQL/PL-SQL, Python, Power Query, and Power BI, optimizing data extraction, transformation, and visualization.
- Designed and implemented RPAs, dashboards, and Power Platform solutions (Power Automate, Power Apps, Copilot Studio), reducing the audit team's operational workload.
- Managed analytical tools within the department and supported the integration of new internal analytics solutions.
Recommendations
Be the first to recommend Guillermo
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Bachelor’s Degree in Information Systems EngineeringUniversidad Peruana de Ciencias Aplicadas2023
- Specialized Program: Multicloud Data EngineerData Science Research Perú2025
Certifications
- Databricks FundamentalsDatabricks2025
- Microsoft Certified: Azure Data FundamentalsMicrosoft2025