Senior BI Engineer · San Diego, California

Analytics engineering, grounded in a decade of BI.

I bring more than a decade at the decision layer—across automotive, media, and healthcare—and I’m applying that experience upstream through SQL, dbt, cloud warehouses, and tested data models.

Explore the work See my experience

Open to analytics engineering and senior BI engineering opportunities.

Operating model Data workflow

Raw

Sources, events, operational systems

Reliable

Modeled, tested, documented, governed

Used

Metrics, products, experiments, decisions

The value is not the dashboard. It is the trusted path to the decision.

Featured project

A dbt project built around reliable models.

A complete analytics-engineering project built to show how raw operational data becomes reusable business context—not another isolated dashboard.

dbt + BigQuery Olist e-commerce dataset

An analytics layer for orders, customers, sellers, and delivery performance.

Raw Brazilian marketplace data is staged in BigQuery, standardized through reusable intermediate models, and published as business-ready facts and dimensions. The project is documented end to end so every mart can be traced back to its source.

Sources: 9 raw tables
Models: 16 dbt models
Quality: 34 automated tests
Delivery: 6 business marts

Explore dbt lineage Read the build notes

Transformation map BigQuery

Ingest

orderscustomersitemspaymentsreviews+4 sources

Shape

7staging models

3intermediate models

Serve

fct_orders dim_customers dim_products dim_sellers delivery performance revenue by category

Business grain first

Each published mart declares what one row represents—from a single order to a product or seller—so downstream joins and metrics begin with a stable contract.

Reusable transformation layers

Source cleanup, shared joins, and business outputs are separated into staging, intermediate, and mart layers, keeping logic readable and reducing duplication.

Visible quality

Automated uniqueness and completeness tests protect key model grains, while published documentation exposes definitions and lineage to data consumers.

Why this transition

Analytics engineering is the next step.

Analytics engineering is not a career reset. It is the natural extension of ten years spent defining metrics, reconciling source systems, earning stakeholder trust, and watching how data products succeed—or fail—in the real world.

Model for meaning

Start with grain, business definitions, and the questions a model must answer—not whichever chart comes next.

Engineer for confidence

Use version control, tests, documentation, and clear ownership to make analytical change safer and easier to review.

Deliver for adoption

Build the semantic bridge from warehouse logic to the language operators and leaders already use.

Additional work

Analytics and machine-learning projects.

Selected work in predictive modeling and retrieval systems, kept deliberately secondary to the analytics-engineering story.

NLP · Retrieval systems

Clinical decision support over vetted medical references

A local Llama model grounded through LangChain and ChromaDB to answer diagnostic, medication, and treatment questions from the Merck Medical Manuals.

RAGgrounded retrieval

View notebook ↗

Machine learning · Classification

Visa certification predictor trained on 775,000+ applications

An ensemble classification study that prioritized recall and surfaced wage-to-prevailing-rate ratio as the dominant approval signal.

0.82F1 score

View notebook ↗

Machine learning · Forecasting

Retail sales forecasting for inventory planning

A tuned XGBoost model estimating quarterly supermarket revenue across products, store formats, and cities.

6.45%MAPE

View notebook ↗

Experience

Professional experience.

Enterprise analytics across mobility, streaming media, healthcare operations, and customer experience.

2024—NowAutomotive

Senior Business Intelligence Engineer

Ford Motor Company

Own end-to-end Power BI delivery across business functions, from requirements and modeling through deployment. Led a mission-critical Qlik Sense migration for Ford Pro Charging and introduced NLP-based categorization into customer-experience reporting.

Power BI
SQL
DAX
Python

2022—2024Media

Senior Data Analyst / Tableau Developer

Warner Bros. Discovery · MotorTrend

Established the analytics foundation for a new FAST business vertical, integrating Redshift data with executive Tableau reporting. Led MotorTrend’s first A/B testing program and improved recurring report delivery.

46% lift in ad impressions
30% faster reporting

2019—2022Healthcare

Senior Data Analyst

Kaiser Permanente · KP OnCall

Unified Genesys, Clarity, and KPATHS data into consolidated operational reporting for a healthcare contact center, reducing silos and shortening the path from question to action.

Tableau
SQL
Multi-source modeling

2015—2019Automotive

Business Intelligence Analyst

General Motors

Built a standardized customer-experience reporting platform deployed across contact centers in more than ten countries and engineered datasets supporting data monetization and product decisions.

10+ countries
Teradata
Tableau
Cognos

Toolkit

Tools and platforms.

Technical range spanning transformation, warehouse platforms, semantic delivery, experimentation, and applied AI.

Transform & model

SQL · dbt · dimensional modeling · DAX · Python

Store & operate

BigQuery · Amazon Redshift · Teradata · Oracle · Hive

Define & deliver

Power BI · Tableau · Sigma · Qlik Sense · semantic metrics

Learn & optimize

A/B testing · Amplitude · machine learning · NLP · retrieval systems

Education

AI/ML: Business Applications

Post Graduate Program · The University of Texas at Austin

Foundation

Management Information Systems

Bachelor of Science · Florida State University

Credentials

Cloud, SQL & analytics

GCP Cloud Digital Leader · Tableau Qualified Associate · HackerRank Advanced SQL

Open to analytics engineering and senior BI roles.

I’m open to analytics engineering and senior BI engineering roles where reliable data, clear metrics, and adoption all matter.

jab09c@gmail.com