Zulay Hurtado · Data Engineering · AI Automation · Analytics

Data Engineer &
AI Automation Specialist

I build data pipelines and AI-powered automations that connect data, systems and business decisions.

View selected projects →Contact

BUILD THE SYSTEM → UNDERSTAND THE DATA → AUTOMATE THE WORK → TURN IT INTO DECISIONS

BIGQUERYGCPSQLPYTHONN8NAPISAI

System Architecture

CONNECTED SYSTEMSDATA → ACTION

SourcesCRM · APIs · Files

IngestionAPI · Webhooks

Data EngineeringClean · Transform

Automation + AIn8n · Agents

Data LayerBigQuery · PostgreSQL

Decision / ActionAnalytics · Ops

01 / In simple terms

Not technical?
Here’s what I actually do.

Businesses have data everywhere — CRMs, spreadsheets, APIs, databases and different platforms. I connect it, automate it and turn it into systems people can actually use.

BeforeFragmented operations

CRM
Spreadsheets
APIs
Manual processes

What I buildConnected systems

Data Engineering
Automation
AI where it adds value

AfterUsable infrastructure

Centralized data
Automated workflows
Intelligent decisions
Useful insights

In simple terms: I make systems talk to each other, data flow automatically, and AI work where it actually adds value.

02 / What I Build

Three connected areas.
One systems mindset.

I build the infrastructure, understand the data and automate the processes around it — then make the result useful for people and decisions.

01 / DATA ENGINEERING

Data Engineering

Data pipelines, ETL/ELT, APIs, data warehousing and analytics-ready data.

BIGQUERYSQLGCPETL/ELT

02 / AI & AUTOMATION

AI & Automation

AI agents, LLM workflows and intelligent automation for real business processes.

N8NAPISWEBHOOKSAI AGENTS

03 / ANALYTICS

Analytics & Visualization

Business and marketing analysis, KPIs and dashboards that turn data into decisions.

LOOKER STUDIOPOWER BISQLKPIS

03 / Impact

Systems measured
by what they improve.

A few verified outcomes from real data and automation work.

Client data platforms

Built and maintained across multiple operations.

~60%

Lead-handling improvement

Through automated qualification, cleaning and filtering.

~100%

Faster CRM reporting

By replacing recurring manual data pulls with automated integrations.

04 / Selected Projects

What I built.
How it works. Why it matters.

Three confidential projects showing the systems, data flows and technical decisions behind my work. Expand any case study for the deeper view.

Confidential Project · Data Engineering + Analytics

CRM Data Platform & Marketing Analytics

A CRM data pipeline that connects campaign and lead-source data with commercial outcomes, centralizes it in BigQuery, and supports analysis in Looker Studio.

REST APIN8NBIGQUERYLOOKER STUDIOCRM

Architecture / Sanitized

Campaign / Source→CRM→REST API→n8n→BigQuery→Analysis→Looker Studio

The Challenge

Connect acquisition and commercial data.

Marketing and commercial information needed to be connected to understand where leads came from and how acquisition and funnel data could be analyzed together.

What I Built

CRM integration through APIs
Campaign / lead-source identification
Automated extraction and transformation with n8n
Structured data in BigQuery
Data analysis and Looker Studio visualization

Technical Architecture

Marketing Campaign / Lead Source→CRM→REST API→n8n→Clean & Transform→BigQuery→Data Analysis→Looker Studio→Insights & Decisions

Analytics / Business Questions

Which campaigns generate the most leads?Which acquisition sources perform better?How are leads distributed across campaigns?What happens to leads after acquisition?

Business Value / Impact

One view from acquisition to outcome.

The pipeline makes marketing source and CRM funnel data analyzable together, reducing dependence on manual pulls and giving teams a clearer path from acquisition data to business decisions.

Confidential Project · AI Automation

Multimodal AI Customer Operations Agent

A customer-operations agent that processes text, audio and images, applies business logic, preserves context and escalates to a human when needed.

N8NAI / LLMSWEBHOOKSPOSTGRESQLQDRANTAPIS

Architecture / Sanitized

Text · Audio · Image→Webhooks→AI Processing→Business Logic→Context→Response / Handoff

The Challenge

Different message formats, one operational flow.

Customer conversations can arrive as text, audio, images and fragmented consecutive messages. The workflow needs to process them coherently while preserving a clear human escalation path.

What I Built

Webhook and HTTP Request integrations
JSON processing and message normalization
Intelligent buffering before agent processing
LLM-driven business logic and automated responses
PostgreSQL context and Qdrant-supported retrieval
Human handoff for cases that need intervention

Technical Architecture

Text / Audio / Image→Webhooks + HTTP→JSON Processing→AI Processing→Business Logic→PostgreSQL / Qdrant→Automated Response→Human Handoff

Engineering Detail

Context before response.

An intelligent buffer consolidates fragmented consecutive messages before the agent processes the conversation, avoiding isolated responses to pieces of the same interaction.

Business Value / Impact

Automation without removing human control.

The system can handle multiple input formats and routine processing automatically while keeping escalation available for complex or sensitive cases.

Confidential Project · AI + Financial Data

Multi-Agent Financial Intelligence

A financial data workflow that extracts documents, structures information in BigQuery and routes questions to specialized AI agents for analysis and reporting.

GOOGLE DRIVEN8NBIGQUERYAI AGENTSOPENAISLACK

Architecture / Sanitized

Google Drive→PDF / CSV→n8n→BigQuery→AI Agents→Reporting

The Challenge

Turn financial documents into queryable intelligence.

Invoices, banking records and other financial files needed to become structured data, while different questions needed to be routed to the right analytical specialty instead of one generic path.

What I Built

Google Drive document intake
PDF / CSV extraction and processing
n8n orchestration
Structured financial data in BigQuery
Specialized AI agents for billing, banking and reconciliation analysis
Reporting and interaction through the existing workflow

Technical Architecture

Google Drive→PDF / CSV Extraction→n8n→Data Processing→BigQuery→Specialized AI Agents→Financial Intelligence / Reporting

How It Works

Specialized routes, shared data layer.

Documents are processed into structured financial data, then specialized agents handle billing, banking and reconciliation questions using the same centralized information.

Business Value / Impact

From files to usable financial context.

The system reduces the gap between document intake and financial analysis by making extracted information structured, queryable and available to specialized analytical workflows.

05 / How It Comes Together

One connected path
from source to decision.

The tools change by project. The pattern is consistent: connect the source, engineer the data, automate the workflow, add AI where it helps, and expose the result for action.

End-to-end capability map

SourcesCRM · APIs · Files

Data EngineeringIngest · Clean · Model

Data LayerBigQuery · PostgreSQL

Automation + AIn8n · Agents · RAG

AnalyticsSQL · Looker · Power BI

Decision / ActionPeople · Systems

06 / Toolkit

Grouped by the work
they help me do.

A focused toolkit across data engineering, integration, AI and analytics — without treating tools as the story.

Data Engineering

SQL · BIGQUERY · ETL / ELT · DATA WAREHOUSING · JSON

Automation & Integration

N8N · HTTP REQUEST · WEBHOOKS · REST APIS · CRM INTEGRATIONS

AI & Intelligent Systems

LLMS · AI AGENTS · RAG · QDRANT · POSTGRESQL

Cloud

GCP

Analytics & Visualization

LOOKER STUDIO · POWER BI · DATA ANALYSIS · DATA VISUALIZATION · KPIS

07 / About Me

I turn messy processes
into systems that make sense.

I’m a Data Engineer and AI Automation Specialist who enjoys turning messy processes into systems that make sense.

My work sits between data engineering, automation and AI — connecting the technical pieces so teams can spend less time moving information around and more time using it.

I’m especially interested in building practical systems that are reliable, scalable and useful in the real world.

DATA ENGINEERINGAI AUTOMATIONANALYTICS

LinkedIn →

08 / Contact

Let’s build
something useful.

Open to roles, collaborations and technical projects across data engineering, AI automation and analytics systems.

Emailzulayredesociales@gmail.com Phone+593 96 276 2165 LinkedInProfessional profile ↗Instagram@zulayhurtado_ ↗

Data Engineer &AI Automation Specialist

Not technical?Here’s what I actually do.

Three connected areas.One systems mindset.

Data Engineering

AI & Automation

Analytics & Visualization

Systems measuredby what they improve.

What I built.How it works. Why it matters.

CRM Data Platform & Marketing Analytics

Multimodal AI Customer Operations Agent

Multi-Agent Financial Intelligence

One connected pathfrom source to decision.

Grouped by the workthey help me do.

Data Engineering

Automation & Integration

AI & Intelligent Systems

Cloud

Analytics & Visualization

I turn messy processesinto systems that make sense.

Let’s buildsomething useful.

Data Engineer &
AI Automation Specialist

Not technical?
Here’s what I actually do.

Three connected areas.
One systems mindset.

Systems measured
by what they improve.

What I built.
How it works. Why it matters.

One connected path
from source to decision.

Grouped by the work
they help me do.

I turn messy processes
into systems that make sense.

Let’s build
something useful.