Hi, I'm Paulo Silva
Senior Data Engineer
Data Engineering
Scalable pipelines, reliable data. Snowflake, dbt, AWS.
Business Automation
300+ businesses on autopilot. 8 years, zero errors.
AI Engineering
LLMs, MCP, RAG in production. Claude, GPT, AI PM.
Work Experience
End-to-end ownership across ingestion → transformation → modeling → visualization → adoption, leading cross-functional teams and driving technical roadmaps.
Data Meaning
Associate Senior Data Engineer
2020 - Present · Data Engineering
- •Full Snowflake ecosystem ownership: architecture, performance tuning, cost management
- •dbt modular modeling: staging, intermediate, and mart layers with incremental and snapshot strategies
- •AWS pipelines: data flows with S3, Lambda, Kinesis, and Glue for batch and event-driven workloads
- •Event and telemetry pipelines: high-volume ingestion with JS stored procedures and MERGE patterns
- •Orchestration & CI/CD: ELT workflows with Azure Data Factory, Fivetran, and automated dbt artifact deployment
- •LLM & MCP integration: automation solutions with Model Context Protocol for data operations
- •Leadership: mentoring, code reviews, technical roadmaps, cross-functional teams
Industries
Snowflake Platform
Full Snowflake ecosystem ownership: schema design, performance optimization with clustering keys and materialized views, cost management with warehouse sizing and auto-suspend.
Orchestration & CI/CD
ELT workflows with Azure Data Factory, Fivetran, and Airflow/Astronomer. Automated dbt artifact deployment for continuous execution.
dbt Modeling
Modular, incremental, and snapshot models. Data Vault 2.0, SCD Type 2
Event & Telemetry Pipelines
High-volume ingestion architectures for event and telemetry data. JavaScript stored procedures, MERGE patterns, Snowflake Iceberg tables.
Cost Optimization
Warehouse sizing, auto-suspend, clustering keys, query profiles
Keyrus
Solutions Architect / Data Engineer
2018 - 2020 · Data Consulting
End-to-end data architecture design for enterprise clients. Pre-sales technical leadership and delivery. Built ETL/ELT pipelines with SQL, Python, and Hadoop ecosystem.
Earlier Roles
DBA / Oracle Specialist / IT Support
2014 - 2018
DBA/SysOps at Bluestorm Software. Oracle Database Specialist at Alcis — PL/SQL development, Oracle Forms/Reports. IT Support at Secretaria da Educacao SP.
Data Vault 2.0 Migration
Data MeaningFull migration from SQL Server and SSIS to Data Vault 2.0 using dbt and Snowflake. Redesigned data architecture with hubs, links, and satellites for scalability and auditability.
SQL Server → Databricks Migration
Data MeaningMigrated SQL Server workloads to Databricks. Converted SSIS jobs to PySpark, redesigned ETL pipelines for lakehouse architecture.
Marketing Data Lakehouse
Data MeaningImplemented Data Lakehouse in Databricks for marketing data. Ingestion, transformation, and modeling of campaign data, segmentation, and attribution.
FlavorPair AI
PoC · Side ProjectAI application that identifies ingredients from dishes, derives flavors, and discovers which combinations work. Based on the scientific food pairing algorithm. Lightweight PoC — DuckDB and Python only.
Streamlit DataApps
Data MeaningBuilt Streamlit DataApps for Marketing teams. Dynamic Tables, interactive dashboards, and data visualizations for decision-making.
Automated Data Team Workflow
Claude Code · MCPEnd-to-end automation of the data team workflow using Claude Code: from Jira ticket creation to production deployment. MCPs, specialized agents, and plugins for orchestration.
psilva.io
This PortfolioInteractive CV with AI-augmented SDLC. SSR prerender, bilingual i18n (PT-BR/EN), and automated SEO.
Business Automation
300+ businesses running on autopilot since 2018. Zero support tickets.
Process Automation
Workflows that run your business without you
Spreadsheet Automation
Excel & Google Sheets on autopilot
Financial Automation
Reports, reconciliation, cash flow
Nota Fiscal
NF-e/NFS-e emission and tracking automated
Legal Processes
Contract management, deadlines, filings
CRM & Sales Pipelines
Leads captured, followed up, closed
WhatsApp & Customer Service
Chatbots, auto-responses, routing
ERP Integrations
Omie, Bling, Tiny connected to everything
Billing & Collections
Collections on autopilot, nothing slips
Reports & Dashboards
Real-time visibility, zero manual work
From micro-businesses to enterprises. If it's repetitive, it should be automated.
AI Engineering
LLMs, agents, and AI infrastructure in production
Claude Code
Power user — AI-assisted development with Claude Code CLI
MCP Servers
Model Context Protocol server development for tool integration
RAG Pipelines
Retrieval-Augmented Generation pipeline architecture in production
LLM Integrations
Claude, GPT, and open-source models integrated into business workflows
AI Product Management
AI product management — from concept to production
GPT Integrations
Custom assistants and fine-tuning for specific use cases
Education
MBA in Information, Technology and Innovation
Universidade Federal de São Carlos
Bachelor of Information Systems
União das Instituições Educacionais do Estado de São Paulo