Senior Analytics Engineer · 13 Years · Fortune 500 · M.S. AI — UPenn

Data Intelligence & AI.

13+ years building executive-level dashboards and data infrastructure for Fortune 500 companies. $2M+ in operational decisions influenced. Now steering into AI.

Get in touch View projects
Scroll to explore
Currently available for new opportunities
Senior Data Analyst · Senior BI Analyst · Data Scientist · AI Engineer
01 — About

Turning data
into decisions

I'm Paco — a Senior Analytics Engineer with 13+ years building executive-level dashboards and data infrastructure for Fortune 500 companies. I've managed 190+ databases, standardized 50+ KPIs across departments, and delivered BI solutions that directly influenced $2M+ in operational decisions.

My career spans healthcare analytics (Community Health Group), energy sector (Chevron), and retail intelligence (Caliente.mx) — always at the intersection of data engineering and C-suite business impact.

Now steering toward AI, backed by a Master's in Artificial Intelligence from the University of Pennsylvania. I don't just build pipelines — I build the systems that let executives actually understand their business.

0
Years of experience
0
Databases managed
0
KPIs standardized
0
$ decisions influenced
02 — Skills

The full stack
of modern data

Analytics & BI
Business Intelligence
Tableau · Power BI · SSRS · Excel · Cubes
Tableau
Power BI
SSRS
Engineering
Data Engineering
Snowflake · SQL Server · Matillion · SSIS · ETL/DWH
Snowflake
SQL Server
ETL/SSIS
Programming
Development
SQL · Python · Playwright · REST APIs · Claude API
SQL
Python
APIs
Artificial Intelligence
AI & GenAI
Custom GPTs · Prompt Engineering · LLM Integration · Feature Engineering
Custom GPTs
Prompt Eng.
ML Collab
Compliance
Healthcare & Governance
HIPAA · GDPR · DHCS Audits · Medi-Cal/Medicare · Data Governance
HIPAA
Governance
Compliance
Architecture
Data Architecture
EDW modeling · ODS · Star Schema · Migration strategy · KPI Standardization
EDW Design
Star Schema
KPI Def.
03 — Experience

Where I've built
things that matter

Sept 2023 — Present
Senior Analytics Engineer
Community Health Group · San Diego, CA
Designed 15+ executive dashboards (Tableau/Power BI) adopted by C-suite, reducing manual reporting by 40% and influencing $2M+ in operational decisions. Migrated 10TB+ data to Snowflake via Matillion ETL, improving query performance by 20%. Standardized 50+ healthcare metrics (Medi-Cal/Medicare) ensuring DHCS audit compliance. Pioneered the org's first AI-powered tools using Custom GPTs for contracting utilization.
TableauSnowflakeMatillionCustom GPTHIPAAPower BI
Jul 2022 — Sep 2023
Senior BI Developer
Caliente.mx · Tijuana, MX
Built automated Tableau dashboards tracking $500M+ in annual bets, enabling real-time C-suite decisions during NFL/World Cup events. Defined 50+ KPIs for casino/sportsbook operations — CAC and LTV metrics became company gold standard. Collaborated with Data Science teams improving AI model accuracy by 18% for personalized recommendations.
TableauPower BIDAXKPI Design$500M tracked
Dec 2012 — Jul 2022
Lead Analytics Engineer
Chevron · Tijuana, MX
Optimized ETL pipelines (SSIS) serving 190+ databases, cutting dashboard load times by 90% for executive reviews. Standardized fuel inventory metrics across North America, reducing reporting discrepancies by 65%. Partnered with AI teams to prototype computer vision models in Python, reducing customer service time by 15%.
SSISSQL Server190+ DBsPythonNorth AmericaFortune 500
04 — Featured Projects

Three projects.
Measurable impact.

01
Chevron · Fortune 500 · Energy

ODS → ETL → DWH → BI
End-to-end pipeline architecture

Designed and owned the complete enterprise data pipeline for Chevron — from Operational Data Store through SSIS-automated ETL into a centralized Data Warehouse, delivering a BI layer adopted by C-suite for North American operations. Served 190+ databases with 90% faster load times.

190+
Databases served
90%
Faster load times
65%
Fewer discrepancies
ODSSSIS/ETLSQL ServerDWHSSASSSRSStar Schema
ODS — Operational Data Store
Raw transactional data · Source systems
ETL — Extract Transform Load
SSIS pipelines · Business rules · Cleansing
DWH — Enterprise Data Warehouse
Star schema · Fact & dimension tables
BI — Business Intelligence Layer
C-suite dashboards · KPIs · SSRS reports
Caliente.mx — Executive Dashboard · $500M+ tracked
0
Annual bets ($M)
0
KPIs defined
0%
AI accuracy gain
Bets tracked — NFL & World Cup season
Revenue sources
02
Caliente.mx · Gaming & Retail

$500M+ tracked
real-time BI at massive scale

Built automated Tableau dashboards tracking $500M+ in annual bets, enabling real-time C-suite decisions during NFL/World Cup peak events. Defined 50+ KPIs for casino/sportsbook operations — CAC and LTV metrics adopted as company gold standard. Collaborated with Data Science to improve AI recommendation model accuracy by 18%.

$500M+
Annual bets tracked
50+
KPIs defined
18%
AI accuracy gain
TableauPower BIDAXSQL ServerKPI DesignAI Collab
03
Community Health Group · Healthcare

SQL Server → Snowflake
+ AI-powered reporting

Migrated 10TB+ of healthcare data to Snowflake via Matillion ETL, cutting query times by 20% for executive reporting. Designed 15+ C-suite dashboards reducing manual reporting by 40% and influencing $2M+ in decisions. Pioneered CHG's first AI tools — Custom GPTs for contracting utilization and natural-language report exploration.

10TB+
Data migrated
40%
Less manual work
$2M+
Decisions influenced
SnowflakeMatillionTableauCustom GPTHIPAAMedi-Cal
🗄
SQL Server
On-premise · Legacy
►
❄
Snowflake
Cloud · 20% faster
AI models deployed on top of Snowflake
Contracting Utilization GPT
Active
Report Explorer — Natural Language Query
In Dev
Claims Analytics Assistant
Roadmap
05 — Education

Always building
the next capability

In Progress
University of Pennsylvania
Master of Science in Artificial Intelligence
Ivy League · Philadelphia, PA
Jan 2026 — May 2028
Completed
Purdue University
Postgraduate Certificate
Applied Generative AI
Mar 2025 — Jun 2025
GPA 3.9
Univ. Autonoma de Baja California
M.S. in ICT Management
Tijuana, Mexico
Aug 2017 — May 2019
GPA 3.8
Univ. Autonoma de Baja California
B.S. in Computer Science
Tijuana, Mexico
Aug 2008 — May 2012
Let's build
something
with data.
LinkedIn
linkedin.com/in/juanfranciscosanchezramirez
→
GitHub
github.com/JuanSanchezPortfolio
→
Email
jsanchez.contact@proton.me
→
Location
San Diego, CA · Open to remote