Available for new projects

James
Brooks

Senior BI Developer & Data Analyst

10+ years translating complex data into decisions that actually get made — across automotive, media, and healthcare. I build Power BI and Tableau solutions end-to-end, from the data model to the dashboard, with Python and AI/ML increasingly in the mix.

bash — ~/projects/churn-propensity
10+yr experience
4 industries
46% best A/B lift

What I work with

Modeling
SQL dbt DAX Python
Warehouses
Amazon Redshift Google BigQuery Teradata Oracle MongoDB Hive
BI Delivery
Power BI Tableau Tableau Prep Sigma QlikSense
Analytics & AI
A/B Testing Amplitude Adobe Analytics Machine Learning NLP GenAI

Selected projects

EasyVisa — Visa Certification Predictor

ML

Ensemble classifier trained on 775K+ OFLC employer applications to predict US work visa certification outcomes. Tuned Random Forest achieved F1=0.82 with 87% recall — wage-to-prevailing-rate ratio surfaced as the dominant approval signal.

Pythonscikit-learnRandom ForestXGBoostGBM

SuperKart — Retail Sales Forecasting

ML

Predicted quarterly revenue for a multi-city supermarket chain using tree-based ensemble regressors. Tuned XGBoost delivered R²=0.90 and MAPE=6.45%, enabling reliable inventory planning and data-driven procurement decisions at scale.

PythonXGBoostscikit-learnPandasSeaborn

AllLife Bank — Loan Propensity Model

ML

Classified which bank customers are likely to purchase personal loans, optimizing for recall to catch every potential buyer. Pre-pruned decision tree hit AUC=0.97 with perfect recall — income and monthly credit spend were the strongest predictors.

Pythonscikit-learnDecision TreePandas

Clinical Decision Support — Medical RAG

NLP

RAG pipeline over the Merck Medical Manuals to assist clinicians with diagnostics, drug lookups, treatment protocols, and critical care queries. LangChain + ChromaDB retrieval grounds a local Llama LLM in vetted medical sources, reducing hallucination risk in high-stakes scenarios.

PythonLangChainChromaDBLlamaHuggingFace

HelmNet — Safety Helmet Detector

Deep Learning

Transfer learning pipeline (VGG-16 + FFNN) to detect helmet compliance from construction site camera images. Trained on 631 images across varied lighting and angles with data augmentation — achieved 100% test accuracy and a perfect confusion matrix.

PythonTensorFlowVGG-16KerasOpenCV

FoodHub — Order Data Analysis

Analytics

Exploratory analysis of a food aggregator's order dataset to surface demand patterns by cuisine type, delivery timing, and customer ratings. Identified a 5.87-minute weekday delivery lag and proposed targeted promotions to close the gap and drive retention.

PythonPandasMatplotlibSeaborn

Olist — E-Commerce Analytics Pipeline

dbt

End-to-end dbt project on BigQuery modeling the Olist Brazilian e-commerce dataset. Raw Kaggle CSVs are loaded to BigQuery, staged, transformed through an intermediate layer, and surfaced as business-ready marts covering order performance, customer LTV, seller rankings, revenue by category, and delivery efficiency.

dbtBigQuerySQLPythonGCP

Career

Apr 2024 — now

Senior Business Intelligence Engineer

· Ford Motor Company — San Diego, CA

Architect and deliver end-to-end Power BI solutions across multiple business functions, owning the full lifecycle from requirements to deployment. Led Qlik Sense → Power BI migration for Ford Pro Charging, converting mission-critical dashboards and giving ops teams real-time metrics to diagnose and resolve issues faster. Designed an AI-powered CX dashboard with NLP-based survey categorization to surface recurring issues and reduce manual analysis time. Currently building a predictive sales dashboard layering AI-driven propensity models to identify likely buyers for Solution Managers.

Power BIDAXNLPPythonSQL
May 2022 — Mar 2024

Senior Data Analyst / Tableau Developer

· Warner Bros. Discovery (MotorTrend Group) — San Diego, CA

Built a proprietary Tableau report integrating three data sources for the Director of Programming and WBD CEO, delivering revenue visibility into show migration from MotorTrend to MAX. Established the analytics foundation for a new FAST business vertical — defining KPIs, architecting data ingestion into Amazon Redshift, and building Tableau reporting to support launch decisions. Led MotorTrend's first A/B testing program using Amplitude, producing a 46% increase in ad impressions served. Cut reporting turnaround by 30% through automated Tableau email subscriptions. Also managed full Tableau Server administration including upgrades and user provisioning.

TableauAmplitudeAmazon RedshiftA/B TestingSQL
Dec 2019 — May 2022

Senior Data Analyst

· Kaiser Permanente (KP OnCall) — San Diego, CA

Designed and delivered Tableau dashboards giving KP OnCall business users actionable operational insights across a healthcare contact center environment. Unified complex data streams from Genesys, Clarity, and KPATHS into consolidated reporting views, eliminating silos and reducing time-to-insight for operations leadership. Applied advanced Tableau features — LOD expressions, parameter controls, data blending, and statistical calculations — to build production-grade reports.

TableauSQLGenesysLOD Expressions
Apr 2015 — Mar 2019

Business Intelligence Analyst

· General Motors — Austin, TX

Served as subject matter expert for customer experience data, building a standardized BI reporting platform via Cognos and Tableau deployed across 10+ countries for all Customer Contact Centers. Engineered composite datasets supporting a third-party data monetization initiative and developed custom SQL to analyze mobile app usage patterns, directly informing product roadmap decisions.

TableauCognosSQLTeradata
Education

Post Graduate Program — AI/ML: Business Applications

· University of Texas at Austin

Python, Machine Learning, NLP, Neural Networks. Also holds a BS in Management Information Systems from Florida State University. Certifications: GCP Cloud Digital Leader, Tableau Desktop 10 Qualified Associate, HackerRank Advanced SQL. Completed The Complete dbt Bootcamp on Udemy.

PythonMachine LearningNLPGCPTableauSQLdbt

Let's work together

Senior BI Developer and Data Analyst open to new opportunities — Power BI, Tableau, full-stack analytics, and data-driven product work. Also growing into analytics engineering through dbt and cloud data platforms. Open to a conversation if you need someone who can take data from raw to reliable to actually used.