Sr Revenue Analyst

James
R Johnson

Applying data science to the decisions that matter — where to build, how to price, who to target, and what it's all worth.

~/
10+
Years in Analytics
50+
Sites Evaluated
C-Suite
Audience
ML + GIS
Toolkit
Scroll

// About

Data at the
decision layer

I'm a Senior Revenue Analyst with a decade of experience turning complex data into decisions that leadership can act on. My work sits at the intersection of applied statistics, spatial science, and business strategy.

I specialize in site selection — building models that predict revenue potential before a single shovel hits the ground. I also own pricing and promotion analytics, customer segmentation, and financial performance reporting for executive audiences.

The goal is always the same: reduce uncertainty, sharpen the story, and make the right call easier.

📍

Site Selection

Trade area modeling, cannibalization analysis, greenfield scoring

💰

Pricing & Promo

Elasticity models, lift measurement, competitive response analysis

🗺️

Geospatial

GIS, spatial regression, drive-time analysis, demographic mapping

👥

Customer Intel

Segmentation, LTV modeling, behavioral cohorts, churn prediction

// Expertise

The full stack

From raw query to boardroom slide — analytics, modeling, spatial science, and the communication that makes it land.

⚙️

Analytics & Modeling

Statistical Modeling 95%
Machine Learning 88%
Forecasting 92%
A/B Testing & Causal Inference 85%
🌍

Geospatial & Data

GIS / Spatial Analysis 90%
SQL 97%
Python 88%
R 82%
📊

Business Intelligence

Executive Storytelling 94%
Power BI / Tableau 90%
Financial Modeling 88%
Revenue Strategy 91%

Tools & Technologies

PythonRSQLPostgreSQLPostGISQGISArcGISdbtPower BITableauExcelscikit-learnpandasGeoPandasXGBoostProphetJupyterGitDatabricks

// Projects

Work that ships

A selection of analyses, models, and tools — each one built to answer a real business question.

📍 Site Selection · ML

Greenfield Site Scoring Engine

Gradient-boosted model predicting first-year revenue for candidate locations. Inputs: drive-time trade areas, competitor proximity, demographic clusters, traffic counts. Deployed to an interactive executive dashboard.

+18% accuracy vs. prior heuristic model

XGBoostPostGISPythonPower BI
💰 Pricing · Econometrics

Price Elasticity Framework

Category-level own- and cross-price elasticity models across 300+ SKUs. Used to simulate margin impact of promotional scenarios before execution. Presented quarterly to VP of Merchandising.

3 major promotions re-structured, +$2M margin recaptured

RRegressionSQLExcel
👥 Customer Analytics · ML

Customer Lifetime Value Segmentation

RFM + ML segmentation model identifying high-value, at-risk, and lapsed customer cohorts. Outputs feed CRM targeting for personalized retention campaigns.

12% improvement in retention campaign ROI

PythonK-MeansDatabricksSQL
🗺️ Site Selection · Spatial

Trade Area Cannibalization Model

Gravity-based spatial model quantifying revenue transfer between existing and proposed locations. Used to refine network expansion plans and reduce overlap risk.

Informed 8 go/no-go site decisions

GeoPandasSpatial RegressionQGIS
📊 BI · Reporting

Executive Revenue Dashboard

Weekly automated reporting package for C-suite: comp sales, traffic trends, margin by segment, and forecast vs. actuals. Built for speed — updates in under 60 seconds.

Used by CEO, CFO, and 6 VPs weekly

Power BISQLPythondbt
📈 Causal Inference · Analytics

Promotion Lift Measurement Pipeline

Quasi-experimental pipeline measuring incremental unit and revenue lift for promotional events. Uses synthetic control and difference-in-differences methods.

Monthly cadence across 40+ promos/yr

PythonCausal InferenceSQL

// Contact

Let's talk

Interested in analytics consulting, speaking about applied data science, or just want to connect? Send a message below.