01
Data & Business Intelligence
Turn scattered data into useful insights, dashboards and better decisions.
BI · Data Engineering · AI · Automation
Make Data UsefulMake Work Simple
Hi, I'm Guillermo. I turn complex data and messy processes into practical solutions.
How I Can Help
Practical solutions for the work that matters.
The starting point is always the business problem. The technology follows from there.
02
Process Automation
Reduce repetitive work through automation and smarter workflows.
03
Digital Solutions
Build focused internal tools, integrations and modern business solutions.
04
Artificial Intelligence
Apply AI where it creates practical value for people and processes.
From Problem to Value
Work with a practical outcome.
A few data products and platforms I’ve designed and shipped end to end.
Data + AutomationAutomating Corporate Indicators
An approved, anonymized story of automating indicator calculation and consolidation for faster executive reporting.
PythonSQLDatabricks
Artificial IntelligencePractical AI for Audit Operations
A Copilot Studio and document-automation workflow designed to make audit information easier to access and use.
Copilot StudioAI BuilderPower Automate
AutomationContinuous Audit Process Automation
Redesigning recurring audit processes using data pipelines, automation and self-service reporting.
SQLPythonPower BI
Data EngineeringReliable Real-World Data Foundation
Centralizing data in Snowflake and building dbt models designed for data quality and analytical scale.
SnowflakedbtData Quality
Demo conceptExecutive Insights Hub
A placeholder for a focused executive dashboard and decision-support case study.
Power BIData ModelingKPIs
Demo conceptIntelligent Document Workflow
A placeholder for an AI-assisted workflow that extracts, classifies and routes business documents.
AIAutomationIntegrations
About Me
Data, with a practical point of view.
I'm a Business Intelligence Engineer who enjoys turning complex processes and scattered information into useful tools people can actually use.
Over the last four years, I have worked across business intelligence, data engineering, automation and AI—helping teams make decisions faster, reduce repetitive work and build stronger foundations for their data.
What guides my work
- Understand the real problem first
- Keep solutions practical and usable
- Build with people and adoption in mind
- Measure the value created
Based in Lima, Peru · Remote
Experience
Professional timeline.
Roles where I built solutions across business intelligence, data engineering, automation and AI.
Dec 2025 — Present
Business Intelligence Engineer II
Qualifacts · Remote · Tennessee, USA
- Automating the extraction, transformation and centralization of Real World Data into a Snowflake Data Warehouse for client consumption.
- Developing and maintaining dbt data models that support data quality, scalability and analytical availability.
Jun 2024 — Nov 2025
Data & AI Analyst Sr.
Pacífico Seguros · Lima, Peru
- Built end-to-end data pipelines and dashboards used by 8+ business areas and executive stakeholders.
- Automated corporate indicators, reducing consolidation time from five days to four hours.
- Led practical generative-AI and document-automation initiatives with Copilot Studio and Power Platform.
Jul 2021 — May 2024
Data & AI Analyst Jr. / Digital Audit Intern
Pacífico Seguros · Lima, Peru
- Automated continuous audit tests, dashboards and RPA-oriented workflows with SQL, Python and Power Platform.
- Built and maintained analytics tools, documentation and technical support for the audit team.
The Way I Work
Technology should make work easier.
A solution should work technically, make sense to the people using it and create measurable value.
01
Understand first
Start with the context, people and problem—not a preferred technology.
02
Keep it practical
Choose the simplest solution that can deliver the right outcome.
03
Build for people
Create tools that fit real workflows and that people want to use.
04
Focus on value
Measure progress through time saved, clarity gained and work improved.
The Tools
Technology in service of the work.
A practical toolkit for turning a business need into a reliable solution.
Data & Business Intelligence
Power BI
SQL
Python
Pandas
PySpark
Excel
Data Engineering
Databricks
dbt
Snowflake
Azure
ETL / ELT
Data Warehousing
Automation
Power Automate
Power Apps
AI Builder
SharePoint
Office Automation
Integrations
Artificial Intelligence
Copilot Studio
RAG
Generative AI
Prompt Engineering
Azure AI
Document AI
Credentials
A focused set of certifications.
Four credentials that best reflect the data and BI work represented here.
Power BI Data Analyst Associate (PL-300)
Microsoft · Certified
Azure Data Fundamentals (DP-900)
Microsoft · Certified
Databricks Fundamentals
Databricks · Certified
SCRUM Fundamentals Certified
SCRUMstudy · Certified
Let's Talk
Let’s build something clear.
Have a data problem worth solving or a role in mind? I’d love to hear about it.